Delete Cells
Description
Deletes one or more cells from a Google Sheet.
After the cells are deleted, surrounding cells are shifted to fill the resulting space based on the selected shift direction.
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 cells 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 cell or a range of cells will be deleted.
Cell Address
The address of the cell to delete.
Required when Selection Type is set to Single.
From
The starting cell address of the range to delete.
Required when Selection Type is set to Multiple.
To
The ending cell address of the range to delete.
Required when Selection Type is set to Multiple.
Shift
Determines how adjacent cells are shifted after the selected cells are deleted.
Examples include:
- Shift Up
- Shift Left
For details about selecting spreadsheets, sheets, cells, and ranges, 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 cells were successfully deleted. |
| False | The delete operation was unsuccessful. |
Remarks
- The authenticated Google account must have permission to modify the spreadsheet.
- Deleting cells does not delete the entire row or column unless the selected range covers those cells and the chosen shift operation causes surrounding cells to move.
- Existing formulas and references within the spreadsheet may be affected by the deletion.
- The shift operation determines how adjacent cells are repositioned after deletion.
Example: Operate on a cell range
Choose Multiple, set From to B2 and To to C4, and select the required shift direction (Up or Left). Both endpoints are included. This changes the selected cells and shifts their neighbors; use a row/column activity when the operation must affect entire rows or columns.
Handle validation and service exceptions through On Error; a successful result is not a substitute for checking that the selected range is correct.