Update Table Row(s)

The Update Table Row(s) action writes the same set of named column values to one or more rows. It resolves column names from a header row and leaves unspecified columns unchanged.

Inputs

Input	Type	Required	Description
Third-party account	Google account	Yes	Account with write access.
Spreadsheet ID or URL	String	Yes	Spreadsheet containing the table.
Sheet Name	String	Yes	Sheet tab to update.
Row Numbers	List of numbers	Yes	One-based absolute row numbers.
Values	Object	Yes	Column/value pairs applied to every selected row.
Header Row Number	Number	No	One-based header position. Defaults to `1`.

Column names are matched case-insensitively to the closest header within a small spelling distance. Row numbers are sorted and deduplicated.

This action applies one Values object to every selected row and returns no output. Use separate action runs when different rows need different values.

Example

Find overdue rows
  → Google Sheets: Update Table Row(s)
      Row Numbers = found row numbers
      Values = { "Status": "Overdue" }

Troubleshooting

A column cannot be matched

Verify the header row and available header text. A blank or substantially different column name cannot be resolved.

Write RangeWrite user-entered values into a Google Sheets range.

Overview

Fundamentals

Web, Files & Data

AI

Scraping & Rendering

Google Workspace

Email, CRM & Scheduling

Databases & Tables

Microsoft

Inputs

Example

Troubleshooting

​Inputs

​Example

​Troubleshooting

Inputs

Example

Troubleshooting