Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to read values from a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Read sheet range function reads values from a specified range in a Google Sheets spreadsheet. The range uses A1 notation (e.g. Sheet1!A1:D10). Returns a 2D array of values.
Setting it up
{{popups:rpas/add:action=google-workspace-sheets-read}}
Once on a process map:
- Navigate to the process where you would like to add the function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the GOOGLE WORKSPACE Read sheet range option
- Click "Add" once you are done
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 (from the URL) |
| Range | Yes | Text | - | A1 notation range (e.g. Sheet1!A1:D10, or just A1:D10 for the first sheet) |
| Variable | Yes | Text | - | Variable to store the values |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Array | 2D array of values, e.g. [["Name","Age"],["Alice","30"],["Bob","25"]] |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid or you lack access
- Invalid range – the A1 notation is malformed
- Sheet not found – the specified sheet name does not exist
Tips
- The spreadsheet ID is the long string in the Google Sheets URL between /d/ and /edit
- Use Sheet1!A:D to read entire columns without specifying row numbers
- The first row typically contains headers – access data from {variable.1} onward
- Use variables: Sheet1!A1:{last_column}{last_row}
Related functions
- Write sheet range – Write values to a range
- Append rows – Add new rows at the bottom
- Clear sheet range – Clear a range