AI-Powered Google Analytics Weekly Performance Reporter

Unlock Automated Weekly Insights with this AI Agent

This n8n AI Agent acts as your dedicated Google Analytics performance analyst, working tirelessly every week. It automatically connects to your Google Analytics (GA4) account, retrieves vital metrics for the past 7 days, and crucially, fetches data for the same period from the previous year for insightful year-over-year (YoY) comparisons.

The core intelligence of this agent lies in its ability to process this data using OpenAI's GPT-4o and GPT-4o-mini models. It doesn't just present raw numbers; it crafts a narrative summary, calculates percentage changes (leveraging an integrated calculator tool for accuracy), and formats the findings into a professional HTML email report. Additionally, it can generate a concise version for quick updates via Telegram.

This AI Agent empowers you to stay consistently informed about your website's performance without manual effort, enabling faster, data-driven decisions for your B2C e-commerce or B2B SaaS business.

Key Features & Benefits

• Scheduled Automation: Runs automatically every week (configurable schedule) to deliver timely reports.
• Comprehensive Data Retrieval: Fetches key Google Analytics metrics like page views, users, sessions, session duration, e-commerce purchases, and revenue.
• Year-over-Year Analysis: Automatically compares current week's performance with the same period last year, highlighting trends and growth.
• AI-Powered Summarization & Formatting: Utilizes OpenAI (GPT-4o for email, GPT-4o-mini for Telegram) to:
  • Generate human-readable summaries of key performance indicators.
  • Calculate and include percentage changes for YoY comparison.
  • Produce a well-structured HTML table for clear email reporting.
  • Create a brief, text-based summary ideal for Telegram notifications.
• Multi-Channel Delivery: Sends detailed reports via email and optional concise updates to Telegram.
• Time-Saving: Eliminates the manual, repetitive task of compiling weekly GA reports.
• Actionable Insights: Provides clear, summarized data to quickly understand performance and identify areas for attention.

• An n8n instance (Cloud or self-hosted).
• Google Analytics credentials with access to your GA4 property (OAuth2 setup in n8n).
• OpenAI API Key with access to GPT-4o and GPT-4o-mini models (or other suitable models).
• SMTP server credentials for sending email reports.
• (Optional) Telegram Bot API token and Chat ID for Telegram notifications.

1. Download the n8n workflow JSON file (ai-google-analytics-weekly-reporter-v1.json).
2. Import the workflow into your n8n instance.
3. Configure the 'Schedule Trigger' node to your desired weekly reporting day and time (e.g., Monday 7 AM).
4. In both 'Google Analytics Letzte 7 Tage' and 'Google Analytics: Past 7 days of the previous year' nodes:
   • Select or create your Google Analytics credential.
   • Set your GA4 Property ID.
5. In the 'Processing for email' (OpenAI) node:
   • Select or create your OpenAI credential and enter your API Key.
   • Ensure the modelId is set (e.g., gpt-4o).
   • Review and customize the prompt if needed, to adjust the summary style, table structure, or HTML formatting.
6. Configure the 'Send Email' node with your SMTP credentials, sender/recipient email addresses, and subject line.
7. (Optional) For Telegram notifications:
   • In the 'Processing for Telegram' (OpenAI) node, select/create your OpenAI credential and ensure the modelId is set (e.g., gpt-4o-mini). Customize the prompt for concise text output.
   • Configure the 'Telegram' node with your Telegram API token and the target Chat ID.
8. Review all node connections and ensure data is flowing as expected by running manual executions with sample data if necessary.
9. Activate the workflow.