Hub
NodeNode / Manipulator

Google Sheets Reader

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. Google Sheets Connection Type: Google Sheets
    A Google Sheets Connection.
Output ports
  1. Buffered Data Table Type: Data
    The retrieved sheet.

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 identifying molecules on a chemica…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter3 > 1. Access__GoogleSheets
  2. 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 GET Request with the REST servi…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter3 > Exercises > Exercise 1
  3. Google Authentication - Sheets and Drive
    wiswedel > Public > Google Authentication - Sheets and Drive
  4. Will They Blend? Public Google Sheet meets Excel Sheet.
    Google Google Sheet Excel +5
    Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wa…
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 08_Google_Sheet-meets-Excel
  5. Public Google Sheet meets Excel Sheet.
    Google Google Sheet Excel +5
    Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wa…
    lcs > Public > 01_Data_Access > 01_Common_Type_Files > 08_Google_Sheet-meets-Excel
  6. Public Google Sheet meets Excel Sheet.
    Google Google Sheet Excel +5
    Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we wa…
    rene.damyon > Public > 08_Google_Sheet-meets-Excel
  7. Qlik
    charlym10 > Public > Qlik
  8. Qlik
    brahianvilllada > Public > Qlik
  9. Power Supply workflow
    There has been no description set for this workflow's metadata.
    v.matton > Public > power_supply
  10. buildings
    The buildings workflow is computing the blablabla
    v.matton > Public > buildings