0 ×

Google Sheets Appender

KNIME Google API Nodes version 4.3.0.v202011261638 by KNIME AG, Zurich, Switzerland

Writes the input table to a new sheet of an existing spreadsheet in Google Sheets.


The spreadsheet can be selected from the spreadsheets available on Google Drive. You can see the unique spreadsheet ID by hovering over the name.
Opens a dialog which lists the available spreadsheets from google drive. In the dialog you can see the unique spreadsheet ID by hovering over the names.
Open in Browser...
Opens the selected spreadsheet in the browser.
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.
Create unique sheet name
The node will create a unique sheet name based on the given sheet name. (Example: Should 'SheetOne' already exist, the unique sheet name will be 'SheetOne (#1)')
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

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME Google Cloud Storage Connection from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


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.