How to use the n8n Summarize Node (Like a Data Analyst)
Description
🧠Don’t miss out! Get FREE access to my Skool community — packed with resources, tools, and support to help you with Data, Machine Learning, and AI Automati...
My Notes
Notes
00:00 Introduction to the Summarize Node
- Allows data analysis like a data analyst would perform
- Examines aggregates: average, min, max, sum of incoming items
- Option to group by fields for segmented analysis
01:03 Basic Concepts & Use Cases
- Summarizes across items (takes multiple items as input, outputs single or grouped items)
- Useful for:
- Internal data tables
- Spreadsheets (Google Sheets, Excel, CSV)
- Building conditional logic (if/else, switch, filter) based on results
- Can output one or multiple items depending on configuration
- Similar to data analyst work with counts, min, max, sum, average
- Alternative languages: SQL, Python pandas (but n8n has native summarize node)
02:35 Basic Count Aggregation
- 03:06 Count basics:
- Counts total number of items present
- Output format:
count_[fieldname] - Example: 7 total items = count_category returns 7
04:51 Count Unique
- Counts only unique/distinct values in a field
- Difference from count:
- Count: Total number of items present
- Count Unique: Number of different values
- Example: Dataset with fruit, vegetable, grain categories
- Count = 7 (all items)
- Count Unique = 3 (only 3 different categories)
- 06:01 Applicable to both strings and numbers
- Can count unique IDs, prices, etc.
08:23 Numeric Aggregations
-
Min & Max:
- 08:33 Min returns smallest value; Max returns largest value
- Order doesn't matter; finds extremes regardless
- Example: [20, 15, 11, 8, 7] → min=7, max=20
-
Sum:
- 10:04 Adds all values together
- Example: 20+15+11+8+7 = 61
-
Average:
- 10:58 Calculated as: Sum Ă· Count
- Example: 61 Ă· 5 = 12.2
-
11:35 Missing Median:
- Not available in summarize node
- Median is important because average can be skewed by outliers
- Example: [1, 2, 3, 4, 100] → median=3, average=22
- Workaround: Use code node for median calculation
- 14:07 Handling outliers:
- Can remove outliers using filter or if node before summarizing
- Necessary for accurate statistical analysis
15:44 Multiple Summaries in One Node
- Can calculate multiple aggregations simultaneously (count, average, max, etc.)
- All results appear in a single output item
- 16:40 Add additional fields by clicking "add field" option
- More efficient than running separate summarize nodes
16:59 Group By (Fields to Split By)
- 17:12 Splits aggregations by category:
- Example: Calculate statistics for each person separately
- Person A: 2 orders, average=3.5, max=5
- Person B: 2 orders, average=6.5, max=11
- Person C: 1 order, average=1, max=1
- 18:12 Drag field to "fields to split by" to enable grouping
- 19:07 Known as "GROUP BY" in standard data operations
- Creates separate items for each group
19:51 Output Format Options
- Default: Each split in separate item (multiple output items)
- Alternative: All splits in single item (one output item with array)
- Choose based on downstream workflow needs
20:56 Concatenate (String Formatting)
- Combines items into a single string with custom separator
- Options:
- Comma:
20,15,11,8,7 - Comma and space:
20, 15, 11, 8, 7 - New line (
\n): Separates items on new lines - None: Items concatenated with no separator:
20151187 - Space:
20 15 11 8 7 - Other: Custom separator (star, exclamation point, etc.)
- Comma:
- 21:39 Useful for formatting arrays as formatted strings
23:29 Append vs Aggregate
- Both can combine items into an array
- Append: Converts items to array format
- Aggregate: Similar functionality
- Recommendation: Use aggregate in most cases
24:15 Summary & Key Takeaways
- Count vs Count Unique: Presence vs distinctness
- Min, Max, Sum, Average: Use with numeric data
- Multiple summaries possible in single node
- Group By (Fields to Split By): Segment data by category
- Output format options: Single or multiple items
- Concatenate: Format items as strings with custom separators
- Missing features: Median (requires code node)
- 25:45 Creator has 30+ n8n tutorial videos; goal is 100+ videos
How to use the n8n Summarize Node (Like a Data Analyst)
Interactive graph
On this page
Description
My Notes
Notes
00:00 Introduction to the Summarize Node
01:03 Basic Concepts & Use Cases
02:35 Basic Count Aggregation
04:51 Count Unique
08:23 Numeric Aggregations
15:44 Multiple Summaries in One Node
16:59 Group By (Fields to Split By)
19:51 Output Format Options
20:56 Concatenate (String Formatting)
23:29 Append vs Aggregate
24:15 Summary & Key Takeaways