> ## 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.
# Find Row
> The Find Row tool step allows you to find a row in your Google Sheet
## Add the ‘Find Row’ Tool step to your Tool
You can add the ‘Find Row’ Tool step to your Tool by:
1. Creating a new Tool, then searching for the ‘Find Row’ 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 find the row in.
* Select the worksheet you would like to find the row in.
4. Enter the letter of the column you want to search in.
5. Enter the value you want to find.
The value you enter will be case-sensitive.
6. 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
This is the easiest way to configure the tool step. You can select the Drive, Spreadsheet and Worksheet from a list of options via the dropdown menu.
This option offers the most flexibility - you can use the same tool step for multiple Google Sheets, however you will need to manually provide the necessary Google Sheet IDs.
This option offers the best of both worlds. You can use the dropdown menu to select the Drive, Spreadsheet and Worksheet, and then use an input variable for "Column Letter" and "Value" to allow the agent to work for different values.
## Parameters
The Drive you want to use. By default, the tool uses "My Drive".
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 use this tool to parse the worksheet, spreadsheet and drive IDs from a url](https://app.relevanceai.com/notebook/f1db6c/d64db999bc25-4ea0-b926-30b350f69243/01e4918b-6c0a-423d-8daa-a625ced25e23)
To get the worksheet ID, open the specific worksheet you want to use and copy the ID from the URL (appears after `#gid=`).
[You can also use this tool to parse the worksheet, spreadsheet and drive IDs from a url](https://app.relevanceai.com/notebook/f1db6c/d64db999bc25-4ea0-b926-30b350f69243/01e4918b-6c0a-423d-8daa-a625ced25e23)
The letter of the column of the sheet you are searching in.
The value you want to search for in the column.
When this option is checked, the tool will return the entire row in the results.
## Frequently asked questions (FAQs)
**The dropdown menu is the easiest way to configure the tool step**. You can select the Drive, Spreadsheet and Worksheet 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 multiple Google Sheets, however you will need to manually provide the necessary Google Sheet IDs.
If you are using the tool in an agent, this is the recommended approach. You can use the dropdown menu to select the Drive, Spreadsheet and Worksheet that don't need to change, and then use the green input variables for "Column Letter" and "Value" to allow the agent to dynamically search for different values in your Google sheet.
If you are only using the input variables, you will need to provide the necessary Google Sheet IDs for the tool step to function properly.