Use Cases
- Automate notifications for missing project budget costs
- Streamline communication between project and finance teams
- Enhance project management oversight with timely alerts
How It Works
Triggers weekly to initiate the workflow Executes a MySQL query to retrieve projects with missing budgeted costs Uses a switch node to determine the cost center and route notifications accordingly Sends customized emails to relevant teams via Microsoft Outlook
Setup Steps
- 1Import the workflow template into your n8n instance
- 2Configure the MySQL node with your database credentials
- 3Set up the email recipients in the Microsoft Outlook nodes
- 4Adjust the schedule trigger as needed for your notification frequency
- 5Activate the workflow to start receiving notifications
Apps Used
MySQL
Microsoft Outlook
Categories
Target Roles
Tags
#email automation
#notifications
#process automation