Google Sheets Reader

Manipulator

This node reads a tab ("sheet") of a Google spreadsheet. The spreadsheet can be selected from the spreadsheets available on Google Drive. Optionally, a specific range can be read from the sheet. The range must be entered in A1 notation (E.g. "A1:G10").

For more information about A1 notation visit: developers.google.com/sheets/api/guides/concepts#a1_notation

Input Ports

  1. Type: Google Sheets A Google Sheets Connection.

Output Ports

  1. Type: Data The retrieved sheet.

Find here

KNIME Labs > Google API Connectors (Labs) > Google Sheets Connectors

Make sure to have this extension installed: