Generate marketing campaign ROI reports with Google Sheets, GPT-4o and Email
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Data (Google Sheets): uses Google Sheets
- Sum Campaigns (Summarize): summarizes / groups the items
- Sum Channels (Summarize): summarizes / groups the items
- Combine (Aggregate): combines items into one
- Combine (Aggregate): combines items into one
- Merge: merges the data from its input branches
- Convert to Text (Code): runs custom JavaScript code
- Analyze Marketing Data (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Summarize
n8n-nodes-base.summarize - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
This n8n workflow pulls campaign data from Google Sheets, summarizes it using OpenAI, and sends a performance recap via Outlook email. --- ✅ Step 1: Connect Google Sheets 1. In n8n, go to Credentials → click New Credential 2. Select Google Sheets OAuth2 API…