Google Sheets Updater

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.

Refresh

Refreshes the list of available spreadsheets from Google Drive.

Open in browser

Opens the selected spreadsheet in the browser.

Select first sheet

When selected, the first sheet of the spreadsheet will be updated instead of the one selected from the drop-down menu.

Sheet

The sheet from the spreadsheet that should be updated. Available sheets can be selected from the drop-down menu.

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.

Append to sheet

When this option is selected, the data table content will be appended to the selected sheet.

Select range

Specify whether a range should be read from the sheet.

Range

The range that should be read 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 RowIDs should be written in the first column.

Fill in missing values

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.

Missing value substitute

The value which is substituted for missing values.

Write raw (do not parse numbers, dates, hyperlinks, etc.)

Values are written into the spreadsheet as-is ("raw"), i.e. they will not be parsed. Uncheck the option, if values should be written into the spreadsheet as if they were entered via the Google Sheets website. If unchecked, numbers will stay as numbers, but other strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets website. For example, strings like =hyperlink("example.com", "example") will be parsed to hyperlinks if this option is unchecked.

Open spreadsheet after execution

Opens the spreadsheet after it has been written successfully. The spreadsheet will be opened in the system'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

• 1st_ass_casualty_dimensionKNIME Hub
• 1st_ass_collision_dimensionKNIME Hub
• 1st_ass_conditions_dimensionKNIME Hub
• 1st_ass_data_preprocessingKNIME Hub
• 1st_ass_diensionsKNIME Hub
• Show all 74 workflows

Links

• No links available

Developers