Google Sheets Nexviahub icon

Google Sheets Nexviahub

Read, update and write data to Google Sheets

Actions10

Sheet Within Document → Update Row

AI-generated

Summary

Finds a row in a Google Sheets worksheet by matching a value in the selected column, then updates the mapped columns in that row.

Inputs

  • Authentication (required) — Choose Service Account or OAuth2. The visible OAuth fields include Client ID, Client Secret, Refresh Token, and Access Token.
  • Document (required) — Select a spreadsheet from the list, or provide its Google Sheets URL or file ID.
  • Sheet (required) — Select a worksheet or provide its URL, sheet ID, or name.
  • Column to match on (required) — Choose the worksheet column used to locate the row. This column is used for matching and is not changed.
  • Value of Column to Match On — Value to find in the selected match column; shown when using Map Each Column Below.
  • Data Mode — Choose Auto-Map Input Data to Columns, Map Each Column Below, or Nothing. The default is Map Each Column Below.
  • Values to Send — In Map Each Column Below mode, specify worksheet columns and values to update. A new column can be named explicitly.
  • Columns — For supported node versions, map input fields to worksheet columns. Auto-map mode can handle extra input fields by inserting columns, ignoring them, or raising an error.
  • Options — Set cell interpretation to USER_ENTERED or RAW, and optionally configure the header row and first data row. Auto-map mode also lets you choose how to handle unmatched input fields.

Output shape

A list of n8n items containing the updated row data.

The supplied source pack is signature-level and omits function bodies, so it does not confirm the exact returned item shape or behavior when no matching row is found.

Links

Discussion