This n8n workflow automates the process of monitoring project data from a MySQL database, classifying it based on specific cost center conditions, and sending automated email notifications for projects missing budgeted costs. It is triggered weekly, querying the database for open, external projects with zero-budget costs. Based on the cost center, it routes the data through a switch node to personalize email alerts. These alerts, sent via Microsoft Outlook, notify relevant teams about the number of projects with missing cost data, prompting timely updates. This workflow is useful for project management teams aiming to ensure budget accuracy across various project segments, facilitating proactive communication and improved financial oversight.
Automated Project Cost Monitoring & Notifications
Node Count | 6 – 10 Nodes |
---|---|
Nodes Used | microsoftOutlook, mySql, scheduleTrigger, switch |
Reviews
There are no reviews yet.