Skip to main content
Base Node Node inspector for a Google Sheets node

Parameters

Document
string
required
Google Sheets document ID. This is the long string following /d/ in the document URL. For example, in the URL https://docs.google.com/spreadsheets/d/1A2B3C4D5E6F7G8H9I0J/edit#gid=0, the document ID is 1A2B3C4D5E6F7G8H9I0J.
Sheet Name
string
required
Sheet name within the document, found on the tab at the bottom of the Google Sheets interface.

Credentials

Google OAuth Credential
Google OAuth Credential
required
Select a Google OAuth Credential with the API access and scopes needed by this node.

Inputs

Input
any
Inputs are ignored; the input port is only for graph connectivity.

Outputs

Output
json
One output item per row. Each item is a JSON object with keys corresponding to the column headers. If a cell is empty, the corresponding value will be null.