Get Spreadsheet by ID

The Get Spreadsheet by ID tool step allows you to retrieve a spreadsheet from your Google Drive

Add the ‘Get Spreadsheet by ID’ Tool step to your Tool

You can add the ‘Get Spreadsheet by ID’ Tool step to your Tool by:

1. Creating a new Tool, then searching for the ‘Get Spreadsheet by ID’ 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 fetch.
4. Click ‘Run step’ to test out the Tool

Frequently asked questions (FAQs)

How do I get the Drive ID?

To get the Drive ID, navigate to your Google Drive and copy the ID from the URL (the long string after /folders/).

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).