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

# Create Worksheet

> The Create Worksheet tool step allows you to create a new Google Sheet

## Add the ‘Create Worksheet’ Tool step to your Tool

<div
  style={{
position: "relative",
boxSizing: "content-box",
maxHeight: "80vh",
width: "100%",
aspectRatio: "1.273176761433869",
padding: "24px 0"
}}
>
  <iframe
    src="https://app.supademo.com/embed/cmdzg4kd40jd4h5wkrxjbrsex?embed_v=2&utm_source=embed"
    loading="lazy"
    title="Google Sheets Create Worksheet"
    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 ‘Create Worksheet’ Tool step to your Tool by:

1. Creating a new Tool, then searching for the ‘Create Worksheet’ Tool step
2. Click ‘Expand’ to see the full Tool step
3. Using the dropdown menu:
   * Select the 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 create the worksheet in.
4. Enter the name of the new worksheet you are creating.
5. Click 'Run step' to test out the Tool

## Using in an Agent

There are 3 ways to configure the tool step when using in an agent

<Tabs>
  <Tab title="Using dropdown menus">
    This is the easiest way to configure the tool step. You can select the Drive and Spreadsheet from a list of options via the dropdown menu.

    <img src="https://mintcdn.com/relevanceai/OWgDVEd91vN6behf/images/gs-create-worksheet-eg-1.png?fit=max&auto=format&n=OWgDVEd91vN6behf&q=85&s=a4ac8261db3314a4d0c61615c8745fa2" alt="Google Sheets Create Worksheet" width="833" height="470" data-path="images/gs-create-worksheet-eg-1.png" />
  </Tab>

  <Tab title="Using input variables">
    This option offers the most flexibility - you can use the same tool step for creating multiple worksheets, however you will need to manually provide the necessary Google Sheet IDs.

    <img src="https://mintcdn.com/relevanceai/OWgDVEd91vN6behf/images/gs-create-worksheet-eg-2.png?fit=max&auto=format&n=OWgDVEd91vN6behf&q=85&s=1a00f0139a7f399c52245ebebce1cdab" alt="Google Sheets Create Worksheet" width="816" height="475" data-path="images/gs-create-worksheet-eg-2.png" />
  </Tab>

  <Tab title="Mix of dropdown menus and input variables">
    This option offers the best of both worlds. You can use the dropdown menu to select the Drive and Spreadsheet, and then use an input variable for "Title" to allow the agent to dynamically pick a name for the new worksheet.

    <img src="https://mintcdn.com/relevanceai/OWgDVEd91vN6behf/images/gs-create-worksheet-eg-3.png?fit=max&auto=format&n=OWgDVEd91vN6behf&q=85&s=0aa5ba14f08e4427eba5cf38dfac59c6" alt="Google Sheets Create Worksheet" width="828" height="457" data-path="images/gs-create-worksheet-eg-3.png" />
  </Tab>
</Tabs>

## Parameters

<ParamField path="Drive" type="string">
  The Drive you want to use. By default, the tool uses "My Drive".
</ParamField>

<ParamField path="Spreadsheet ID" type="string">
  The ID of the spreadsheet you want to create the worksheet in.
  <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>
</ParamField>

<ParamField path="Title" type="string" required>
  The title of the new worksheet you want to create.
</ParamField>

## Frequently asked questions (FAQs)

<AccordionGroup>
  <Accordion title="What is the difference between using the green input variables and the dropdown menu?">
    **The dropdown menu is the easiest way to configure the tool step**. You can select the Drive and Spreadsheet from a list of options via the dropdown menu.

    **The input variables offer more flexibility** e.g. you can use the same tool step for creating multiple worksheets, however you will need to manually provide the necessary Google Sheet IDs.
  </Accordion>

  <Accordion title="Can I use a mix of both dropdown menu and green input variables?">
    If you are using the tool in an agent, this is the recommended approach. You can use the dropdown menu to select the fields that don't need to change, then use the green input variables for "Title" to allow the agent to dynamically pick a name for the new sheet.
  </Accordion>
</AccordionGroup>
