Communication
Schedule MySQL queries and send results via Outlook
6 nodes
109
94
Scheduled trigger
Workflow Description
An automation that executes database queries on a defined schedule, evaluates the results against conditions, and sends targeted email notifications through Outlook. Eliminates manual reporting and ensures stakeholders receive timely data updates without intervention.
How it works
- 1.Trigger automation at scheduled intervals using the built-in scheduler
- 2.Connect to MySQL and execute the configured query
- 3.Evaluate query results using conditional logic to determine next actions
- 4.Format and send results via Outlook email to specified recipients
Use cases
- Send daily sales reports extracted from MySQL to management team
- Trigger alerts when database metrics exceed predefined thresholds
- Distribute weekly lists of new customers to the sales department
Requirements
- Valid MySQL connection credentials and database access
- Active Outlook account with email sending permissions
- Predefined query logic and recipient email addresses
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
MySQL
Outlook
Details
Trigger
Scheduled trigger
Nodes
6
Apps
2
Views
109
Downloads
94
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (6)
MySQL
My Sql
Schedule Trigger
Schedule Trigger
Switch
Switch
Microsoft Outlook6
Microsoft Outlook
Microsoft Outlook1
Microsoft Outlook
Microsoft Outlook7
Microsoft Outlook