> ## Documentation Index
> Fetch the complete documentation index at: https://relevanceai.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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

<div
  style={{
position: "relative",
boxSizing: "content-box",
maxHeight: "100vh",
width: "100%",
aspectRatio: "1.8057022175290391",
padding: "24px 0"
}}
>
  <iframe
    src="https://app.supademo.com/embed/cme2g76l60ngzh3pyeiwjoevv?embed_v=2&utm_source=embed"
    loading="lazy"
    title="Google Sheets Get Spreadsheet by ID"
    allow="clipboard-write; fullscreen"
    webkitAllowFullscreen="true"
    mozAllowFullscreen="true"
    allowFullscreen
    style={{
  position: "absolute",
  top: 0,
  left: 0,
  width: "100%",
  height: "100%",
  border: "3px solid #5E43CE",
  borderRadius: "10px",
  objectFit: "cover"
}}
  />
</div>

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)

<AccordionGroup>
  <Accordion title="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/`).
    <Tip> [You can also use this tool to parse the drive ID from a url](https://app.relevanceai.com/notebook/f1db6c/d64db999bc25-4ea0-b926-30b350f69243/01e4918b-6c0a-423d-8daa-a625ced25e23)</Tip>
  </Accordion>

  <Accordion title="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`).
    <Tip> [You can also use this tool to parse the spreadsheet ID from a url](https://app.relevanceai.com/notebook/f1db6c/d64db999bc25-4ea0-b926-30b350f69243/01e4918b-6c0a-423d-8daa-a625ced25e23)</Tip>
  </Accordion>
</AccordionGroup>