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.Google Sheets Find Row

Parameters

Drive
string
The Drive you want to use. By default, the tool uses “My Drive”.
Spreadsheet ID
string
required
To get the spreadsheet ID, navigate to your Google Sheet and copy the ID from the URL (the long string between /d/ and /edit).
Worksheet ID
string
required
To get the worksheet ID, open the specific worksheet you want to use and copy the ID from the URL (appears after #gid=).
Column Letter
string
required
The letter of the column of the sheet you are searching in.
Value
string
required
The value you want to search for in the column.
Export Row
boolean
When this option is checked, the tool will return the entire row in the results.

Frequently asked questions (FAQs)