Who This Is For / When to Use
This article is for account owners who want to:
Clear data from a known row in Google Sheets.
Remove outdated or invalid entries while keeping sheet structure intact.
Use fixed or dynamic row numbers inside workflows.
Use this action when the row number is already known or stored in a custom value.
What the Delete Specific Spreadsheet Row Action Does
The Delete Specific Spreadsheet Row action clears all column values in a single worksheet row.
Important behavior:
The row itself is not removed.
Only the row’s cell values are cleared.
Other rows are not shifted or renumbered.
Step 1: Add the Google Sheets Action
Open the Workflow Builder.
Click Please select action under your trigger.
Search for Google Sheets.
Select Delete Specific Spreadsheet Row.
Step 2: Configure Account, Drive, and Spreadsheet
Choose the connected Google account.
Select the Drive where the spreadsheet is stored.
Select the Spreadsheet.
Choose the Worksheet.
The worksheet name is used for referencing and cannot be changed after selection.
Step 3: Specify the Row Number
Enter the row number that should be cleared.
You can provide:
A static row number (example:
12), orA dynamic value using the Custom Value picker.
This allows workflows to delete rows determined by earlier steps.
Using Dynamic Row Numbers
Dynamic row numbers are commonly used when:
A previous action stored a row number.
Data was looked up earlier in the workflow.
Row positions change over time.
Example:
Action Execution Behavior
The specified row’s values are cleared.
The row remains in place and empty.
No other rows are modified.
This ensures spreadsheet structure remains stable.
Common Issues and Fixes
Row not cleared
Confirm the row number exists in the worksheet.
Wrong row cleared
Verify static numbers or dynamic values resolve correctly.
Formulas affected
Check for formulas that reference the cleared row.
FAQ
What does the Delete Specific Spreadsheet Row action do?
It clears all cell values in a specified worksheet row without deleting the row itself.
Does this action permanently remove the row?
No. The row remains in the worksheet but is left empty.
How do I choose which worksheet is affected?
Select the worksheet from the dropdown during action setup before entering the row number.
Can I use dynamic values for the row number?
Yes. Use the Custom Value picker to insert a dynamic row number stored earlier in the workflow.
Will this shift other rows up or down?
No. Row positions remain unchanged.
Can this affect spreadsheet formulas?
Yes. Clearing values may impact formulas that reference that row. Review dependent formulas before using this action.