upsert_rows

Update existing rows or append new rows, matched by a unique key column. Each input row is an object keyed by the sheet's header names. Existing rows keep cells omitted from the object, including formulas. Unknown columns, duplicate keys, and blank keys are rejected before any write occurs.

Parameters