Connectors
Google Sheets
Reads one tab of a Google Sheet through a service account and returns it as rows.
When to use it
Use it when a team keeps the data in a shared spreadsheet and you want that tab in a pipeline without downloading it by hand.
In a pipeline
Google SheetsCalculated ColumnMySQL Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Spreadsheet | text | Yes | Paste the sheet link or its id |
| Tab | select | Yes | Select a tab |
| Range (optional) | text | — | e.g. A1:H500 |
Example
Reading a stock tab
- Spreadsheet=https://docs.google.com/spreadsheets/d/1BxAq7fPk2mR9tV/edit
- Tab=Stock
- Range (optional)=A1:C200
| SKU | Item | On Hand |
|---|---|---|
| SKU-114 | Blue mug | 42 |
| SKU-118 | Steel flask | 7 |
| SKU-121 | Cotton tote | 0 |
| SKU | Item | On Hand |
|---|---|---|
| SKU-114 | Blue mug | 42 |
| SKU-118 | Steel flask | 7 |
| SKU-121 | Cotton tote | 0 |
The first row of the range becomes the column names, so a range that starts below the header row loses it.
Worth knowing
- Share the spreadsheet with the service account's address as Viewer, otherwise the run fails with a permission error; Editor is only needed for Google Sheets Output.
- Spreadsheet takes either the full sheet link or the bare id; press Refresh to list the tabs.
- Range is A1 notation inside the tab, such as A1:H500; leave it empty to read the whole tab.
- Empty cells arrive as empty strings, and repeated header names are made unique (Item, Item_2).