Back to Templates

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

Created by

Created by: Robert Breen || rbreen

Robert Breen

Last update

Last update a month ago

Share


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