Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to delete columns from a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Delete columns function removes columns from a Google Sheets spreadsheet. Remaining columns are shifted left to fill the gap.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Spreadsheet ID | Yes | Text | - | Google Sheets spreadsheet ID |
| Sheet ID | Yes | Text | - | Numeric sheet ID |
| Start index | Yes | Number | - | Zero-based start column index (inclusive) |
| End index | Yes | Number | - | Zero-based end column index (exclusive) |
Errors
- Sheet not found – no sheet exists with the given ID
- Invalid indices – start or end index is out of range
Tips
- To delete column C, use start=2, end=3
- When deleting multiple columns in a loop, delete from right to left
Related functions
- Insert columns – Insert blank columns
- Delete rows – Delete rows