List Sheets Activity
The List Sheets activity retrieves a list of all sheet names within a specified Google Sheets document. This activity is essential for dynamically identifying and interacting with different sheets in a workbook, allowing for flexible automation workflows.
| Field | Description | Requirement |
|---|---|---|
| Google sheet name | The reference name of the Google Sheet, which has already been opened or created, is selected from the dropdown. | Required |
| New dataset name | The reference name for the dataset that will be created to store the retrieved sheet names. | Required |
Action Types & Examples
Retrieve Sheet Names List
- Format: Dataset containing a list of strings
- Example Result:
["Sheet1", "Data", "Summary"]
Implementation Examples
Field Setup - Google sheet name: GoogleSheet
Execution Parameters - New dataset name: sheetNamesDataset
Technical Notes
The activity requires the specified Google Sheet to be accessible and properly authenticated. If the sheet is not found or permissions are insufficient, the activity will terminate with an error. The generated dataset will be empty if the Google Sheet contains no visible sheets.