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.

n8nRead on 2026-11-166 steps

Steps

  1. Trigger: Triggers every Monday at 8:00 AM
    Schedule Trigger.
  2. Fetches 14 GA4 reports in parallelGoogle Analytics
    Current week and previous week.
  3. Merges all 14 responses
  4. Gemini writes a 3-5 bullet summaryGoogle Gemini
  5. Code node computes WoW changes and HTML
  6. 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