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
\n \t\t\n \n ","shortDescription":"Read tables from Google Sheets.","keywords":["Spreadsheet"],"deprecated":false,"streamable":false,"tags":["IO","Read"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QAAAAAAAD5Q7t/AAAACXBIWXMAAQOFAAEDhQGlVDz+AAAAB3RJTUUH4QgVDwseVNwtfgAABBtJREFUOBEBEATv+wEEmFD/AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAD7Z68AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFmVEAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAWZUQAAAAAAAAAAAPtnrwAFmVEAAAAAAAAAAAAAAAAAAAAAAAAAAAD7Z68AAAAAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAD7Z68AAAAAAAAAAAAAAAAA+2evAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAABZlRAAAAAAAAAAAA+2evAAWZUQAAAAAAAAAAAAAAAAAAAAAAAAAAAPtnrwAAAAAAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAPtnrwAAAAAAAAAAAAAAAAD7Z68AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBJhQ/wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAaVgbQ+WvbE4AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.google.api.sheets.data.GoogleSheetsConnectionPortObject","color":"16a965","dataType":"Google Sheets","optional":false,"name":"Google Sheets Connection","description":"A Google Sheets Connection."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Buffered Data Table","description":"The retrieved sheet."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"fields":[{"name":"Spreadsheet","description":"The spreadsheet can be selected from the spreadsheets available on Google Drive. You can see the unique spreadsheet ID by hovering over the name.","optional":false},{"name":"Select...","description":"Opens a dialog which lists the available spreadsheets from google drive. In the dialog you can see the unique spreadsheet ID by hovering over the names.","optional":false},{"name":"Open in Browser...","description":"Opens the selected spreadsheet in the browser.","optional":false},{"name":"Sheet","description":"The sheet from the spreadsheet that should be read. Available sheets can be selected from the drop-down menu.","optional":false},{"name":"Select First Sheet","description":"When selected, the first sheet of the spreadsheet will be read instead of the one selected from the drop-down menu.","optional":false},{"name":"Range","description":"Here the range that should be read from the sheet can be specified in A1 notation. (E.g. "A1:G20")","optional":false},{"name":"Read column name","description":"Here you can specify whether the first row of the sheet should be read as column names.","optional":false},{"name":"Read row id","description":"Here you can specify whether the first column of the sheet should be read as row ID's.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:3784265b-0f76-45f2-9a61-e472e4206f70","user":"nimantha","date":"2021-02-07T17:28:47+00:00"},{"accountId":"account:user:eb541709-47f6-4143-9b78-1358e5f95943","user":"ianaugustos","date":"2023-06-07T00:54:58+00:00"}],"kudosCount":2,"bundleInformation":{"bundleVersion":"5.4.3.v202503031608","bundleName":"KNIME Google API Nodes","bundleSymbolicName":"org.knime.google.api","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.google.api","featureName":"KNIME Google Connectors","featureVersion":"5.12.0.v202605041104","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*9KacbeCTeoRZrjhi"},"frequentSuccessors":[{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.1404494382022472},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.0898876404494382},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.07303370786516854},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.06179775280898876},{"id":"*20rIDLuYXD4U8cnN","factoryName":"org.knime.base.node.preproc.colconvert.stringtonumber.StringToNumberNodeFactory","probability":0.0449438202247191},{"id":"*tORN7j1aLrofPiJ1","factoryName":"org.knime.google.api.sheets.nodes.spreadsheetwriter.GoogleSpreadsheetWriterFactory","probability":0.03932584269662921},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.03932584269662921},{"id":"*5xTQbnNLONK0vecv","factoryName":"org.knime.base.node.io.database.DBWriterNodeFactory","probability":0.028089887640449437},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.028089887640449437},{"id":"*WjxQ1iEwpLnEYBFw","factoryName":"org.knime.base.node.preproc.filter.definition.apply.FilterApplyNodeFactory","probability":0.02247191011235955}]}