Google Sheets Nexviahub icon

Google Sheets Nexviahub

Read, update and write data to Google Sheets

Actions10

Sheet Within Document → Append Row

AI-generated

Summary

Append a row of input data to a selected Google Sheets tab. Choose the spreadsheet and sheet, then map input values to columns or configure automatic column matching; options control cell formatting, header row, extra fields, and append behavior.

Inputs

  • Authentication (required) — Select Service Account or OAuth2. OAuth2 mode also exposes required Client ID, Client Secret, Refresh Token, and Access Token fields.
  • Document (required) — Select a spreadsheet from the list, provide its URL, or enter its ID.
  • Sheet (required) — Select a tab from the chosen spreadsheet, or identify it by URL, ID, or name.
  • Data Mode — For the node version that shows this setting, choose automatic mapping from incoming item fields, map specific columns and values, or send nothing.
  • Fields to Send — In “Map Each Column Below” mode, choose each destination column and enter its value.
  • Columns — In newer node versions, configure the column mappings for the row.
  • Options — Set cell formatting to Google Sheets’ USER_ENTERED interpretation or RAW input values; choose the header row; decide how automatic mapping handles unmatched input fields; and optionally use the more efficient append request when rows and columns have no gaps.

Output shape

A list of n8n items containing the appended row data.

The supplied source pack exposes the operation and helper signatures but omits their bodies, so it does not establish whether returned items contain the submitted values, API response data, or another representation.

Links

Discussion