Update Multiple Rows

The Update Multiple Rows tool step allows you to update multiple rows in your Google Sheet

Add the ‘Update Multiple Rows’ Tool step to your Tool

You can add the ‘Update Multiple Rows’ Tool step to your Tool by:

1. Creating a new Tool, then searching for the ‘Update Multiple Rows’ 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 update rows in.
   • Select the worksheet you would like to update rows in.
4. Enter the range you would like to update. This should be in the format of A1:C5.
5. Enter the new Row Values. This should be an array of arrays.
   Example: [["John Doe", "[e-mail]", "123 Main St"], ["Jane Doe", "[e-mail]", "456 Main St"]]
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

Using dropdown menus

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.

Using input variables

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.

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, Spreadsheet and Worksheet, and then use an input variable for “Range” and “Row Values” to allow the agent to dynamically update data in your Google sheet.

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=).

Range · string · required

The range of cells to update. The update will begin at the starting cell of the range (e.g., if the range is A10:C20, updates begin at A10).

Make sure the specified range fully covers the rows and columns you are updating.
For example, if you are updating 3 columns across the first 5 rows, the range should be at least A1:C5.

Row Values · array of arrays · required

The data being updated will need to be in an array of arrays format.

Example:

[
  ["John Doe", "[e-mail]", "123 Main St"], // row 1
  ["Jane Doe", "[e-mail]", "456 Main St"] // row 2
  // ...
]

What is an array of arrays?

An array is a data structure similar to a CSV row, where each element is separated by a comma, and the entire row is enclosed in square brackets. An array can have many different types of data, including strings, numbers, booleans, and even other arrays.

["Dog", 1, true]

An array of arrays is just multiple arrays put together. This is what an array of arrays looks like:

[
  ["Column 1 Row 1", "Column 2 Row 1", "Column 3 Row 1"],
  ["Column 1 Row 2", "Column 2 Row 2", "Column 3 Row 2"],
  ["Column 1 Row 3", "Column 2 Row 3", "Column 3 Row 3"]
]

When you combine multiple arrays together, you can see that the data is structured like a Google Sheet.

Playground

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 (the ID fields), and then use the green input variables for “Range” and “Row Values” to allow the agent to dynamically update data 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. At the minimum, this includes the spreadsheet ID and the worksheet ID.