This node writes the input data table to an existing Google sheet. It can overwrite some or all of the content of a sheet or append to the content of a sheet. If only part of the content of a sheet is to be overwritten, the relevant range can be specified in A1 notation. The size of the input table must not exceed the size of the selected range, otherwise execution will fail.
Options
Popular Predecessors
- Column Resorter6 %
Google Sheets Interactive Service Provider5 %- Joiner4 %
Row Filter (deprecated)4 %- Column Filter4 %
- GroupBy4 %
- Sorter4 %
- Google Sheets Connector4 %
- Concatenate4 %
- Rule Engine3 %
- Google Sheets Updater3 %
Column Rename3 %- Duplicate Row Filter2 %
- Excel Writer1 %
- String Manipulation1 %
- Rule-based Row Filter1 %
- Variable Creator1 %
Table Row to Variable1 %- Column Expressions (legacy)1 %
String To Number1 %- Google Sheets Reader1 %
- Missing Value< 1 %
- Number Rounder< 1 %
- Math Formula< 1 %
- Table Row to Variable< 1 %
Concatenate (Optional in)< 1 %- Column Renamer< 1 %
Column Appender< 1 %- Pivot< 1 %
- Chunk Loop Start< 1 %
- R Snippet< 1 %
Row Splitter (deprecated)< 1 %- String to Date&Time< 1 %
- Constant Value Column< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- String to Number< 1 %
Excel Reader (XLS)< 1 %Table Row to Variable< 1 %- Date&Time-based Row Filter< 1 %
- Wait...< 1 %
- String Manipulation (Variable)< 1 %
- Table Manipulator< 1 %
- Number to String< 1 %
- Send Email< 1 %
- DB Query Reader< 1 %
- Rule-based Row Splitter< 1 %
- Boolean Configuration< 1 %
- String Manipulation (Multi Column)< 1 %
- Excel Reader< 1 %
CSV Writer< 1 %- Java Snippet (simple)< 1 %
- Table Transposer< 1 %
- End IF< 1 %
- Value Lookup< 1 %
- Reference Row Splitter< 1 %
- Loop End< 1 %
- Column Name Extractor< 1 %
Loop End< 1 %- Statistics< 1 %
- DB Reader< 1 %
- Split Collection Column< 1 %
- Nominal Value Row Splitter< 1 %
- Unpivot< 1 %
- Math Formula (Multi Column)< 1 %
Variable to Table Column< 1 %- Table Creator< 1 %
- Column Auto Type Cast< 1 %
- Modify Date< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Ungroup< 1 %
- Modify Time< 1 %
- Try (Data Ports)< 1 %
- Column Aggregator< 1 %
- Double to Integer< 1 %
Joiner< 1 %- Rule Engine Variable< 1 %
- R to Table< 1 %
Table Reader< 1 %Cell Replacer< 1 %- Variable to Table Row< 1 %
- Generic Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Combiner< 1 %
- Rule Engine (Dictionary)< 1 %
- Empty Table Switch< 1 %
- Integer Configuration< 1 %
- Table View (JavaScript)< 1 %
- Scorer< 1 %
- Catch Errors (Data Ports)< 1 %
Table Row To Variable Loop Start< 1 %Database Reader< 1 %- Add Empty Rows< 1 %
- Column Renamer (Dictionary)< 1 %
- Cross Joiner< 1 %
- Date&Time to String< 1 %
Extract Date&Time Fields< 1 %- Date&Time Shift< 1 %
- String to Date/Time (legacy)< 1 %
- Try (Variable Ports)< 1 %
- Java Snippet< 1 %
- Group Loop Start< 1 %
- Cell Splitter< 1 %
- Missing Value Column Filter< 1 %
- Partitioning< 1 %
- RowID< 1 %
- Column Splitter< 1 %
- String Replacer< 1 %
- Top k Row Filter< 1 %
- Merge Variables< 1 %
Excel Writer (XLS)< 1 %- Google Sheets Appender< 1 %
- JSON to Table< 1 %
- Moving Average< 1 %
- CSV Reader< 1 %
- Variable Loop End< 1 %
- Column Appender< 1 %
- IF Switch< 1 %
- List Files/Folders< 1 %
- Python Script (legacy)< 1 %
- Date&Time Difference< 1 %
- Date&Time Part Extractor< 1 %
- Table Column to Variable< 1 %
- Read Excel Sheet Names< 1 %
- Variable to Table Column< 1 %
- File Reader< 1 %
Parameterized Database Query< 1 %Variable Condition Loop End< 1 %- String Configuration< 1 %
Number To String< 1 %Table Column to Variable< 1 %Variable to Table Row< 1 %Variable to Table Row< 1 %Linear Correlation< 1 %- Boolean Input (legacy)< 1 %
- String Input (legacy)< 1 %
- JSON Path< 1 %
- Mask Date/Time (legacy)< 1 %
- Google Address Geocoder< 1 %
- Catch Errors (Var Ports)< 1 %
- String to Path (Variable)< 1 %
- Nominal Row Filter Configuration< 1 %
Variable Loop End< 1 %- Column Merger< 1 %
Merge Variables< 1 %- Empty Table Creator< 1 %
- Download / Upload from List (legacy)< 1 %
- Extract Variables (Data)< 1 %
CSV Reader< 1 %- Loop End (Column Append)< 1 %
- Numeric Binner< 1 %
- Table Validator (Reference)< 1 %
- Equal Size Sampling< 1 %
- Google Sheets Writer< 1 %
Python Script (2⇒1)< 1 %- HTTP Retriever< 1 %
- k-Means< 1 %
- Numeric Row Splitter< 1 %
CASE Switch Data (Start)< 1 %- DB Merge< 1 %
- DB Query< 1 %
Python Script (1⇒1)< 1 %Database Connection Table Reader< 1 %- Java Edit Variable< 1 %
- Column Rename (Regex)< 1 %
- Filter Apply Row Splitter< 1 %
- Reference Column Resorter< 1 %
- Row Sampling< 1 %
- Cronbach Alpha< 1 %
- Java Edit Variable (simple)< 1 %
- Date&Time Input (legacy)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Date Field Extractor (legacy)< 1 %
- Download (legacy)< 1 %
Table Column to Variable< 1 %File Reader< 1 %Loop End (2 ports)< 1 %Interval Loop Start< 1 %Generic Loop Start< 1 %- Create Bit Vector< 1 %
- Category to Number< 1 %
- One to Many< 1 %
- Reference Column Filter< 1 %
- Row Filter (Labs)< 1 %
- Missing Value (Apply)< 1 %
- Number to String (PMML)< 1 %
- Rank< 1 %
- Value Counter< 1 %
- Renderer to Image< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Color Manager< 1 %
Excel Reader (XLS)< 1 %- Spark Line Appender< 1 %
Google Analytics Query (deprecated)< 1 %- Multiple Selection Configuration< 1 %
- Table Editor (JavaScript)< 1 %
- Python Source (legacy)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date/Time Shift (legacy)< 1 %
- HTTP Result Data Extractor< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- Timed Loop End (2 port)< 1 %
- Timed Loop End (1 port)< 1 %
- R Snippet< 1 %
Variable to Table Column< 1 %- Variable Condition Loop End< 1 %
Recursive Loop Start< 1 %- Regression Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Case Converter< 1 %
- Shuffle< 1 %
- Data Generator< 1 %
- Timer Info< 1 %
- Spark to Table< 1 %
- Parameterized DB Query Reader< 1 %
- TimeDelay Loop Start< 1 %
- Variable Expressions (legacy)< 1 %
- Java IF (Table)< 1 %
- Create File/Folder Variables< 1 %
- Delete Files/Folders< 1 %
- Column Filter (legacy)< 1 %
- Container Input (JSON)< 1 %
- Python Edit Variable (legacy)< 1 %
- GET Request< 1 %
- Salesforce Simple Query< 1 %
- Duration to Number< 1 %
- String to Duration< 1 %
- XPath< 1 %
Views
- This node has no views
Workflows
1st_ass_casualty_dimensionKNIME Hub- 1st_ass_collision_dimensionKNIME Hub
- 1st_ass_conditions_dimensionKNIME Hub
- 1st_ass_data_preprocessingKNIME Hub
- 1st_ass_diensionsKNIME Hub
- Show all 63 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.