Actions17
Sheet → Append or Update
AI-generatedSummary
Append new rows to a worksheet or update existing ones based on a matching column value, supporting data mapping modes and optional range selection.
Inputs
- Workbook (required) — Select the workbook either from the list or by specifying its ID.
- Sheet (required) — Select the worksheet (sheet) either from the list or by specifying its ID.
- Select a Range — Optionally specify a sheet range (A1-style notation) where the operation applies. If not set, the whole used range is considered.
- Range — Specific A1-style range to operate on when 'Select a Range' is enabled; must be specific (e.g. A1:B5).
- Data Mode (required) — Choose how to provide data: auto-map input properties to columns, define each column's value, or (not shown for this op) map using raw data.
- Column to match on (required) — The column used to identify existing rows to update; it is not modified during the operation.
- Value of Column to Match On — When using 'define' mode, specify the value in the matching column that identifies the row to update.
- Values to Send — In 'define' mode, specify which columns to update and their new values.
- Options — Additional options including appending after the selected range, returning raw data, data property naming, and whether to update all matching rows or only the first.
Output shape
a list of items each representing the updated worksheet data rows or operation results
Outputs data in a parsed format mapping headers to values by default, or raw data if specified. Supports updating single or multiple rows based on matches in the specified column. If no matching row is found, new rows are appended. Pagination and error handling follow standard node conventions.