How to use the n8n Summarize Node (Like a Data Analyst)

💼 Business owner or operator with a team? We build AI automation systems that cut costs and scale ops — done for you: https://ryanandmattdatascience.com/ai-consultant/ 🚀 Want to make money with AI skills? Join our free community — real projects, real client strategies, and the exact stack we use: https://www.skool.com/data-and-ai 🍿 WATCH NEXT N8N Playlist: https://www.youtube.com/playlist?list=PLcQVY5V2UY4K0mpuJ-oYO_LI25w5VDUD5 Learn how to analyze data like a professional data analyst using N8N's powerful Summarize node in this comprehensive tutorial. This video covers everything from basic count operations to advanced group-by functionality, showing you how to calculate averages, mins, maxs, sums, and more across your data sets without writing a single line of code. I walk through every aggregation option available in the Summarize node, including count, count unique, min, max, sum, and average operations. You'll discover the critical differences between count and count unique, understand when to use each type of aggregation, and learn how to handle outliers in your data sets. The tutorial also covers advanced features like splitting data by fields (group by operations), working with multiple summaries simultaneously, and choosing the right output format for your workflows. Whether you're analyzing customer data, processing orders, or working with any type of structured information, this guide will transform how you handle data in N8N. I share real-world examples using arrays, JSON data, and practical scenarios that data analysts face daily. You'll also learn about concatenation options, append operations, and why the median is missing from N8N (and how to work around it using code nodes). Perfect for automation builders, no-code enthusiasts, and anyone looking to add powerful data analysis capabilities to their N8N workflows. By the end of this tutorial, you'll confidently summarize data sets, create group-by operations, and build sophisticated data analysis automations without touching SQL or Python. TIMESTAMPS 00:00 Introduction to Summarize Node 01:30 Count vs Count Unique 03:00 Using Code Node & Split Out 04:00 Count Aggregation Example 05:00 Count Unique Explained 06:30 Min & Max Aggregations 08:15 Sum Aggregation 09:53 Average Aggregation 11:40 Missing Median Function 13:00 Multiple Summaries at Once 14:30 Fields to Split By (Group By) 16:45 Multiple Summaries with Split By 18:30 Output Format Options 20:40 Concatenate Separators 22:40 Append vs Aggregate 24:00 Recap & Final Thoughts OTHER SOCIALS: Ryan’s LinkedIn: https://www.linkedin.com/in/ryan-p-nolan/ Matt’s LinkedIn: https://www.linkedin.com/in/matt-payne-ceo/ Twitter/X: https://x.com/RyanMattDS Who is Ryan Ryan is a Data Scientist at a fintech company, where he focuses on fraud prevention in underwriting and risk. Before that, he worked as a Data Analyst at a tax software company. He holds a degree in Electrical Engineering from UCF. Who is Matt Matt is the founder of Width.ai, an AI and Machine Learning agency. Before starting his own company, he was a Machine Learning Engineer at Capital One. *This is an affiliate program. We receive a small portion of the final sale at no extra cost to you.