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
Options
Popular Predecessors
- Google Sheets Connector6 %
- Variable Creator6 %
- Java Edit Variable5 %
- Table Row to Variable5 %
Google Drive Connection3 %Table Row to Variable3 %- Google Sheets Reader3 %
- String Configuration3 %
- String Manipulation3 %
Generic Loop Start2 %- Extract Variables (Data)2 %
DB Insert2 %- Java Edit Variable (simple)2 %
- Column Filter2 %
- Table Row to Variable Loop Start2 %
- Wait...2 %
Table Row To Variable Loop Start2 %- String Manipulation (Variable)2 %
- Google Sheets Writer2 %
- Try (Variable Ports)2 %
Loop End2 %Row Filter (deprecated)2 %- String Input (legacy)2 %
- Table Column to Variable2 %
Google Authenticator (Deprecated)2 %- GroupBy2 %
- Excel Reader2 %
- Variable Expressions (legacy)2 %
- Google Sheets Updater2 %
- Rule Engine2 %
- Merge Variables2 %
- Google Drive Connector2 %
- Table Creator2 %
- Generic Loop Start2 %
- Concatenate2 %
- Duplicate Row Filter2 %
- CSV Reader2 %
Google Sheets Interactive Service Provider1 %- Single Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- String Widget< 1 %
Google Authenticator (API Key)< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %- Single Selection Configuration< 1 %
- Single Selection Widget< 1 %
Table Row to Variable< 1 %- Generic JavaScript View (JavaScript) (legacy)< 1 %
- List to FlowVariable< 1 %
IF Switch (Flow Variable Value)< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %- Try (Data Ports)< 1 %
Table Column to Variable< 1 %CSV Reader< 1 %Model Reader< 1 %Joiner< 1 %Merge Variables< 1 %- TimeDelay Loop Start< 1 %
Google Analytics Connector (deprecated)< 1 %- Date&Time Configuration< 1 %
- List Box Input (legacy)< 1 %
- Value Selection Widget< 1 %
- Python Edit Variable (legacy)< 1 %
- Catch Errors (Var Ports)< 1 %
CASE Switch Variable (Start)< 1 %DB Writer< 1 %Google Cloud Storage File Picker< 1 %- Boolean Configuration< 1 %
- Reset on Load< 1 %
Views
- This node has no views
Workflows
[01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub- [03.CX] Extracting and Transforming Viber Broadcast Data from InfobipKNIME Hub
- [04.CX] Capturing Messenger LiveChat Data in Real-Time with ManyChat and Google SheetsKNIME Hub
- 01_Get_Request_DemoKNIME Hub
- 01_Get_Request_DemoKNIME Hub
- Show all 217 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.