Get Spreadsheet Info Activity
The Get Spreadsheet Info activity retrieves metadata and structural information about a specified Google Sheets document. This activity enables users to programmatically access key properties of a Google Sheet, such as its name, ID, and sheet count, facilitating further automation steps.
| Field | Description | Requirement |
|---|---|---|
| Google sheet name | The reference name of the Google Sheet which has already been opened or created. | Required |
| Result variable name | The name of the variable where the retrieved spreadsheet information will be stored. | Required |
Action Types & Examples
Spreadsheet Information Object
- Format: Object
- Example Result:
spreadsheetInfo
Implementation Examples
Field Setup - Google sheet name: newGoogleSheet
Execution Parameters - Result variable name: spreadsheetDetails
Technical Notes
The output of this activity is an object containing various properties of the Google Sheet, such as its ID, name, URL, and the number of sheets within the document. This object can be further processed to extract specific metadata for use in subsequent automation steps. Ensure the Google Sheet referenced by name is accessible and properly initialized within the automation workflow.