# Weekly email alerts for projects missing budgeted cost sent to cost centers
This automation ensures ongoing accuracy in project budget tracking. Running weekly, it queries a MySQL database for active projects lacking budgeted cost, groups them by cost center, and sends personalized HTML email notifications via Microsoft Outlook. The solution reduces manual oversight and improves data reliability in enterprise systems.
## Who it´s for
- Financial controllers responsible for project budgeting
- Project managers monitoring the status of active external projects
- Accounting and reporting teams in corporate organizations
## What the automation does
- Triggered on a weekly schedule (cron) at a predefined time
- Queries MySQL for active projects missing budgeted cost
- Groups results by cost center
- Generates personalized HTML emails with summary details
- Sends alerts via Microsoft Outlook API to designated recipients
- Supports conditional routing for different cost centers
## What´s included
- Ready-to-use n8n workflow
- Trigger and conditional logic structure
- Integrations with MySQL and Microsoft Outlook API
- Basic setup and adaptation guide
## Requirements for setup
- Access to an n8n instance (self-hosted or cloud)
- MySQL database account with read permissions
- Connected Microsoft Outlook account with email sending rights
## Benefits and outcomes
- Reduces manual effort in budget monitoring
- Ensures consistent follow-up without human intervention
- Improves data accuracy in ERP/accounting systems
- Clearly assigns responsibility by cost center
- Minimizes risks of oversight during manual checks
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet