Google Sheets Writer

This node writes the input data table to a new Google Sheets spreadsheet.

If you want to overwrite or append data to an existing sheet, you cannot use the Google Sheets Writer node; you must use the Google Sheets Updater node.


Spreadsheet name
The name of the spreadsheet to be created.
Sheet name
The name of the sheet to which the table should be written.
Add column header
Here you determine whether the column names should be written in the first row.
Add row header
Here you determine whether the row ID's should be written in the first column.
For missing values write
By selecting this option, you can specify a string you want to substitute for missing values. If the option is left unchecked, the cells with missing values remain empty.
Open spreadsheet after execution
Opens the spreadsheet after it has been written successfully. The spreadsheet will be opened in the systems's default browser.
Exclude/Include columns
Select the columns that will be written to the sheet file. If the columns in the input table change, they will automatically be excluded.

Input Ports

A Google Sheets connection.
Table to be written to a google sheet

Output Ports

This node has no output ports


This node has no views




You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.