Create & send GA4 report with insights via email
Needs changesWhat this workflow does
This AI workflow has 11 nodes and runs when someone submits an n8n form (“Google Analytics Reporting”). Along the way it connects OpenAI Chat Model and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Google Analytics Reporting”).
- Overall Metrics This Period (HTTP Request): calls an HTTP API (POST)
- Overall Metrics Previous Period (HTTP Request): calls an HTTP API (POST)
- Form Submits This Period (HTTP Request): calls an HTTP API (POST)
- Form Submits Previous Period (HTTP Request): calls an HTTP API (POST)
- Code: runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 2 tools (Think, Calculator)
- Send a message (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.8): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.8) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - AI Agent
@n8n/n8n-nodes-langchain.agent - HTTP Request
n8n-nodes-base.httpRequest - Think Tool
@n8n/n8n-nodes-langchain.toolThink - n8n Form Trigger
n8n-nodes-base.formTrigger - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code
From the author
Who’s it for Marketing, growth, and analytics teams who want a decision-ready GA4 summary—automatically calculated, clearly color-coded, and emailed as a polished HTML report. How it works / What it does - Get Client (Form Trigger) collects GA4 Property ID…