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