Unitalk Sheets icon

Unitalk Sheets

Read, update and write data to Google Sheets

Actions10

Sheet Within Document → Append Row

AI-generated

Summary

Append a new row of data to a specified sheet within a Google Sheets document, mapping input data to sheet columns based on the selected data mode.

Inputs

  • Document (required) — The Google Sheets document to append the row to, specified by listing, URL, or ID.
  • Sheet (required) — The sheet within the document where the row will be appended, selected by listing, URL, ID, or name.
  • Data Mode (required) — Determines how the input data is mapped to the sheet columns. Options are: 'Auto-Map Input Data to Columns' (input keys match column names), 'Map Each Column Below' (manually define columns and values), or 'Nothing' (do not insert data).
  • Fields to Send — When 'Map Each Column Below' mode is selected, specify each column and corresponding value to send as the new row.
  • Columns (required) — When using newer node versions, define columns to map the input data to sheet columns either automatically or manually.
  • Options — Additional options controlling how the data is appended including cell format (USER_ENTERED or RAW), header row index for key matching, handling of extra input fields, and whether to use an efficient append method suited for sheets without gaps.

Output shape

a single record representing the added row or confirmation of append success

The operation appends data to the sheet and returns metadata on the appended row. Behavior varies by data mode; extra input fields can be inserted as new columns, ignored, or cause errors based on configuration. The node handles different document and sheet identification methods, and supports Google Sheets cell formatting options.

Examples

Example 1: Append data by auto-mapping input keys to sheet columns in a specified Google Sheets document and sheet, letting Google Sheets format cells.

Select Document and Sheet by listing, set Data Mode to 'Auto-Map Input Data to Columns', configure handling of extra fields, and optionally set cell format to 'USER_ENTERED'.

Example 2: Manually specify row data for fixed columns by defining each column and value to append.

Select Document and Sheet, set Data Mode to 'Map Each Column Below', then add fields specifying column names and values to insert as the new row.

Links

Discussion