Update an existing row
update_rowUpdates specific columns in an existing Google Sheets row without overwriting other cells. Target the row by number or by matching a unique value, such as an ID.
Instructions
Modifies only the named columns of an existing row, leaving every other column untouched. This is the right tool for changing a status or fixing a field in a register: unlike write_range it does not overwrite the whole row. The row is identified either by number (from find_rows) or by matching a value in a column.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| row | No | Absolute row number, as returned by find_rows. | |
| match | No | Alternative to row: locate the row by a unique value, e.g. an ID. | |
| sheet | Yes | Tab name, e.g. 'Log'. | |
| updates | Yes | Only the columns to change. | |
| headerRow | No | ||
| spreadsheetId | Yes | Spreadsheet ID, or its full URL. The ID is the segment between /d/ and /edit in the URL. | |
| valueInputOption | No | USER_ENTERED parses values as if typed by hand (formulas, dates, numbers). RAW stores them literally as strings. | USER_ENTERED |