Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to open an existing Google Sheets spreadsheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Open spreadsheet function opens a connection to an existing Google Sheets spreadsheet by its ID or URL. This establishes a session for subsequent read and write operations.
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 or full URL |
| Variable | Yes | Text | - | Variable to store the spreadsheet metadata |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing spreadsheetId, title, locale, and sheets array |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid or you lack access
- Insufficient permissions – the app lacks spreadsheets scope
Tips
- The spreadsheet ID is the long string in the URL between /d/ and /edit
- You can also paste the full Google Sheets URL and the ID will be extracted automatically
- Use the Close function when finished to release the connection
Related functions
- Close – Close the spreadsheet connection
- Read sheet range – Read values from a range
- Write sheet range – Write values to a range