Automated Weekly Google Analytics Performance Report
detail.loadingPreview
Automatically generate and deliver insightful weekly Google Analytics reports. This workflow fetches key GA4 metrics, compares current performance with the previous year, and uses AI to summarize data into concise, actionable reports for both email (HTML) and Telegram (plain text).
About This Workflow
Streamline your digital analytics reporting with this automated n8n workflow. Scheduled to run every Monday at 7 AM, it meticulously collects vital Google Analytics 4 data, including page views, sessions, e-commerce purchases, and revenue for the past seven days. Crucially, it also retrieves data for the exact same period from the previous year, enabling robust year-over-year comparisons. The workflow then intelligently processes these metrics, delivering a detailed HTML report directly to your email inbox. Simultaneously, an integrated AI (GPT-4o-mini) transforms the data into a clear, concise plain-text summary, specifically formatted for easy consumption, and dispatches it to your Telegram chat, ensuring critical insights are always at your fingertips.
Key Features
- Automated Weekly Reporting: Schedules and sends detailed Google Analytics reports every Monday at 7 AM.
- Year-over-Year Comparison: Automatically fetches and compares current week's performance against the same period in the previous year for deeper insights.
- Comprehensive GA4 Metrics: Tracks essential data including page views, sessions, users, session duration, e-commerce purchases, and revenue.
- AI-Powered Summarization: Leverages OpenAI (GPT-4o-mini) to transform raw data and calculations into clear, human-readable summaries.
- Multi-Channel Delivery: Distributes reports simultaneously via email (HTML format) and Telegram (AI-processed plain text) for convenient access wherever you are.
How To Use
- Schedule Trigger: Define the exact day and time you wish to receive your weekly report (default is Monday at 7 AM).
- Google Analytics Nodes: Connect your Google Analytics 4 account to both "Google Analytics Letzte 7 Tage" and "Google Analytics: Past 7 days of the previous year" nodes. Select your specific GA4 Property ID.
- Summarize Data Nodes: Ensure the
fieldsToSummarizein "Summarize Data" and "Summarize Data1" correctly aggregate the desired metrics from your GA4 data. - Calculator Node: This node is pre-configured to handle calculations between the current and previous year's summarized data, enabling performance comparisons.
- Processing for Telegram (OpenAI Node): Connect your OpenAI API credentials. The pre-defined prompt will convert HTML output into a structured, plain-text summary suitable for messaging. Adjust the prompt for different formatting needs.
- Send Email Node: Provide your SMTP credentials, specify the
fromEmailandtoEmailaddresses, and customize thesubjectif desired. - Telegram Node: Enter your Telegram API credentials and the
chatIdfor the specific chat or user where you want the report delivered.
Apps Used
Workflow JSON
{
"id": "51e9fe11-970d-49e4-980f-b80e473bb001",
"name": "Automated Weekly Google Analytics Performance Report",
"nodes": 8,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 51e9fe11-970d...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.
AI-Powered Instagram Comment Automation
This n8n workflow intelligently automates responses to Instagram comments, leveraging advanced AI to engage with your audience. It filters out irrelevant content and personalizes replies, saving you time while boosting your social media presence.