Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to batch update a spreadsheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Batch update spreadsheet function executes multiple update requests in a single API call. Supports adding/deleting sheets, formatting, merging, sorting, conditional formatting, charts, and more. All requests are applied atomically.
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 |
| Requests | Yes | Textarea | - | JSON array of request objects (see Google Sheets API batchUpdate documentation) |
| Variable | Yes | Text | - | Variable to store the result |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing replies array with results for each request |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid
- Invalid request – one or more request objects are malformed
Tips
- Use this for operations not covered by individual functions (e.g. conditional formatting, pivot tables)
- All requests are applied atomically – if one fails, none are applied
- Refer to the Google Sheets API batchUpdate documentation for the full list of request types
Related functions
- Format cells – Format cells individually
- Add sheet tab – Add a sheet tab individually