Auto-Generate Monthly Financial Reports with n8n + Gemini AI
SQL data → AI analysis → HTML report → Outlook email, automatically delivered monthly per Cost Center
Read the case’s method and prerequisites
Prerequisites: n8n instance (self-hosted or Cloud), MySQL/PostgreSQL/ERPNext database, Microsoft Outlook or Gmail account, Google Gemini API Key. Understanding of your data schema is required to adapt SQL queries. Template defaults to ERPNext schema (tabBudget Group Detail, tabGL Entry, tabProject, tabEmployee). The Filter node hardcodes 'AI DEPARTMENT' for testing; update or remove for production.
n8n · mysql · outlook
Associated by case tags. Verify costs, permissions and actual results in the case.