Delete Rows
Description
Deletes one or more rows from a Google Sheet.
All cells within the deleted rows are removed, and the remaining rows are shifted to close the gap.
Common settings
Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.
Design-Time Configuration
Display Text
A user-defined name for the activity, displayed on the workflow canvas to help identify its purpose.
Connection Name
The configured Google Sheets connection used to access Google Sheets resources.
Spreadsheet
The spreadsheet containing the rows to delete.
Sheet Name
The name of the sheet where the operation will be performed.
If not specified, the currently active sheet is used.
Selection Type
Determines whether a single row or a range of rows will be deleted.
Row Number
The row to delete.
Required when Selection Type is set to Single.
From
The starting row of the range to delete.
Required when Selection Type is set to Multiple.
To
The ending row of the range to delete.
Required when Selection Type is set to Multiple.
For details about selecting spreadsheets and sheets, see Google Sheets Data Selection.
Execution settings
Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.
Output
Result
A Boolean value indicating whether the delete operation completed successfully.
| Value | Meaning |
|---|---|
| True | The specified rows were successfully deleted. |
| False | The delete operation was unsuccessful. |
Remarks
- The authenticated Google account must have permission to modify the spreadsheet.
- Deleting a row removes all data contained within that row.
- When multiple rows are deleted, all rows within the specified range are removed.
- Remaining rows are automatically shifted to close the gap created by the deletion.
- Existing formulas, references, charts, and dependent calculations may be affected by the deletion.
Example: Select a contiguous group
Choose Multiple and set From to 2 and To to 4. This selects three rows, including both endpoints. The selected rows and their data are removed; remaining rows shift to close the gap.
A successful operation returns Result = True. Validation, permission, and service failures raise activity errors; handle them with On Error rather than relying only on a False result.