Build with Relevance AIToolsTool StepsGoogle Sheets Tool Steps
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:
- Creating a new Tool, then searching for the ‘Get Spreadsheet by ID’ 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 fetch.
- 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).