Update Rows
Update existing rows matched by a column value (no append).
Google SheetsGoogleSheetsUpdateRows
What it does
Update existing rows matched by a column value (no append).
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Connection name | variable | Required | sheets | Name of the connection created by Authorize. |
| Spreadsheet (ID or URL) | string | Required | Spreadsheet ID, or paste the full Sheets URL. Example: 1AbC...xyz Supports variables | |
| Sheet/tab name | string | Required | Sheet1 | Example: Sheet1 Supports variables |
| Column to match on | string | Required | e.g. id — rows with the same value are updated. Example: id Supports variables | |
| Data (DataTable / list) | variable | Required | Example: rows | |
| Value input | dropdownUSER_ENTERED · RAW | Optional | USER_ENTERED | USER_ENTERED parses numbers/dates/formulas; RAW stores literally. |
More Google Sheets commands
Ready to automate your busywork?
Start your free 10-day trial today. No credit card, no commitment.