Skip to main content
Go to the Studio
Values

Update values

Update values

Updates the values of a cell range.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Range​

A1 notation of the range to update, e.g. Sheet1!A1:D10.

Values​

Build the grid of values to write to the given range, arranged in rows and columns. Use the "Add row" and "Add column" buttons to expand the grid as needed. The number of filled rows/columns must match (or be compatible with) the given range.

Advanced options​

How to read the given values​

Choose between As typed by a user (formulas, dates and so on are interpreted) or As plain text (no interpretation). Default: As typed by a user.

Returns​

Javascript code​

js
actions["action-id"].updatedRange // A1 notation of the range that was updated (Text)
actions["action-id"].updatedRows // number of rows updated (Number)
actions["action-id"].updatedColumns // number of columns updated (Number)
actions["action-id"].updatedCells // number of cells updated (Number)

Field selection​

  • updatedRange — A1 notation of the range that was updated (Text)
  • updatedRows — number of rows updated (Number)
  • updatedColumns — number of columns updated (Number)
  • updatedCells — number of cells updated (Number)

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID and Range fields are required, as are at least one row and one column of Values.
  • The range must be in A1 notation (e.g. Sheet1!A1:D10).
  • By default the values are read as if typed by a user (formulas, dates and so on are recognized); you can switch to plain text under Advanced options.
  • If the Values grid has more rows/columns than the given range, Google Sheets writes the extra values starting from the beginning of the range, which can overwrite cells beyond the original range.
  • If the given range cannot be resolved (e.g. a missing tab), the robot stops with an error.