Unitalk Sheets icon

Unitalk Sheets

Read, update and write data to Google Sheets

Actions10

Sheet Within Document → Update Row

AI-generated

Summary

Update a specific row in a Google Sheet within a selected spreadsheet document by matching on a specified column's value and setting new values for other columns.

Inputs

  • documentId (required) — Select the Google Sheets document by list, URL, or direct ID to specify which spreadsheet to operate on.
  • sheetName (required) — Choose the sheet within the document by list, URL, ID, or name where the row resides to update.
  • dataMode (required) — Determine how to provide the update data: auto-map input data to columns, define each column explicitly, or send no data.
  • columnToMatchOn (required) — Select the column to use as the key for identifying the row to update; this column's value is used for matching.
  • valueToMatchOn (required) — Specify the value in the chosen match column that identifies the row to update.
  • columns (required) — Define the columns and their new values to update in the matched row, either by mapping input fields automatically or by explicitly setting values per column.
  • options — Optional settings including cell format (USER_ENTERED or RAW), location details (header row and first data row indexes), and how to handle extra input fields (insert new columns, ignore, or error).

Output shape

a list of updated row data objects reflecting the changes made in the Google Sheet

Input data is matched against the sheet rows by the specified column and value. If multiple rows match, all will be updated. The operation supports flexible input modes for specifying update values, including automatic mapping or manual definition. Additional options control formatting and handling of unexpected fields.

Examples

Example 1: Update row by matching a Customer ID column with a supplied value, setting new values for columns like 'Status' and 'Last Contact Date', in the selected spreadsheet's 'Customers' sheet.

Set Document to the spreadsheet ID or URL, Sheet to 'Customers', Data Mode to 'Map Each Column Below', choose 'Customer ID' for Column To Match On, set Value To Match On to the ID value, and specify updated columns and their values in 'Columns'.

Links

Discussion