List Worksheets

The List Worksheets tool step allows you to list all the worksheets in a Google Sheet

Add the ‘List Worksheets’ Tool step to your Tool

You can add the ‘List Worksheets’ Tool step to your Tool by:

1. Creating a new Tool, then searching for the ‘List Worksheets’ Tool step
2. Click ‘Expand’ to see the full Tool step
3. 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.
4. Click ‘Run step’ to test out the Tool

Frequently asked questions (FAQs)

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?

To get the spreadsheet ID, navigate to your Google Sheet and copy the ID from the URL (the long string between /d/ and /edit).