Delete Columns
Description
Deletes one or more columns from a Google Sheet.
All cells within the deleted columns are removed, and the remaining columns are shifted to close the gap.
Common Capabilities
Process Data Support
This activity supports dynamic configuration using variables from the Process Data drawer.
You can bind values from Agent Data, Workflow Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.
Learn more → Using Process Data
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 columns 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 column or a range of columns will be deleted.
Column Letter
The column to delete.
Required when Selection Type is set to Single.
From
The starting column of the range to delete.
Required when Selection Type is set to Multiple.
To
The ending column 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.
Wait All Incoming
Controls how this activity behaves when multiple incoming execution paths converge.
Determines whether the activity executes when:
- Any incoming path completes, or
- All relevant incoming paths complete before execution
Learn more → Execution Control
On Error
Defines how the workflow behaves if this activity encounters a runtime error.
Supported strategies include:
- Fault
- Continue
- Suspend
- Retry
Output
Result
A Boolean value indicating whether the delete operation completed successfully.
| Value | Meaning |
|---|---|
| True | The specified columns were successfully deleted. |
| False | The delete operation was unsuccessful. |
Remarks
- The authenticated Google account must have permission to modify the spreadsheet.
- Deleting a column removes all data contained within that column.
- When multiple columns are deleted, all columns within the specified range are removed.
- Remaining columns are automatically shifted to close the gap created by the deletion.
- Existing formulas, references, charts, and dependent calculations may be affected by the deletion.