Output node
Google Sheets output
Write rows to a tab in a Google spreadsheet, overwriting or appending, and optionally creating the tab.
- Category
- Output
- Connection
Google Sheets
What it does
Writes the pipeline's rows to a tab in a Google spreadsheet (through a saved Google Sheets Connection). Overwrite clears the tab and writes fresh (optionally with a header row, from a chosen start cell); Append adds rows below the existing data. It can create the tab first if it doesn't exist. Numbers and dates are re-typed by Sheets on write.
Inputs and outputs
| Inputs | One. |
| Outputs | None. This node ends a pipeline. |
When to use it
- Publish a report or summary to a shared spreadsheet
- Append run results to a running log tab
- Refresh a dashboard's source tab on a schedule
Examples
Full refresh
write mode: Overwrite start cell: A1
Append log
write mode: Append
Adds rows below the current data; no header written.
New tab
create tab if missing: on tab: Results
Tips
- Share the spreadsheet with the service account's client_email as an Editor.
- Sheets has no transaction, so an Overwrite that fails part way leaves the tab partly written.
- Append never writes a header row (the tab is assumed to already have one).