Hub
NodeNode / Manipulator

Google Sheets Reader
Drag & drop
Like
Copy short link

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

Node details

Input ports
  1. Type: Google Sheets
    Google Sheets Connection
    A Google Sheets Connection.
Output ports
  1. Type: Table
    Buffered Data Table
    The retrieved sheet.

Extension

The Google Sheets Reader node is part of this extension:

Related workflows & nodes

  1. Accessing Google Sheets
    KNIME Advanced Luck Books Google +3
    Here we access and read the content from a Google Spreadsheet, containing InChI keys iden…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter3 > 1. Access__GoogleSheets
  2. Accessing Google Sheets
    KNIME Advanced Luck Books Google +3
    Here we access and read the content from a Google Spreadsheet, containing InChI keys iden…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter3 > 1. Access__GoogleSheets
  3. Accessing Google Sheets
    KNIME Advanced Luck Books Google +3
    Here we access and read the content from a Google Spreadsheet, containing InChI keys iden…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter3 > 1. Access__GoogleSheets
  4. Googleスプレッドシート - Google Spread Sheets
    Japanese 日本語 makkynm +10
    Google Sheets Connection / Google Sheets Reader Writerの紹介用Workflowです。 拡張機能のインストールが必要になります…
    makkynm > Public > Intermediate > I207_GoogleSpreadSheet
  5. Chapter 3 / Exercise 1
    KNIME Advanced Luck Books Google +6
    This exercise illustrates how to extract data from Google Sheets and use this data in a G…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter3 > Exercises > Exercise 1
  6. Chapter 3 / Exercise 1
    KNIME Advanced Luck Books Google +6
    This exercise illustrates how to extract data from Google Sheets and use this data in a G…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter3 > Exercises > Exercise 1
  7. Chapter 3 / Exercise 1
    KNIME Advanced Luck Books Google +6
    This exercise illustrates how to extract data from Google Sheets and use this data in a G…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter3 > Exercises > Exercise 1
  8. Google Authentication - Sheets and Drive
    wiswedel > Public > Google Authentication - Sheets and Drive
  9. Read all sheets from Google Sheet & Excel with loop nodes
    Google Sheet XLS Loop +3
    This workflow demonstrate how to read all the sheets (or selected sheets) from a Google S…
    yemunn_soe_ydsc > Public > Read all sheets from Google Sheet & Excel with loop nodes
  10. Google Sheets Verarbeitung
    barth_kevin > Public > Google Sheets Verarbeitung