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 Successors
- Table Cropper27 %
- Joiner3 %
- Column Filter3 %
Concatenate (Optional in)2 %Row Filter (deprecated)2 %- Rule-based Row Filter2 %
- Concatenate2 %
- GroupBy1 %
- Variable to Table Column1 %
- Case Converter< 1 %
Excel Writer (XLS)< 1 %Table Row to Variable< 1 %- Column Appender< 1 %
Column Rename< 1 %Merge Variables< 1 %- String to Path< 1 %
String to Date&Time< 1 %- Catch Errors (Data Ports)< 1 %
Table Row To Variable Loop Start< 1 %String To Number< 1 %Loop End< 1 %- Column Renamer (Dictionary)< 1 %
- Send Email< 1 %
- Column Auto Type Cast< 1 %
- Column Merger< 1 %
- String Manipulation< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Google Sheets Writer< 1 %
Table Writer< 1 %- Google Sheets Reader< 1 %
- String to Date/Time (legacy)< 1 %
- Table Manipulator< 1 %
- DB Loader< 1 %
- Group Loop Start< 1 %
- String to Number< 1 %
- Column Name Replacer< 1 %
- Reference Row Splitter< 1 %
- Sorter< 1 %
- Extract Table Dimension< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Chunk Loop Start< 1 %
- Recursive Loop Start< 1 %
Gradient Boosted Trees Learner< 1 %- Column Combiner< 1 %
- Number to String< 1 %
- Cross Joiner< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Row Filter (Labs)< 1 %
Column Splitter< 1 %- Table Splitter< 1 %
- Table Difference Finder< 1 %
- IF Switch< 1 %
- Statistics View< 1 %
DB Insert< 1 %- Parameterized DB Query Reader< 1 %
DB Table Creator< 1 %- Excel Cell Updater< 1 %
- Google Sheets Updater< 1 %
- Data to Report (BIRT)< 1 %
Date&Time Difference< 1 %- Wait...< 1 %
- Table Row to Variable< 1 %
- CSV Writer< 1 %
- Table Writer< 1 %
- Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Decision Tree Learner< 1 %
Cell Replacer< 1 %- Cell Splitter< 1 %
- Cell Splitter By Position< 1 %
- Column Renamer< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Column Resorter< 1 %
Constant Value Column< 1 %- Duplicate Row Filter< 1 %
- Filter Apply< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Pivot< 1 %
- Missing Value< 1 %
- Row Aggregator< 1 %
- RowID< 1 %
- Row to Column Names< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
String Replace (Dictionary)< 1 %- Table Transposer< 1 %
- Unpivot< 1 %
- Value Lookup< 1 %
- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
- Rule Engine (Dictionary)< 1 %
- Statistics< 1 %
- Color Manager< 1 %
- Bar Chart< 1 %
- Pie Chart< 1 %
- Parquet Writer< 1 %
DB Writer< 1 %DB Table Creator< 1 %- Similarity Search< 1 %
- Column Expressions (legacy)< 1 %
- Math Formula< 1 %
Read Excel Sheet Names (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Excel Writer< 1 %
- String Matcher< 1 %
- Strings to Document< 1 %
- List Files/Folders< 1 %
- Google Sheets Appender< 1 %
- Value Filter (legacy)< 1 %
- Table to JSON< 1 %
- Python Script (legacy)< 1 %
- R Snippet< 1 %
- Table to R< 1 %
- GET Request< 1 %
- Date&Time-based Row Filter< 1 %
Delete Files< 1 %- Active Branch Inverter< 1 %
- Table Partitioner< 1 %
- XLS Control Table Generator< 1 %
- ARIMA Learner< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %- Table Column to Variable< 1 %
Database Update< 1 %- Linear Correlation< 1 %
- DB Table Deleter< 1 %
- DL Python Network Learner< 1 %
- Send to Tableau Server< 1 %
- Dictionary Tagger< 1 %
- Delete Files/Folders< 1 %
Create Date&Time Range< 1 %- Message Slack channel< 1 %
- URL Encode< 1 %
Download / Upload from List< 1 %Variable to Table Row< 1 %CSV Writer< 1 %- Java Edit Variable< 1 %
- OPTICS Cluster Compute< 1 %
Cell Splitter< 1 %Linear Correlation< 1 %- Table Validator (Reference)< 1 %
- Rank< 1 %
- Reference Column Resorter< 1 %
- Value Counter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Extract Table Spec< 1 %
- Crosstab< 1 %
- Interactive Pie chart (legacy)< 1 %
- ORC Writer< 1 %
- Molecule Type Cast< 1 %
- Counter Generation< 1 %
- Case Converter< 1 %
- Column Selection Configuration< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- Container Output (JSON)< 1 %
Python Script (2⇒1)< 1 %Modify Date< 1 %Python Snippet< 1 %- Convert to R< 1 %
- MolConverter< 1 %
- Table to String< 1 %
- Extract URI Info< 1 %
- Files to Binary Objects< 1 %
- String to URI< 1 %
Upload< 1 %Variable to Table Column< 1 %- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
- Read Images< 1 %
Database Delete< 1 %Database Reader< 1 %Database SQL Executor< 1 %Database Writer< 1 %Database Connector< 1 %Database Drop Table< 1 %Table Reader< 1 %- Table Creator< 1 %
- Java Snippet< 1 %
Loop End (2 ports)< 1 %- Column List Loop Start< 1 %
Variable Condition Loop End< 1 %Recursive Loop Start< 1 %k-Means (deprecated)< 1 %- Logistic Regression Learner< 1 %
- Regression Predictor< 1 %
- Numeric Scorer< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Constant Value Row Appender< 1 %
Auto-Binner< 1 %- Create Bit Vector< 1 %
Number To String< 1 %Column Appender< 1 %- Lag Column< 1 %
- Double to Integer< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply Row Splitter< 1 %
- HiLite Row Splitter< 1 %
- String Splitter (Regex)< 1 %
- Number Rounder< 1 %
- Set Operator< 1 %
- Ungroup< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- Numeric Outliers< 1 %
- One-way ANOVA< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (Start)< 1 %- Merge Variables< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
Parquet Writer< 1 %- MySQL Connector< 1 %
DB Loader< 1 %DB Update< 1 %- DB SQL Executor< 1 %
- Scatter Plot (Plotly)< 1 %
- OpenBabel< 1 %
- Table to H2O< 1 %
- Math Formula (Multi Column)< 1 %
Send to Power BI< 1 %- Send to Power BI< 1 %
- Java Snippet (simple)< 1 %
Send to Tableau Server (Hyper)< 1 %- Chi-Square Keyword Extractor< 1 %
- Tika Parser URL Input< 1 %
- Dictionary Filter< 1 %
- Stop Word Filter< 1 %
- Abner Tagger< 1 %
- Document Viewer< 1 %
- Google Sheets Connector< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- Tag Cloud (JavaScript) (legacy)< 1 %
- File Download Widget< 1 %
Python Script (1⇒1)< 1 %- R View (Table)< 1 %
- Webpage Retriever< 1 %
- Date&Time to legacy Date&Time< 1 %
Extract Date&Time Fields< 1 %Date&Time Shift< 1 %- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- Twitter Users (legacy)< 1 %
- Table to HTML String< 1 %
- Google Address Geocoder< 1 %
- MapQuest Geocoder< 1 %
- Latitude/Longitude to Coordinate< 1 %
Regex Extractor< 1 %- URL Domain Extractor< 1 %
- HTTP Retriever< 1 %
Web Searcher< 1 %- Bulk RemoteWebDriver Factory< 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 197 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.