Google Sheets Nexviahub icon

Google Sheets Nexviahub

Read, update and write data to Google Sheets

Actions10

Sheet Within Document → Append or Update Row

AI-generated

Summary

Finds a row in a selected Google Sheets worksheet by a match column and value, then updates it; if no matching row exists, appends a new row. Choose the document and sheet, set the match column and value, and map the columns to send or automatically map incoming item fields. Extra input fields can be added as columns, ignored, or treated as errors; options also control cell formatting and data range.

Inputs

  • Authentication — Select Service Account or OAuth2. OAuth2 uses the required Client ID, Client Secret, Refresh Token, and Access Token fields.
  • Document (required) — Select a spreadsheet from the list, or provide its Google Sheets URL or ID.
  • Sheet (required) — Select a worksheet or specify it by URL, sheet ID, or name.
  • Data Mode — Choose automatic mapping from incoming item fields, manual column mapping, or Nothing. Manual mode provides a match value and fields to send; automatic mapping uses incoming fields.
  • Column to match on — The worksheet column used to find a row to update; it is not changed by the operation.
  • Value of Column to Match On — The value to look for in the match column when using manual mapping.
  • Values to Send — In manual mapping, select or name each destination column and provide its value.
  • Columns — Map fields to worksheet columns using the resource mapper.
  • Handling extra fields in input — For automatic mapping, choose whether unmatched input fields create new columns, are ignored, or cause an error.
  • Options — Set cell interpretation to Google Sheets formatting or raw input types, optionally set the header and first data row within a range, and choose whether to use append for more efficient writes when the sheet has no gaps.

Output shape

A list of n8n items representing the written row data.

Rows are updated when the match succeeds and appended when it does not. The exact returned item shape is not specified by the supplied source excerpt.

Examples

Example 1: Return matching rows only

Use manual mapping, set Column to match on to the lookup column, enter the desired match value, and map the columns and values to return.

Links

Discussion