Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to delete rows from a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Delete rows function removes rows from a Google Sheets spreadsheet. Remaining rows are shifted up 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 row index (inclusive) |
| End index | Yes | Number | - | Zero-based end row 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 a single row (e.g. row 5), use start=4, end=5
- When deleting multiple rows in a loop, delete from bottom to top to avoid shifting issues
Related functions
- Insert rows – Insert blank rows
- Delete columns – Delete columns
- Clear sheet range – Clear values without deleting rows