Google Sheets - Overview
With our workflows, you can easily send, update, or delete rows in your Google Sheets documents. This provides you with a range of options for managing your data within your sheets, depending on your specific needs.
Whether you need to add new data to your sheet, update existing data, or remove outdated data, our system enables you to do so with ease. This allows you to automate and streamline your data management processes, reducing errors and increasing efficiency.
By leveraging the power of our workflow system, you can manage your data in Google Sheets with confidence, knowing that your data is accurate, up-to-date, and easily accessible.
Actions
The following actions are now supported in Google Sheets.
Create Spreadsheet Row:
This Premium action lets you send data directly to a Google Sheets document without requiring third-party integrations. All you need to do is integrate your Google account with and select the desired sheet from your Google Drive. From there, you can easily send data to the sheet using our intuitive user interface.
Choose a Google account:
All your integrated Google accounts in your subaccount will be displayed in the dropdown menu for you to choose from.
Select a Drive:
Once you have selected a Google account from the dropdown menu in our subaccount system, all associated Google Drives will be displayed for you to choose from. This allows you to select the specific Google Drive account containing the target Google Sheets document you want to send data.
Select a Spreadsheet:
Once you have selected a Google Drive from the dropdown menu, all Spreadsheets associated with the integrated Google Drive will be displayed for you to choose from.
This allows you to select the specific Google Spreadsheet document to which you want to send data.
Select a Worksheet:
Once you have selected a Google Spreadsheet from the dropdown menu, all Worksheets inside that Spreadsheet will be displayed for you to choose from.
This allows you to select the specific Worksheet to which you want to send data.
Selecting Starting Column and End Column in the Worksheet
When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row.
If you need to update the headers in the sheet, you can click the "Refresh Headers" button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations.
Insert values to create a new row in the Worksheet:
You can insert value and create a new row in your Google Sheets document.
Update Specific Spreadsheet Row:
The "Update Specific Spreadsheet Row" action enables us to modify the contents of a specific row by specifying its row number. This action updates the values in the corresponding columns of that row.
Choose a worksheet:
Select a worksheet within your Spreadsheet that you wish to edit a row.
Insert Row Number:
Specify the row number that you wish to modify in the Spreadsheet.
You may also provide the Row Number using the Custom Variable Picker to use dynamic values.
Select the Starting Column and ending column:
To update the desired columns, select the starting and ending columns.
You can leave it blank if you do not wish to update a particular column.
Delete Specific Spreadsheet Row:
The "Delete Specific Spreadsheet Row" action enables us to delete the contents of a specific row by specifying its row number. This action will clear the values in all of the columns of that row.
Note: When you use the "Delete Specific Spreadsheet" action, it clears the contents of the row, but it does not permanently remove the row itself.
Choose a worksheet:
Select a worksheet within your Spreadsheet that you wish to delete a row of.
Insert Row Number:
Specify the row number that you wish to delete in the Spreadsheet.
Note:
You may also provide the Row Number using the Custom Variable Picker to use dynamic values.
When you use the "Delete Spreadsheet Row" action, it clears the contents of the row, but it does not permanently remove the row itself.
You can review our help article ‘Google Sheets - Lookup Spreadsheet Row’ and ‘Google Sheets-Lookup Multiple Rows’ to learn more about lookup in detail.
Notes:
To ensure that your data flow to your Google Sheets document is not disrupted, it is crucial that you do not change the sheet name or worksheet name associated with the document. This is because any changes to the name could break the connection between our workflow system and the document, potentially resulting in errors or data loss.
However, you are able to change the column names within the sheet as needed. If you do so, it is important to update the column names in your workflow to ensure that data is properly mapped to the correct columns. Failure to do so could result in errors or data loss, as data may be mapped to the wrong columns or not mapped at all.
You can even use FORMULAS, and spreadsheet functions to insert rows.
This can help you calculate SUM, AVG, or any metric that you wanna run down.