Unitalk Sheets icon

Unitalk Sheets

Read, update and write data to Google Sheets

Actions10

Sheet Within Document → Append or Update Row

AI-generated

Summary

Append a new row to a specified Google Sheet or update an existing row matching a specified column value within that sheet.

Inputs

  • Document (required) — Select the Google Sheets document by list, URL, or ID to target.
  • Sheet (required) — Select the sheet within the document by list, URL, ID, or name where data will be appended or updated.
  • Data Mode (required) — Choose how input data is used: automatically map input properties to columns, manually define column values, or send no data.
  • Column to match on (required) — Specify the column used to find the existing row for updating; this column will not be modified.
  • Value of Column to Match On — For manual data mapping mode, provide the value that identifies the row to update based on the matching column.
  • Values to Send — For manual data mapping mode, define the columns and their corresponding values to set in the row.
  • Columns (required) — Define or map the columns for upserting the row data, including how unmatched fields are handled.
  • Options — Additional settings such as cell format (USER_ENTERED or RAW), header and data row positions, handling of extra fields, and whether to minimize API calls by using optimized append.

Output shape

a single record representing the appended or updated row data as stored in the sheet

The operation returns the data of the appended or updated row in the sheet. The matching column is used to identify the row to update; if none matches, a new row is appended. Input data mapping mode affects how data fields are matched to columns. Errors occur if mismatches are configured to cause failures.

Links

Discussion