Add the ‘List Worksheets’ Tool step to your Tool
You can add the ‘List Worksheets’ Tool step to your Tool by:- Creating a new Tool, then searching for the ‘List Worksheets’ Tool step
- Click ‘Expand’ to see the full Tool step
- Using the dropdown menu:
- Select the Google account you would like to use.
- Select the Drive you would like to use (defaults to “My Drive”).
- Select the Spreadsheet you would like to get the worksheets from.
- Click ‘Run step’ to test out the Tool
Frequently asked questions (FAQs)
How do I use this tool in an agent?
How do I use this tool in an agent?
For an example of how to use this tool in an agent, see Add single row.
How do i get the spreadsheet ID?
How do i get the spreadsheet ID?
To get the spreadsheet ID, navigate to your Google Sheet and copy the ID from the URL (the long string between
/d/ and /edit).