Weekly GA4 report with Gemini summary
Compares two weeks of GA4 data in an HTML email. This free n8n template sends a weekly Google Analytics 4 report by email. Every Monday at 8:00 AM it fetches 14 GA4 reports in parallel, covering overview metrics, top pages, sources, events, countries, devices and new versus returning users. It asks Google Gemini for a 3 to 5 bullet summary of the insights, then builds an HTML email with inline CSS, sent through a standard SMTP / Email node. It is for marketing teams, agency owners, founders and freelancers who report GA4 metrics weekly. After import, you add a GA4 OAuth2 credential, your property ID, a Gemini API key and SMTP access.
Steps
- Trigger: Triggers every Monday at 8:00 AM
Schedule Trigger. - Fetches 14 GA4 reports in parallelGoogle Analytics
Current week and previous week. - Merges all 14 responses
- Gemini writes a 3-5 bullet summaryGoogle Gemini
- Code node computes WoW changes and HTML
- Output: Sends the report via SMTP / emailEmail (SMTP)
Limits
- The Gemini model version is not named on the page.
What it does well
- Fetches 14 GA4 reports in one run.
- Gmail OAuth2 can replace SMTP, per the setup notes.
Before you import
The page says the email node can be swapped for Gmail OAuth2.
Similar templates
Weekly SEMrush and GA4 SEO report
Also for scheduling and ops, 7 steps.
Shopify orders to Sheets with AI tags
Also for scheduling and ops, 9 steps.
Slack standup digest with OpenAI
Also for scheduling and ops, 8 steps.
Send a recurring summary
Other templates that do this task.