Weekly AI Marketing Report (GA4, Ads, Meta) for Email & Telegram

Get a weekly AI-generated performance report from GA4, Google Ads, and Meta Ads—automatically sent to Email and Telegram

This n8n workflow compiles a 7-day marketing performance report using Google Analytics (GA4), Google Ads, and Meta Ads, then uses OpenAI to generate an HTML email report plus an optional Telegram-ready text summary with same-period last-year comparisons.

What this workflow does

• Runs weekly: scheduled every Monday at 07:00.
• Collects reporting inputs in parallel: uses an AI agent to call sub-workflows that return weekly GA4 summaries for five domains, plus outputs for Google Ads and Meta Ads.
• GA4 7-day vs last year: pulls GA4 metrics for the last 7 days and the equivalent period from the previous year, then summarizes totals/averages and generates a short narrative with a comparison table via OpenAI.
• Google Ads KPIs & comparison: fetches campaign metrics for the last 7 days and the same period last year via the Google Ads API, aggregates KPIs (e.g., CTR, CPM, cost per conversion, ROAS), and generates a comparison table with OpenAI.
• Meta Ads KPIs & comparison: pulls Meta Ads insights for the last 7 days and equivalent last-year period via the Facebook Graph API, formats KPIs, and generates a narrative and comparison table using OpenAI.
• Publishes results: compiles domain + Google Ads + Meta Ads into a single HTML email and sends it, then converts the report into plain-text for Telegram.

Use cases

• Weekly growth reporting for SaaS teams tracking GA4, Google Ads, and Meta performance.
• Automation engineers building a consistent “performance digest” across multiple domains.
• Marketing ops teams who want same-period last-year comparisons without manual spreadsheets.

Technical details

• Scheduling: n8n workflow runs every Monday at 07:00.
• AI processing: OpenAI for narrative + comparison table generation.
• Integrations: GA4 summaries via sub-workflows, Google Ads API, Facebook Graph API.
• Delivery nodes: Email Send + Telegram.
• Workflow components: set, code, telegram, email send, summarize, sticky note.