Google Sheets / Add or Update Row

A specific sheet id containing the rows of columns. E.g., 'Sheet1'.

string

The google sheet id containing the relevant sheet.

string

The columns to add to the row. Loaded from existing headers on a sheet

Record<string, string> | undefined

The fieldId which will be used in conjunction with the searchValue to find the row to update. Includes any existing id values available in the dynamic schema for the selected trigger. (See Dynamic Schemas for more information.)

string | undefined

Select to update existing rows which match incoming records - otherwise a new row is created.

If true, will update an existing row if found. If the row cannot be found a new row will be created

boolean | undefined