Google Sheets Reader

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 read. Available sheets can be selected from the drop-down menu.

Select First Sheet

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

Range

Here the range that should be read from the sheet can be specified in A1 notation. (E.g. "A1:G20")

Read column name

Here you can specify whether the first row of the sheet should be read as column names.

Read row id

Here you can specify whether the first column of the sheet should be read as row ID's.

Views

This node has no views

Workflows

• [01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
• [03.CX] Extracting and Transforming Viber Broadcast Data from InfobipKNIME Hub
• [04.CX] Capturing Messenger LiveChat Data in Real-Time with ManyChat and Google SheetsKNIME Hub
• 01_Get_Request_DemoKNIME Hub
• 01_Get_Request_DemoKNIME Hub
• Show all 155 workflows

Links

• No links available

Developers