Send weekly blended ad performance reports with Meta, Google Ads, GA4 and OpenAI
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Summarize What Moved (AI Agent) (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack - Error Trigger
n8n-nodes-base.errorTrigger
What it does
Quick overview This workflow runs every Monday at 8am to pull the last 7 days of performance from Meta Ads, Google Ads, and GA4, calculate blended KPIs, generate an OpenAI-powered narrative summary, email an HTML report via Gmail, and post an internal update (and errors) to Slack. How it works 1. Runs every Monday at 8am on a scheduled trigger. 2. Fetches the last 7 days of spend and engagement metrics from the Meta Ads Insights API, campaign cost and conversion metrics from the Google Ads API, and conversions and revenue by channel from the GA4 Reporting API. 3. Combines the three datasets and calculates blended KPIs including total spend, total conversions, total revenue, and ROAS. 4. Sends the computed metrics to an OpenAI chat model to generate a 3–4 sentence client-friendly performance summary with one risk and one recommendation. 5. Builds a simple HTML report containing the KPIs and AI summary. 6. Emails the HTML report to the client via Gmail and posts a brief confirmation with spend and ROAS to a Slack channel. 7. If the workflow fails, posts an error alert message to an ops Slack channel. Setup 1. Configure authentication for the HTTP requests to Meta Ads (access token), Google Ads (OAuth/access token), and GA4 (OAuth/access token), and replace YOURADACCOUNT, YOURCUSTOMERID, and YOURGA4PROPERTYID in the request URLs. 2. Add an OpenAI credential for the chat model used to write the weekly summary. 3. Connect your Gmail account and replace the recipient address in the email step. 4. Connect Slack, set the channel IDs for the weekly update and ops alerts, and adjust the schedule time if you don’t want Monday 8am UTC.