How to handle multiple rows in Google Sheets in Workflow on GoHighLevel

What are the new features?

Our Google Sheets action has received an upgrade, introducing a range of new Action Types for enhanced functionality. You can now choose to “Create Multiple Spreadsheet Rows” or “Update Multiple Spreadsheet Rows” with ease.

Create Multiple Spreadsheet Row(s)

Effectively add new data rows beneath current information in your spreadsheet. This function enables you to input data directly into a Google Sheets file without the need for external integrations. Simply connect your Google account to our platform, choose the relevant sheet from your Google Drive, and effortlessly transfer data using our user-friendly interface.

Use Cases

Bulk data entry into a specific worksheet.
Importing data from external sources in a batch.

How it works

Select Create Multiple Spreadsheet Row(s) from the Action dropdown

All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1.

Now select the drive in which your spreadsheet resides.

After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet.

Selecting Start 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.
By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows.

Update Multiple Spreadsheet Row(s)

This action type enables the user to modify existing data within a specified range based on a unique identifier.

Use Cases

Bulk edit product prices or inventory levels.
Update customer records with new contact information.

How it works

Select Update Multiple Spreadsheet Row(s) from the Action dropdown

All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1.

Now select the drive in which your spreadsheet resides.

After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to update and also select the worksheet.

Enter the row number from which you would like to update the sheet
Selecting Start 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.
By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows.