Weekly Analytics Report
$24 one-time
Weekly Analytics Report
Pulls data from Google Analytics, Search Console, and social platforms every Monday, generates an AI-written performance summary, and delivers it to your inbox or Slack.
⚡
30 min
Setup Time
⏳
3+ hrs/mo
Time Saved
💰
$24
One-Time Price
Weekly Analytics Report
Every Monday morning this n8n workflow pulls data from Google Analytics, Search Console, and your social platforms, compiles the key metrics, generates an AI-written narrative explaining trends and anomalies, and delivers a clean formatted report to your inbox or Slack. Agency owners use this to generate professional weekly reports for 10–20 clients with zero manual data pulling, saving 20–40 hours per month and delivering a service clients happily pay $200–$500/month for.
What It Does
6am weekly trigger
GA4 + GSC + social
WoW + MoM change
Trends explained
Email + Slack
Tools Required
| Tool | Purpose | Free/Paid | Est. Cost |
|---|---|---|---|
| n8n | Workflow engine | Free (self-host) | $0–$20/mo |
| Google Analytics 4 API | Traffic + conversion data | Free | $0 |
| Search Console API | SEO clicks + impressions | Free | $0 |
| OpenAI GPT-4 | Narrative + insights | Paid | ~$2–$5/mo |
Real Results
| Tier | Clients Served | Hours Saved | Monthly Revenue |
|---|---|---|---|
| Beginner | 3 | 6 hrs | $600–$1,200 |
| Growth | 10 | 20 hrs | $2,000–$4,000 |
| Scale | 25+ | 50 hrs | $5,000–$10,000 |
Step-by-Step Setup
In Google Cloud Console, enable the Analytics Data API, Search Console API, and create OAuth 2.0 credentials. Add the credentials to n8n's Google credentials manager.
Set up GA4 API nodes to pull: sessions, users, conversions, top pages, and traffic sources. Set the date range to "last 7 days vs previous 7 days" to enable week-over-week comparison.
Add a JavaScript function node to calculate percentage changes for each metric: traffic, clicks, impressions, and average position. Flag any changes greater than ±10% as notable.
Pass the metrics JSON to GPT-4 with the included prompt. It writes a 3-paragraph executive summary: what happened this week, what's driving the changes, and one recommended action.
Use the included HTML email template to format the report with a data table and the AI narrative. Send via Gmail on Monday at 7am. Add a Slack notification for quick mobile viewing.
Who Is This For
Ready to Build More Automations?
Browse every tool, prompt, and income idea we've tested and published.
Frequently Asked Questions
Which plan do I need on n8n?
This workflow is designed to work with n8n's free or starter plan wherever possible. Any paid features required are clearly noted in the setup guide.
How long does setup take?
Most customers are up and running in 30 min. The step-by-step guide walks you through every connection and configuration.
Do I need coding or technical experience?
No coding required at all. If you can drag and drop, you can set this up. The guide includes screenshots for every step.
What exactly do I get after purchase?
You'll get immediate access to the importable workflow file, a full PDF setup guide, a configuration checklist, and lifetime access including any future updates to the template.
Is there a money-back guarantee?
Yes. If you're not satisfied within 30 days, email us and we'll refund you in full — no questions asked.
Can I use this for multiple clients or projects?
The license covers use for your own business or a single client project. Contact us if you need a multi-seat or agency license.