Output
Google Sheets Output
Writes the incoming rows to a tab of a Google spreadsheet and passes the same rows on to the next node.
When to use it
Use it when the people who need the result work in Google Sheets and want the numbers refreshed in a tab they already have open.
In a pipeline
File InputGroup ByGoogle Sheets 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 |
| Write Mode | select | — | append |
Example
Publish regional totals to a shared sheet
- Tab=Totals
- Write Mode=Append rows
| Region | sum |
|---|---|
| North | 160 |
| South | 80 |
| Region | sum |
|---|---|
| North | 160 |
| South | 80 |
Append writes a header row first when the tab has nothing in its first row, then adds the data rows under it.
Worth knowing
- Share the spreadsheet with the connection's service account address as an Editor, otherwise the write is refused.
- The Spreadsheet field accepts either the full sheet link or the bare id.
- Replace clears the tab and writes a header row plus the data, so anything else on that tab is lost.
- A preview never writes to the sheet.