Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Google Sheets Reader
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    Googleスプレッドシート - Google Spread Sheets
    Japanese 日本語 Makkynm
    +10
    Google Sheets Connection / Google Sheets Reader Writerの紹介用Workflowです。 拡張機能のインストールが必要になります…
    makkynm > Public > Intermediate > I207_GoogleSpreadSheet
  6. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits