Google Sheets

Read and write Google Sheets. One credential works across many spreadsheets: each node picks the spreadsheet, tab, and range, and picking one shows its columns in the builder.

Category: SaaS & APIs
Used by: 2 nodes

Settings

What the connection form asks for. Every connection has a Staging side, which it needs, and an optional Production side with values of its own; both ask for the same settings.

Service Account JSON

Paste the service account key JSON. Share every target spreadsheet with the account's client_email (Editor for write access). Stored encrypted, and never shown again after you save it.

Testing the connection

Test exchanges the service-account key for a token with Google.

Good to know

Share every spreadsheet a node reads or writes with the service account's client_email, as an Editor for writing.
One connection works across many spreadsheets; each node picks the spreadsheet, the tab and the range.

Nodes that use it

Google Sheets input

Read a tab and range from a Google spreadsheet. Column types are inferred unless you read everything as text.

Google Sheets output

Write rows to a tab in a Google spreadsheet, overwriting or appending, and optionally creating the tab.