Beginner Data Analysis: Merge, Filter & Summarize in Google Sheets with GPT-4o

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
📧 [email protected]
📺 YouTube: YnteractiveTraining
🔗 LinkedIn: linkedin.com/in/robertbreen