​
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", "[email protected]", "123 Main St"], ["Jane Doe", "[email protected]", "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
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 Update multiple rows

​
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
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", "[email protected]", "123 Main St"], // row 1
  ["Jane Doe", "[email protected]", "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, , 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)