Send weekly GA4 WoW email reports with Gemini AI executive summary

Weekly Google Analytics 4 Report - Full WoW Tracking & Auto-Generated with Gemini AI Stop manually building weekly analytics reports. This workflow automatically fetches your GA4 data every Monday morning, generates an AI-written executive summary using Gemini, builds a premium formatted HTML email with deep Week-over-Week (WoW) comparisons for every metric, and delivers it straight to your stakeholders' inboxes — fully hands-free. 👤 Who is this for? Marketing teams and agency owners who report GA4 metrics weekly to clients Product managers and founders who want a Monday morning performance digest Freelancers managing analytics for multiple clients who want to automate reporting Anyone who spends 30–60 minutes every week manually pulling GA4 numbers and calculating WoW changes 🚩 What problem does this solve? Manual GA4 reporting is repetitive, error-prone, and time-consuming. This template eliminates that entirely — every Monday at 8:00 AM in your configured timezone, a fully formatted report lands in your inbox. With the new dual-node architecture, it automatically calculates accurate WoW trends for your overall metrics, specific pages, traffic sources, and more, all contextualized by a Gemini-generated executive summary. ⚙️ What this workflow does 1. ⏰ Triggers every Monday at 8:00 AM via the Schedule Trigger node 2. 📡 Fetches 14 GA4 reports in parallel - pulling both Current Week and Previous Week data simultaneously for speed: - Overview metrics - Top 5 Screens / Pages by views - Top 5 Traffic Sources / Referrals - Top 5 Events by count - Top 5 Countries by sessions - Device breakdown (mobile / desktop / tablet) - New vs Returning users 3. 🔀 Merges all 14 responses and passes the complete historical dataset forward 4. 🤖 Gemini writes a 3-5 bullet point summary analyzing the full WoW dataset to highlight performance trends, audience behaviour, and actionable recommendations 5. 🧮 Code node processes all data - aligns current vs. previous week data, calculates WoW % changes for every single category, handles new/dropped entries, and builds the full inline-CSS HTML email 6. 📧 Sends the report via standard SMTP / Email node to your configured recipients 📧 What the email report includes Header - dark luxury card with 4 KPI tiles (Users, Sessions, Bounce Rate, Avg Duration) and WoW arrows AI Executive Summary - 3-5 bullet point Gemini-generated insight (hidden automatically if Gemini fails) Overview Table - all 5 core metrics with This Week / Last Week / WoW % change pill badges Audience - New vs Returning users with visual progress bars and WoW changes Top Screens - ranked by views, including previous week values and WoW trend pills. (not set) and (empty) rows are preserved for transparency Traffic Sources - top referral channels with WoW changes; direct traffic auto-labelled as Direct / App Open Top Events - tracks interaction trends with WoW changes; system events (firstopen, osupdate, etc.) are filtered out automatically Geography - top 5 countries by sessions with WoW comparisons Devices - mobile / desktop / tablet with visual progress bars and WoW trend pills 🛠️ Setup Instructions Step 1 - Google Analytics 4 Credential 1. Go to n8n Credentials → Add new → search Google Analytics OAuth2 2. Sign in with the Google account that has access to your GA4 property 3. Assign this credential to all 14 GA4 nodes Step 2 - Set your GA4 Property ID 1. Open each of the 14 GA4 nodes 2. In the Property ID field, replace {YOURPROPERTYID} with your GA4 numeric property ID 3. Find your Property ID at: GA4 Admin → Property Settings → Property ID (looks like 123456789) Step 3 - Gemini API Credential 1. Get your free API key at aistudio.google.com 2. Go to n8n Credentials → Add new → search Google Gemini 3. Paste your API key and assign it to the Generate AI Summary node Step 4 - Email / SMTP Credential 1. Go to n8n Credentials → Add new → search SMTP (or swap the node for Gmail OAuth2 if preferred) 2. Enter your email host, port, and lo