AI marketing report (Google Analytics & Ads, Meta Ads), sent via email/Telegram

AI-Powered Weekly Marketing Performance Report This workflow automates the generation of a comprehensive weekly marketing report. It aggregates performance data from multiple Google Analytics properties, Google Ads, and Meta Ads accounts. The system automatically compares the last seven days of data against the same period from the previous year, then uses AI to analyze, summarize, and format the findings into a polished HTML email and a concise Telegram message. Technologies Used - Data Sources: Google Analytics, Google Ads, Meta (Facebook) Ads - Automation Platform: n8n - Artificial Intelligence: OpenAI (GPT-4o and GPT-4o-mini) - Communication: Email (SMTP), Telegram How AI is Integrated This workflow uses AI in several key areas to transform raw data into actionable insights: 1. AI Agent Orchestration: A central AI Agent (Weekly Report Agent) acts as the project manager. It understands its primary goal—to create a consolidated report—and intelligently calls upon various "tools" (sub-workflows) to fetch the specific data it needs from Google Analytics, Google Ads, and Meta Ads. 2. Data Analysis & Summarization: For each data source (e.g., Google Ads), a dedicated OpenAI node receives the current week's data and the data from the previous year. It is prompted to analyze these numbers, calculate the percentage change for each key metric (like ROAS, CTR, Clicks), and generate a brief, human-readable summary of the performance trends. 3. Content Generation & Formatting: The AI is responsible for structuring the analyzed data into clean, well-formatted HTML tables. It combines the individual reports from each data source into a single, cohesive HTML email. 4. Content Adaptation: After creating the detailed email report, another AI node is used to adapt and condense the information into a short, scannable text format suitable for a Telegram message, providing key highlights on the go. Extensive Node-by-Node Analysis This workflow is masterfully structured into a main workflow that coordinates several data-fetching sub-workflows.