Parameters
Title for the new Google Sheets document.
Name of the first worksheet created in the spreadsheet.
Fallback rows used when the
input port does not provide data.Controls how input rows are interpreted.
Set to
true for a list of objects with matching keys (header row is created automatically).
Set to false for a list of row arrays.Credentials
Select a Google OAuth Credential with the Google Sheets scopes needed by this node.
Inputs
Row data to write to the new sheet. If no input arrives, the node writes from the
Rows parameter instead.Outputs
A JSON object describing the created spreadsheet and write result.
| Field | Description |
|---|---|
spreadsheet_id | Google Sheets spreadsheet ID. |
spreadsheet_url | URL of the created spreadsheet, when returned by the API. |
sheet_name | Worksheet name used for creation and writes. |
row_count_written | Number of rows written, including headers in record mode. |
updated_range | Range updated by the write operation (for example Sheet1!A1:C10). |