Create Multiple Spreadsheet Row(s) adds new spreadsheet entries; Update Multiple Spreadsheet Row(s) changes values in existing rows.
Workflow action: create and update multiple rows in Google Sheets
The Google Sheets premium actions Create Multiple Spreadsheet Row(s) and Update Multiple Spreadsheet Row(s) write several rows to a spreadsheet in a single workflow execution. Create Multiple adds new rows from an array of row objects; Update Multiple edits rows that already exist. These actions extend the single-row Google Sheets workflow action for grouped or repeated data inside a workflow.
Prerequisites
Set up these items before configuring either multiple-row action.
Connect the Google account in the platform.
Confirm the spreadsheet is in the correct Google Drive.
Add clear column headers in the first worksheet row.
Confirm the worksheet tab name.
Ensure the Google Sheets premium workflow actions are enabled if required.
Click Refresh Headers whenever columns are added, renamed, or reordered.
Create multiple rows
Create Multiple Spreadsheet Row(s) adds new rows at the end of the sheet in one workflow run. It writes rows only when the workflow execution supplies an array of row objects — it does not wait for several contacts and batch them.
Go to Automations > Workflows and create a new workflow or edit an existing one.
Add a relevant trigger, such as Contact Created or Form Submitted.
Click + to add an action.
Search for Google Sheets and select the action from the Workflow actions catalog.
Connect the location's Google account.
Select Create Multiple Spreadsheet Row(s) from the Action dropdown.
Select one integrated Google account from the dropdown.
Select the Drive containing the spreadsheet.
Select the spreadsheet and worksheet.
Click Refresh Headers if the sheet headers need updating. The first sheet row is automatically treated as the header row, and each column is labeled from the header values.
Use the start and end column configuration to define the relevant worksheet range.
Click Save Action.
Supply an array of row objects
The action creates one spreadsheet row for each object in the array. If only one record is present, one row is written. The action writes whatever array exists in that single workflow execution — it never accumulates contacts across runs.
JSON example with three rows:
[
{ "Name": "Sam", "Email": "[email protected]", "Status": "New" },
{ "Name": "Arjun", "Email": "[email protected]", "Status": "In Progress" },
{ "Name": "Meera", "Email": "[email protected]", "Status": "Completed" }
]JavaScript array with two rows:
[
{ FirstName: "John", LastName: "Doe", Email: "[email protected]" },
{ FirstName: "Jane", LastName: "Smith", Email: "[email protected]" }
]The workflow must start with or construct an array of row objects. Common sources are an Inbound Webhook trigger that delivers a JSON array, or a webhook-based integration whose previous step returns an array that you map into the action.
The action does not batch contacts automatically. If you need to write thousands of existing contacts, such as 5,000 already in the platform, enrolling contacts one-by-one triggers separate workflow runs and does not batch them automatically.
Update multiple rows
Update Multiple Spreadsheet Row(s) changes values in rows that already exist in the sheet, starting from a row number you enter. Use it when the spreadsheet row already exists, existing-record values need to be replaced or refreshed, or duplicate rows should be avoided.
Go to Automations > Workflows and create a new workflow or edit an existing one.
Add a relevant trigger, such as Contact Created or Form Submitted.
Click + to add an action.
Search for Google Sheets and select the action.
Connect the location's Google account.
Select Update Multiple Spreadsheet Row(s) from the Action dropdown.
Select one integrated Google account.
Select the Drive containing the spreadsheet.
Select the spreadsheet and worksheet.
Enter the row number from which to update the sheet.
Select the Start Column and End Column. The first sheet row is treated as the header row, and columns are labeled from those headers.
Click Refresh Headers if the sheet structure changed.
Click Save Action.
Frequently asked questions
What is the difference between Create Multiple and Update Multiple?
How is Create Multiple different from creating a single row?
It can write many rows in one workflow execution, but only when the input is an array of row objects. One record produces one row.
Will the action collect contacts until there are enough to batch?
No. The action does not automatically batch contacts. The workflow execution must already contain an array, commonly delivered by an Inbound Webhook trigger.
Do I need column headers?
Yes. Clear headers help the platform recognize the available columns and reduce setup errors.
Why is a new column missing from the action?
Columns were added or renamed without Refresh Headers being clicked. Refreshing headers updates the available column names after spreadsheet changes.
What happens if I select the wrong worksheet?
Data may be written to the wrong location, or the expected columns may not map correctly.
Can I limit the columns the action writes?
Yes. The column range can be limited with Starting Column and Ending Column.
Was this helpful?
Was this helpful?