Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to get spreadsheet metadata.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Get metadata function retrieves metadata about a Google Sheets spreadsheet, including its title, locale, time zone, and a list of all sheet tabs with their IDs and titles.
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 |
| Variable | Yes | Text | - | Variable to store the metadata |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing title, locale, timeZone, and sheets array with sheetId and title for each tab |
Errors
- Spreadsheet not found – the spreadsheet ID is invalid or you lack access
Tips
- Use this to discover sheet tab names before reading or writing data
- The sheetId (numeric) is required for operations like Delete sheet tab
Related functions
- Open spreadsheet – Open a spreadsheet connection
- Add sheet tab – Add a new tab