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. 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.6_20220810 > AdvancedLuck > Chapter3 > 1. Access__GoogleSheets
  6. Googleスプレッドシート - Google Spread Sheets
    Japanese 日本語 Makkynm
    +10
    Google Sheets Connection / Google Sheets Reader Writerの紹介用Workflowです。 拡張機能のインストールが必要になります…
    makkynm > Public > Intermediate > I207_GoogleSpreadSheet
  7. 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
  8. Keyword_Grouping_in_Gsheets
    fryfella > SEO Workflows > Keyword_Grouping_in_Gsheets
  9. Solution: Sending a GET Request
    Education
    This workflow retrieves product information via a GET request
    victor_palacios > Public > google sheets meets REST
  10. Solution: Sending a GET Request
    Education
    This workflow retrieves product information via a GET request
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.6_20220810 > AdvancedLuck > Chapter3 > Exercises > Exercise 1