Google Sheets input

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

Category: Input
Connection: Google Sheets

What it does

Reads a tab and range from a Google spreadsheet (through a saved Google Sheets Connection) and streams the cells into the pipeline. One credential works across many spreadsheets; each node picks its own spreadsheet, tab and range. Column types are inferred from the values (numbers, decimals, true/false) unless you read everything as text; codes with leading zeros like 007 stay text.

Inputs and outputs

Inputs	None. This node starts a pipeline.
Outputs	One.

When to use it

Pull a hand-maintained lookup or reference sheet into a pipeline
Ingest a shared spreadsheet on a schedule
Read one region of a large sheet with an A1 range

Examples

Whole tab

spreadsheet: <URL or ID>   tab: Sheet1

Blank range reads the whole used area.

A range

tab: Data   range: A1:D

A1 notation, or a named range.

Headerless

First row is header: off

Columns come out as column1, column2, …

Tips

Share the spreadsheet with the service account's client_email, or the read fails.
Press Load tabs to pull the real tab names from the spreadsheet.
Turn on 'Read all as text' when a column mixes numbers and codes you want left alone.", "Its columns show in the builder without a run: Trinium reads the range the same way the run does.