Add Google Sheets Row
Automate data entry and streamline your workflow by adding new rows to a Google Sheets worksheet with the specified column mapping values.
Last updated
Automate data entry and streamline your workflow by adding new rows to a Google Sheets worksheet with the specified column mapping values.
Last updated
This Step adds new rows to a Google Sheets worksheet using the specified column mapping values.
This step is only available for Business Plan and above.
There are three key configurations for adding a new row to Google Sheets:
Google Sheets
Worksheet (Tab)
Column Mapping
Select the Google Sheets file you want to populate.
Make sure you have editing access to the worksheet you are trying to connect to.
Once you've chosen the desired Google Sheets file, select the worksheet or tab you want to populate.
Ensure that the sheet name doesn't contain punctuation and that the first row of the worksheet is a header row with filled-in column names. If Column A's first row has a missing value, data will be inserted at the top of the sheet, not at the bottom.
After determining the worksheet or tab, open the Column Mapping configuration drawer. You can configure up to 26 columns (Column A to Column Z).
Fill in the column fields with the desired data. To include Variables, use the "$" prefix to support the interpolation of static text and Variables. You can also use system variables as the Column Mapping value to timestamp when new Google Sheet Rows are added, helping you track events.
For Google Sheets calculations, add the formula in the relevant field to automatically calculate and display the value when a new row is added to the worksheet.
If you want to leave a column blank in the sheet, leave its field in the configuration drawer empty.
To update the worksheet and column mapping fields, click on the refresh button in the configuration drawer.
When the Workflow is triggered, the values specified in the column mapping field will be added to the Google Sheets worksheet, creating a new row at the bottom of the table to display the data.
When editing a worksheet, first stop the Workflow. Then, update the column fields in the Step configuration drawer before republishing the Workflow to reflect the changes. Failing to do so may result in a data mismatch between the Workflow input and the new rows in the worksheet.
Editing a worksheet involves the following actions:
Deleting existing rows or columns
Adding rows anywhere other than at the bottom of the worksheet
Changing the column sorting of the sheet
Renaming, adding, or rearranging columns
Renaming the workbook or the worksheet
The Add Google Sheets Row Step can encounter two potential failures:
Lack of editing permission for the chosen Google Sheets file.
The selected worksheet has reached its cell limit or is already full.
In such cases, the contact will bypass this Step and continue with the rest of the Workflow's journey.
Here’s a best practice for this step you can follow to optimize your workflow:
Avoid updating the sheet tab name or the main worksheet name after setting up the step. Doing so will stop the data population in the sheet and necessitate reconfiguring the step. Define the required headers in the Google Sheets first before setting up the Workflow step.
Here are some ways you can use the Add Google Sheets Row Step:
Save time with automated data entry: Reduce manual efforts by adding data automatically to Google Sheets. Connect a Google Sheet to create a new row with variables added to specific columns.
