Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to append rows to a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Append rows function appends rows of data after the last row with content in a Google Sheets spreadsheet. This is ideal for adding new records to an existing data set.
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 |
| Range | Yes | Text | - | A1 notation range indicating the target sheet and columns (e.g. Sheet1!A:D) |
| Values | Yes | Text | - | 2D array of rows to append, e.g. [["Alice","30"],["Bob","25"]] |
| Value input option | No | Select | USER_ENTERED | How values are interpreted: RAW or USER_ENTERED |
| Variable | Yes | Text | - | Variable to store the result |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing tableRange and updatedRows count |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid or you lack access
- Invalid range – the A1 notation is malformed
Tips
- Use a range like Sheet1!A:D to append to the first four columns
- Rows are appended after the last row that contains data
- This function is better than Write for adding records because it auto-detects the next empty row
Related functions
- Write sheet range – Write to a specific range
- Read sheet range – Read values from a range