Hub
NodeNode / Manipulator

Google Sheets Reader

KNIME Labs Google API Connectors (Labs) Google Sheets Connectors
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. 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.5_2022011 > AdvancedLuck > Chapter3 > 1. Access__GoogleSheets
  5. Googleスプレッドシート - Google Spread Sheets
    Japanese 日本語 Makkynm
    +10
    Google Sheets Connection / Google Sheets Reader Writerの紹介用Workflowです。 拡張機能のインストールが必要になります…
    makkynm > Public > Intermediate > I207_GoogleSpreadSheet
  6. Read Data from Google Sheets and Google Drive
    Google Drive Connector Google Sheets Reader File Reader
    +5
    This workflow demonstrates how to read data from Google Sheets and data files (Text, Exce…
    knime > Beginners Space > 01_Read > 03_Read_Data_from_Google_Drive
  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…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter3 > Exercises > Exercise 1
  8. 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
  9. 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
  10. Data Wrangling _ Search String in Multiple Lines
    Word search Regex
    Workflow created for the KNIME forum ... https://forum.knime.com/t/search-string-within-m…
    gonhaddock > Public > Data Wrangling _ Search String in Multiple Lines