← Node reference

Google Sheets Read

SHEETS_READ

Read a range from a spreadsheet as rows, addressable by column name.

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
  • rangelong textoptional
  • hasHeadertrue / falseoptional
  • limitnumberoptional

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