← Node reference

Google Sheets Upsert Row

SHEETS_UPSERT

Update the row whose key column matches, or append one if none does.

Configuration

  • variableNametextoptional
  • credentialIdcredentialoptional

    Accepts google.sheets or google.oauth2. Stored encrypted; the value is never returned to the browser or written to a trace.

  • spreadsheetIdlong textoptional
  • sheetNamelong textoptional
  • rangelong textoptional
  • matchColumnlong textoptional
  • matchValuelong textoptional
  • valueslong textoptional

Ports

Inputs

  • main In

Outputs

  • main Out

Execution

Type version
1
Retry
no retry by default
Timeout
engine default
Credentials
google.sheets or google.oauth2