0 ×

Google Sheets Updater

KNIME Google API Nodes version 4.0.0.v201905311239 by KNIME AG, Zurich, Switzerland

This node writes the input data table to an existing Google sheet. It can overwrite some or all of the content of a sheet or append to the content of a sheet. If only part of the content of a sheet is to be overwritten, the relevant range can be specified in A1 notation. The size of the input table must not exceed the size of the selected range, otherwise execution will fail.

Options

Spreadsheet
The spreadsheet can be selected from the spreadsheets available on Google Drive. You can see the unique spreadsheet ID by hovering over the name.
Select...
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
The sheet from the spreadsheet that should be updated. Available sheets can be selected from the drop-down menu.
Select First Sheet
When selected, the first sheet of the spreadsheet will be updated instead of the one selected from the drop-down menu.
Range
Here the range that should be updated from the sheet can be specified in A1 notation. (E.g. "A1:G20")
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.
Append to sheet
When this option is selected, the data table content will be appended to the selected sheet.
Clear sheet before writing
When this option is selected, the sheet or the selected range of the sheet will be cleared before writing. This deletes the content in the specified sheet/range.
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)

Workflows

Installation

To use this node in KNIME, install KNIME Twitter & Google Connectors from the following update site:

KNIME 4.0
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.

Developers

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.