Google Sheets - List Sheets action

[monikakuster]

Implement the List Sheets action for Google Sheets component to retrieve all sheets from a specified spreadsheet. This action is essential for users who need to dynamically access and manage multiple sheets within a single spreadsheet, enabling seamless integration and data manipulation across different sheets.

Action properties:

• Spreadsheet ID - ID of the spreadsheet from which the sheets will be listed.

Output:

• list of sheets - A collection of sheet objects, each containing metadata such as spreadsheet ID. sheet ID and name.

Documentation Reference: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get