MySQL to Outlook Project Cost Notification
detail.loadingPreview
Notifies relevant teams via Outlook when active projects have missing budgeted costs.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow connects to a MySQL database to identify active projects that are missing budgeted costs. Based on the cost center associated with these projects, it sends a tailored email notification to the respective team using Microsoft Outlook. This helps ensure project data accuracy and prompt updates.
Key Features
- Connects to MySQL to query project data.
- Filters projects based on status, type, and active status, and missing budgeted cost.
- Groups results by company and cost center to count projects.
- Uses a Switch node to route notifications based on the cost center.
- Sends personalized HTML emails via Microsoft Outlook.
How To Use
- Import the workflow into your n8n instance.
- Configure the 'MySQL' node with your database credentials and the provided SQL query.
- In the 'Switch' node, update the
leftValueandrightValuein the conditions to match your actual cost center names. - Configure the 'Microsoft Outlook' nodes with your Outlook credentials. Ensure the
toRecipientsare set correctly for each branch of the switch. - Adjust the email content (
subject,bodyContent) in each Outlook node as needed. - Set the 'Schedule Trigger' to your desired execution frequency.
Apps Used
Workflow JSON
{
"id": "d6ff487f-1174-4094-828c-05633ade891f",
"name": "MySQL to Outlook Project Cost Notification",
"nodes": 0,
"category": "Microsoft Outlook",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: d6ff487f-1174...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Verification Info
Related Integrations
- Microsoft Outlook + Schedule Trigger(27 workflows)
- Gmail Trigger + Microsoft Outlook Trigger(11 workflows)
- Jira + Microsoft Outlook Trigger(11 workflows)
- Microsoft Outlook + Whats App(9 workflows)
- ERP Next + Microsoft Outlook(7 workflows)
- Execute Workflow Trigger + Microsoft Outlook(6 workflows)
- Airtable + Microsoft Outlook(6 workflows)
- Microsoft Outlook + My SQL(6 workflows)
- Microsoft Outlook + Remove Duplicates(6 workflows)
- Microsoft Outlook + Telegram(6 workflows)
Related Workflows
Discover more workflows you might like
Outlook Auto-Reply to Draft
Automatically replies to incoming emails and saves the reply as a draft.
Google Calendar to Outlook Sync
Synchronizes events between Google Calendar and Microsoft Outlook.
Send Files to Kindle via Telegram Bot
Automatically forward files received via a Telegram bot to your Kindle device via email.
Microsoft Outlook: Create Draft, Add Attachment, Send
Automates creating an email draft, attaching a file, and sending it using the Microsoft Outlook node.
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.
Automate Shipment Tracking with Telegram and n8n
Streamline your logistics operations by automating shipment tracking with Telegram and n8n. This workflow allows drivers to easily share updates, and ensures timely notifications to your team.