Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to write to multiple ranges in a single request.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Batch write ranges function writes values to multiple ranges in a Google Sheets spreadsheet in a single API call. This is more efficient than making individual write requests.
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 |
| Data | Yes | Text | - | JSON array of objects with range and values properties, e.g. [{"range":"A1:B2","values":[["a","b"]]}] |
| 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 totalUpdatedRows, totalUpdatedColumns, and totalUpdatedCells |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid or you lack access
- Invalid range – one or more ranges are malformed
Tips
- Use batch writes to reduce API calls and improve performance
- All ranges are written atomically in a single request
Related functions
- Write sheet range – Write to a single range
- Batch read ranges – Read from multiple ranges at once