Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to insert columns into a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Insert columns function inserts blank columns at a specified position in a Google Sheets spreadsheet. Existing columns are shifted right to make room.
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 column index where new columns will be inserted |
| Count | Yes | Number | 1 | Number of columns to insert |
Errors
- Sheet not found – no sheet exists with the given ID
- Invalid index – the start index is out of range
Tips
- Column indices are zero-based (0 = column A, 1 = column B, etc.)
- Inserted columns are blank – use Write sheet range to populate them
Related functions
- Delete columns – Delete columns from the sheet
- Insert rows – Insert blank rows