Skip to main content
All CollectionsReporting on Google SheetsRecord Data in Bkper from Google Sheets
Record Groups from Google Sheets with Custom Properties
Record Groups from Google Sheets with Custom Properties
Updated over 11 months ago

Freeze the first row of your Sheet

By freezing the first row on your Google Sheet you unlock several functionalities that optimize your workflow when you record groups.

Bkper System Properties for Groups

On the frozen first row, Column Titles that use a System Group Property will be interpreted as such by the add-on. System Group Properties are:

Name: The name of the group to be created.

Parent: The name of the parent group of the group to be created.

BookId: The BookId where the new groups should be created. - This BookId overrules the book selected on the Add-on.

The Column Title Name is necessary since a Bkper Group must have a name in order to be created.

Record Groups with Custom Properties

In the frozen first row, Column Titles that are NOT System Group Properties will be interpreted as Group Custom Property keys.

Did this answer your question?