This procedure allows you to configure the automation so that data is always added to the first available empty row of your Google Sheet.
1. In the Google Sheets Settings section, make sure that the Action field has the option Set cell value selected.
2. Locate the configuration block where you are defining the cell and the value to write (under the Action header).
3. In the field labeled Row, make sure that the field is left completely empty.
4. When the Row field is empty, you will see the placeholder text New row. This indicates that the automation will automatically calculate the next free row on which to write data.
5. Normally fill in the Column fields (for example: A, B, C etc...) and Value (the data you want to enter).
Result: Each time the automation runs, the system will look for the first available empty row and write data in that position.
