Automated Weekly Google Analytics Insights with AI Analysis

This n8n workflow automates the process of collecting, analyzing, and sharing Google Analytics data weekly. It begins with a scheduled trigger that initiates the workflow every seven days. The workflow fetches key website metrics such as event count, user engagement, active users, and sessions from Google Analytics. The data is then aggregated into a normalized JSON format through the Aggregate node. An AI agent, powered by Google Gemini and integrated with Langchain, analyzes this data, providing insightful summaries comparable to a seasoned data analyst. It considers historical data stored in a memory buffer, ensuring context-aware insights. The analysis results include sentiment classification, identifying positive or negative trends. These insights are then formatted into a concise report and sent via Telegram to a designated group for immediate review. Simultaneously, stakeholders receive an email with the detailed report for further action. The workflow also features sticky notes for documentation, noting the purpose of each step, and uses memory buffering for trend detection over time. This automation is ideal for marketing, operations, or analytics teams wanting to keep real-time tabs on website performance without manual effort, enhancing decision-making and responsiveness.