Who This Is For / When to Use
Use this action when a workflow needs to read from or write to Google Sheets, including multi-row lookups, bulk updates, or conditional row creation.
What This Action Supports
The Google Sheets premium action supports:
Looking up multiple spreadsheet rows based on criteria
Updating multiple rows in a defined column range
Creating new rows if no match is found
Case-sensitive or non-case-sensitive searches
Access the Workflow Builder
Navigate to Automation.
Click Workflows.
Click Create Workflow.
Add an Action to the Workflow
In the workflow builder, click the + icon below the trigger.
Click Please select action.
Select the Google Sheets Action
Search for Google Sheets.
Select Google Sheets from the actions list.
Confirm the premium action notice.
Configure Account and Spreadsheet
Choose Account
Select the connected Google account that owns the spreadsheet.
Drive
Choose the Google Drive where the spreadsheet is stored.
Spreadsheet
Select the spreadsheet you want the workflow to access.
Worksheet
Select the worksheet tab. The first row is always treated as the header row.
Lookup Multiple Spreadsheet Row(s)
Use this action to retrieve multiple rows that match specific criteria.
Search Settings
Search position: Choose where the lookup starts in the sheet
Column: Select the column to evaluate
Value: Enter the value or variable to match
Row Count: Define the maximum number of rows to return
Case Sensitive Lookup: Enable if exact casing is required
Create Row if Not Found (Optional)
Enable Create new spreadsheet row if it doesn't exist yet to automatically insert a row when no match is found.
Update Multiple Spreadsheet Row(s)
Use this action to update existing rows in bulk.
Row Range
Row Number: Starting row to update
Starting Column: First column to update
Ending Column: Last column to update
Values are mapped using workflow variables and aligned to column headers.
Refresh Headers
Click Refresh Headers if column headers were recently changed in the spreadsheet.
This ensures correct data-to-column mapping.
Test and Publish the Workflow
Click Test Workflow to validate execution.
Toggle from Draft to Publish.
Click Save to activate the workflow.
Common Issues and Fixes
No Rows Returned
Confirm the lookup value exists in the selected column
Check case sensitivity settings
Data Written to Wrong Column
Refresh headers
Confirm the correct worksheet is selected
Action Fails to Execute
Verify the Google account connection
Ensure the spreadsheet permissions allow edits
Important Notes
Google Sheets actions are premium and billed per execution
The first row of every worksheet is treated as headers
Large spreadsheets may increase execution time