Weekly Scheduled Google Analytics Summary

Website owners or marketers tracking performance for sites like ep-reisen.de using Google Analytics. Fetches weekly GA4 data for the last 7 days and compares it to the same period last year. AI generates a formatted summary and table for email, and a text version for Telegram. Connect Google Analytics, OpenAI, SMTP, and Telegram credentials in n8n. Set the schedule trigger for Mondays at 7 AM. Adjust property ID and metrics as needed. n8n instance, GA4 property access, OpenAI API key, email SMTP server, Telegram bot token. Change metrics, date ranges, or AI prompts. Add more channels like Slack. Modify languages or formats in AI nodes. Key Technologies: n8n,Google Analytics API (GA4),OpenAI (GPT-4o, GPT-4o-mini),SMTP Email,Telegram API,JavaScript Code Node Automation Value: Saves hours weekly on manual GA data pulls and report creation. Provides consistent, comparable insights with year-over-year metrics. AI handles formatting and summaries, reducing errors and effort. Delivers reports automatically to email and Telegram for quick reviews. Best Practices: Use schedule triggers for recurring tasks to ensure consistency. Map and standardize data early to simplify downstream processing. Use AI for dynamic formatting and analysis to handle variable data. Include comparison periods for meaningful insights. Modularize with separate nodes for current/previous data to ease debugging. Secure credentials properly for APIs like GA and OpenAI. Test date calculations thoroughly for edge cases like year ends.