Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to read multiple ranges in a single request.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Batch read ranges function reads values from multiple ranges in a Google Sheets spreadsheet in a single API call. This is more efficient than making individual read requests for each range.
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 |
| Ranges | Yes | Text | - | JSON array of A1 notation ranges, e.g. ["Sheet1!A1:B5","Sheet2!C1:D10"] |
| Variable | Yes | Text | - | Variable to store the results |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Array | Array of value ranges, each containing range and values properties |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid or you lack access
- Invalid range – one or more A1 notation ranges are malformed
Tips
- Use batch reads to reduce API calls when reading from multiple sheets or ranges
- Each range in the result can be accessed by index: {variable.0.values}, {variable.1.values}
Related functions
- Read sheet range – Read a single range
- Batch write ranges – Write to multiple ranges at once