Who This Is For / When to Use
This article is for users building workflows that need to write data to Google Sheets, update existing rows, or clear row data without third-party integrations.
Use these actions when you need:
A system-of-record spreadsheet for workflow data
Row-level updates driven by workflow logic
Dynamic row targeting using custom values
Supported Google Sheets Actions
The following Premium Actions are available:
Create Spreadsheet Row
Update Specific Spreadsheet Row
Update Spreadsheet Row using Lookup
Lookup Spreadsheet Row
Delete Specific Spreadsheet Row
Delete Spreadsheet Row using Lookup
Each action connects directly to Google Sheets using your connected Google account.
Common Setup Fields (All Actions)
Select an Action
Choose the Google Sheets action you want to perform from the Action dropdown.
Choose an Account
Select the connected Google account that owns the target spreadsheet.
Select a Drive
Choose the Google Drive where the spreadsheet is stored.
Select a Spreadsheet
Select the specific Google Sheets file you want to work with.
Select a Worksheet
Choose the worksheet (tab) inside the spreadsheet.
Create Spreadsheet Row
Creates a new row in the selected worksheet.
How It Works
The first row of the worksheet is treated as the header row.
Columns are identified by header name.
Values entered in the action create a new row at the bottom of the worksheet.
Column Mapping
Click Refresh Headers to pull the latest column headers from the sheet.
Select a Starting Column and Ending Column to define which columns will be populated.
Enter values for each displayed column.
Update Specific Spreadsheet Row
Updates values in a specific row number.
Required Fields
Worksheet: The worksheet containing the row
Row Number: The exact row to update
The Row Number can be static or dynamic.
Column Range
Select a Starting Column and Ending Column to control which columns are updated.
Leave a column field empty if you do not want to change its value.
Delete Specific Spreadsheet Row
Clears all values in a specific row.
Important: This action clears the row contents but does not remove the row itself from the sheet.
Required Fields
Worksheet: The worksheet containing the row
Row Number: The row to clear
Notes and Behavior
Sheet and worksheet names must not be changed after they are used in a workflow.
Column names may be changed, but Refresh Headers must be clicked afterward.
Spreadsheet formulas are supported and will calculate normally after row creation or updates.
Only one row can be updated or cleared per action execution.
Common Issues and Fixes
Headers Not Showing Correctly
Click Refresh Headers after editing column names in Google Sheets.
Workflow Fails After Renaming Sheet or Worksheet
Revert the name change or reselect the sheet and worksheet in the action.
Wrong Row Updated
Confirm the Row Number value being passed, especially when using custom values.