🔬 Beginner data analysis: merge, filter & summarize in Google Sheets with GPT-4o
⚡ 1,904 views · 🔬 Document Extraction & Analysis
Description
This beginner-friendly n8n workflow teaches essential data manipulation techniques using Google Sheets and AI. You’ll learn how to:
- ✅ Merge two datasets by a shared column (
Channel) - 🔍 Filter rows based on performance metrics (
Clicks,Spend) - 🔀 Branch logic into
"Great"vs."Poor"outcomes - 📊 Summarize results by team leader
- 🤖 Use an OpenAI-powered agent to generate a written analysis highlighting the best and worst performers
Perfect for marketers, analysts, or anyone learning how to clean, transform, and interpret data inside n8n.
Includes:
- 📁 Sample Google Sheet to copy
- 🛠 Setup instructions for Google Sheets & OpenAI
- ✨ AI summary powered by
GPT-4o-mini
👋 Questions or Feedback?
Feel free to reach out — I’m happy to help!
Robert Breen
Founder, Ynteractive
🌐 ynteractive.com
📧 robert@ynteractive.com
📺 YouTube: YnteractiveTraining
🔗 LinkedIn: linkedin.com/in/robertbreen
🔗 Nodes Used
Google Sheets, Filter, AI Agent, OpenAI Chat Model, Structured Output Parser, Summarize
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File