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 Connector47 %
- Variable Creator6 %
- Wait...4 %
- Table Row to Variable Loop Start3 %
- Java Edit Variable2 %
- Google Sheets Updater2 %
Google Drive Connection1 %Table Row to Variable1 %- String Configuration1 %
- Google Drive Connector1 %
- String Manipulation1 %
Generic Loop Start1 %- Extract Variables (Data)1 %
- DB Insert1 %
- Java Edit Variable (simple)1 %
Table Row To Variable Loop Start< 1 %- String Manipulation (Variable)< 1 %
- Google Sheets Writer< 1 %
- Try (Variable Ports)< 1 %
Loop End< 1 %- Column Filter< 1 %
Row Filter (deprecated)< 1 %- String Input (legacy)< 1 %
- Table Column to Variable< 1 %
- Table Row to Variable< 1 %
Google Authenticator (Deprecated)< 1 %- GroupBy< 1 %
- Excel Reader< 1 %
- Variable Expressions< 1 %
- Google Sheets Reader< 1 %
- Rule Engine< 1 %
- Merge Variables< 1 %
- Table Creator< 1 %
- Generic Loop Start< 1 %
- Concatenate< 1 %
- Duplicate Row Filter< 1 %
- CSV Reader< 1 %
Google Sheets Interactive Service Provider< 1 %- 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)< 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 (legacy)< 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 (legacy)< 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 155 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.