Who This Is For / When to Use
This article is for account owners who want to:
Remove or clear spreadsheet data based on a matching value.
Maintain clean Google Sheets used for logging or reporting.
Automate record cleanup without deleting the entire row structure.
Use this action when you must target a specific row dynamically using a lookup result.
What the Delete Spreadsheet Row Using Lookup Action Does
The Delete Spreadsheet Row Using Lookup action clears all column values in a single spreadsheet row.
Important behavior:
The row itself is not removed.
All cell values in the matched row are cleared.
The action requires a prior Lookup Spreadsheet Row action.
This ensures the system knows exactly which row to modify.
Required Setup: Lookup Action (Mandatory)
Before using this delete action, your workflow must include a Lookup action.
The Lookup action:
Searches the spreadsheet for a value (such as Email or ID).
Returns the matching row number.
Passes that row reference to later actions.
Without a Lookup action, the delete action cannot run.
Step 1: Add the Lookup Action
In the Workflow Builder, click Please select action.
Search for Google Sheets.
Select Lookup Spreadsheet Row or Lookup Multiple Spreadsheet Row(s).
Configure the lookup criteria and save the action.
Step 2: Add the Delete Spreadsheet Row Using Lookup Action
Add another action below the Lookup step.
Search for Google Sheets.
Select Delete Spreadsheet Row Using Lookup.
Step 3: Select the Lookup Step
In Select Lookup Action, choose the previously saved Lookup step.
Save the action.
If the lookup returns a row, that row’s values will be cleared.
Action Execution Behavior
If a row is found, all values in that row are cleared.
If no row is found, the workflow skips this action.
The workflow continues to the next step regardless.
This prevents accidental deletion when no match exists.
Common Issues and Fixes
Nothing was deleted
Confirm the Lookup action returned a matching row.
Wrong row cleared
Verify lookup criteria and ensure unique identifiers are used.
Action unavailable
Ensure a Lookup action exists earlier in the workflow.
FAQ
What does the Delete Spreadsheet Row Using Lookup action do?
It clears all values from a specific row in Google Sheets that was identified by a Lookup action.
Is the row permanently deleted?
No. The row remains in the spreadsheet, but all its cell values are cleared.
Do I have to use a Lookup action first?
Yes. The delete action requires a Lookup action to identify the row number.
What happens if the Lookup action finds no rows?
The delete action is skipped and no data is changed.
Can I delete multiple rows at once?
No. This action clears one row per execution. Multiple rows require multiple lookup results or iterations.
Why are two actions required to delete a row?
The Lookup action identifies the exact row number. The delete action uses that reference to safely clear the correct row.
Can I decide between updating or deleting a row?
Yes. Use an If/Else condition after the Lookup action to branch logic based on whether a row was found.