Google Sheets Appender

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

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

Views

This node has no views

Workflows

• Google Sheet Troubleshooting.knarKNIME Forum
• Google Sheet Troubleshooting.knarKNIME Forum
• payroll_split_file_v1KNIME Forum
• payroll_split_file_v1.knarKNIME Forum
• täglich_crawlbudget_adverityNodePit Space
• Show all 6 workflows

Links

• No links available

Developers