Beginner data analysis: merge, filter & summarize in Google Sheets with GPT-4o

by Robert Breen ✓ · 2,145 views · created 2025-07-31 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 15 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and OpenAI Chat Model.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Sample Marketing Data (Google Sheets): uses Google Sheets
2. Google Sheets: uses Google Sheets
3. Merge: merges the data from its input branches
4. Filter: keeps only the items that match a condition
5. Check if spend over $ (If): checks a condition and branches into true / false
6. Count bad days (Summarize): summarizes / groups the items
7. Count good days (Summarize): summarizes / groups the items
8. Organize fields into table (Edit Fields (Set)): sets 3 fields: Outcome, # of Days, Leader
9. Organize second data into table (Edit Fields (Set)): sets 3 fields: Outcome, # of Days, Leader
10. Append datasources together (Merge): merges the data from its input branches

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsOpenAI Chat Model

Before you upgrade to n8n 3.0

Nodes used (11)

• Google Sheetsn8n-nodes-base.googleSheets
• Filtern8n-nodes-base.filter
• Coden8n-nodes-base.code
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Manual Triggern8n-nodes-base.manualTrigger
• Mergen8n-nodes-base.merge
• Ifn8n-nodes-base.if
• Summarizen8n-nodes-base.summarize
• Edit Fields (Set)n8n-nodes-base.set
• AI Agent@n8n/n8n-nodes-langchain.agent

From the author

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…

View the original on n8n.io → Check your own copy