Skip to main content
Docs
Build with Relevance AIToolsTool StepsGoogle Sheets Tool Steps

Get Values in Range

The Get Values in Range tool step allows you to retrieve data from your Google Sheet

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

Drivestring

The Drive you want to use. By default, the tool uses “My Drive”.

Spreadsheet IDstringrequired

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 worksheet, spreadsheet and drive IDs from a url
Worksheet IDstringrequired

To get the worksheet ID, open the specific worksheet you want to use and copy the ID from the URL (appears after #gid=).

Tip: You can also use this tool to parse the worksheet, spreadsheet and drive IDs from a url
Rangestring

Specify the range of cells to retrieve, starting from the top-left cell to the bottom-right cell.

Google Sheets Add Single Row

A2:B3 will return a 2x2 block containing Bella, Luna, Dog, and Cat.

Note: Leave the “Range” field empty to retrieve the entire sheet.

Frequently asked questions (FAQs)

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

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, and then use the green input variables for “Range” to allow the agent to dynamically retrieve data from your Google sheet.

Warning: 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. At the minimum, this includes the spreadsheet ID and the worksheet ID.
Suggest edits Raise issue

List Worksheets

The List Worksheets tool step allows you to list all the worksheets in a Google Sheet

Create Spreadsheet

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