mysql monthly reporting

Monthly AI-Powered Financial Reporting for Business Units Automation Overview This workflow automates the entire process of generating and distributing monthly financial performance reports for different business units (Cost Centers). On the 5th of every month, it automatically fetches detailed financial and operational data from a MySQL database, including budget vs. actuals, project work-in-progress (WIP), departmental P&L, and employee statistics. For each business unit, it consolidates this data and uses a Google Gemini-powered AI agent to perform a deep analysis. The AI acts as an expert financial analyst, calculating key metrics, generating an executive summary, and providing actionable insights. The final output is a professionally formatted HTML report, which is then automatically emailed to stakeholders via Microsoft Outlook. This eliminates hours of manual data collation, calculation, and report writing, delivering consistent, insightful, and timely business intelligence. Technologies Used - n8n: The automation platform coordinating the entire workflow. - MySQL: The source database for all financial, project, and employee data (likely from an ERP system). - Google Gemini (2.5 Pro): The Large Language Model (LLM) used for advanced data analysis, insight generation, and report writing. - Microsoft Outlook: The email client used to distribute the final reports. AI Integration Analysis The AI integration is the centerpiece of this workflow, transforming it from a simple data pipeline into a sophisticated analysis and reporting engine. - AI Model: The workflow employs the Business Performance AI Agent (Analyst) node, which is powered by Google's advanced Gemini 2.5 Pro model. - Function: The AI is not just summarizing data; it's tasked with acting as an expert Financial Analyst. It receives a consolidated set of raw financial data tables (YTD/PM Summary, Vertical P&L, WIP, and Employee stats) formatted in HTML. - Process & Capabilities: 1. Data Synthesis and Calculation: Based on a detailed prompt, the AI restructures the raw financial data into a standard Profit & Loss statement.