Beginner Data Analysis: Merge, Filter & Summarize in Google Sheets with GPT-4o
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-4-mini` ### Questions or Feedback? Feel free to reach out - I'm happy to help! **Robert Breen** Founder, Ynteractive š§ [robert@ynteractive.com](mailto:robert@ynteractive.com) š [YouTube: YnteractiveTraining](https://www.youtube.com/@ynteractivetraining) š [LinkedIn: linkedin.com/in/robertbreen](https://www.linkedin.com/in/robertbreen)
- Platform
- n8n
- Category
- Data & Analytics
- Price
- $14.99
- Creator
- Robert Breen
- if
- set
- code
- merge
- filter
- summarize
- stickyNote
- googleSheets
- manualTrigger
- agent
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Data & Analytics workflows
- Generate AI viral videos with VEO 3 and upload to TikTok$14.99
- Generate a daily multi-asset market report with TwelveData, Groq and Google Sheets$14.99
- Build an OpenAI RAG system with document upload, semantic search and caching$24.99
- Automate Website Content Scraping and SEO Keyword Extraction with GPT-4o-mini and Airtable$14.99
- Process Contact Form Submissions with Validation and MongoDB Storage$14.99
- Add webhook data to a Google Sheet$2.99
More from Robert Breen
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works ā or build a custom solution from scratch.