Skip to main content

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

To get the Drive ID, navigate to your Google Drive and copy the ID from the URL (the long string after /folders/).
You can also use this tool to parse the drive ID from a url
To get the spreadsheet ID, navigate to your Google Sheet and copy the ID from the URL (the long string between /d/ and /edit).
You can also use this tool to parse the spreadsheet ID from a url
⌘I