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

# 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

<div
  style={{
position: "relative",
boxSizing: "content-box",
maxHeight: "80vh",
width: "100%",
aspectRatio: "2.06",
padding: "24px 0"
}}
>
  <iframe
    src="https://app.supademo.com/embed/cmdqv30r33wp69f96jr2ol62y?embed_v=2&utm_source=embed"
    loading="lazy"
    title="Google Sheets List Worksheets"
    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 ‘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)

<AccordionGroup>
  <Accordion title="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](../google-sheets/add-single-row).
  </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 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>