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 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.
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.