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.