​
Add the ‘Get Values in Range’ Tool step to your Tool

You can add the ‘Get Values in Range’ Tool step to your Tool by:
  1. Creating a new Tool, then searching for the ‘Get Values in Range’ 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 values from.
    • Select the worksheet you would like to get the values from.
  4. Select the range of cells you would like to get the values from (e.g. A1:B2).
  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
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 Get Values in Range

​
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).
You can use this tool to parse the worksheet, spreadsheet and drive IDs from a url
​
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=).
You can also use this tool to parse the worksheet, spreadsheet and drive IDs from a url
​
Range
string
Specify the range of cells to retrieve, starting from the top-left cell to the bottom-right cell.Google Sheets Add Single RowA2:B3 will return a 2x2 block containing Bella, Luna, Dog, and Cat.
Leave the “Range” field empty to retrieve the entire sheet.

​
Frequently asked questions (FAQs)