Automated weekly project cost reports with MySQL and Outlook HTML emails
Automated Weekly Project Cost Reports with MySQL and Outlook HTML Emails 🧠 Use Case Need to keep your finance or operations team updated on missing project costs? This practical automated report workflow does the job without AI — and saves hours weekly. - Runs on a weekly schedule - Queries your MySQL database for projects missing cost data - Filters by budgetedprojectcost IS NULL - Generates a clean HTML email report - Sends it through Microsoft Outlook to relevant teams 🚀 How It Works 1. Sche
At a glance
Automated weekly project cost reports with MySQL and Outlook HTML emails is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Outlook. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Outlook
- Modules
- 6
- Price
- Free
- Version
- v1.0

About this workflow
Automated Weekly Project Cost Reports with MySQL and Outlook HTML Emails 🧠 Use Case Need to keep your finance or operations team updated on missing project costs? This practical automated report workflow does the job without AI — and saves hours weekly. - Runs on a weekly schedule - Queries your MySQL database for projects missing cost data - Filters by budgetedprojectcost IS NULL - Generates a clean HTML email report - Sends it through Microsoft Outlook to relevant teams 🚀 How It Works 1. Schedule Trigger – Runs every Monday at 8 AM 2. MySQL Node – Connects and runs SQL to fetch project data missing budgetedprojectcost 3. Switch Node – Routes logic based on costcenter (e.g., Retail, Service, Projects) 4. Outlook Nodes – Sends formatted HTML emails; each node handles a specific group 5. Dynamic Content – Inject values using mustache tags like {{ $json.projectname }} 🔧 Setup Instructions 1. MySQL Setup: - Ensure the MySQL node is connected using a valid credential set: - Hostname/IP - Port (default: 3306) - Database name - Username with SELECT permissions - Password - Query Example: 2. Outlook Configuration: - Connect your Microsoft Outlook node using OAuth2 credentials. - Rename each Outlook node clearly (e.g., Send Email - Retail, Send Email - Service). 3. Switch Node: - Modify cost center values as needed to match your organization (e.g., 'Retail', 'Service', 'Projects'). 4. HTML Email Formatting: - Customize the HTML message body using inline styles and mustache syntax. - Sample: 5. Recipients: - Replace amjid@amjidali.com with the actual email addresses of the concerned teams. 📘 Read More 👉 Why Simple Workflows Work 📺 Demo & Tutorial 🎥 Watch the video walkthrough: --- 👤 About the Creator Amjid Ali 🌐 amjidali.com 📘 n8n Book 🎓 Learn n8n > “Start simple, scale smart. Even basic workflows like this can save your team hours!” — Amjid Ali
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Reply to Outlook emails with OpenAI
Add new incoming emails to a Google Sheets spreadsheet as a new row
Automate purchase order form submissions from Outlook Excel attachments with AI
Automate new customer onboarding with HubSpot, Google Calendar, and AI-powered Gmail
Create Excel and PDF documents with Plumsail and send them in Outlook
Process & summarize PDFs from email & messaging apps with OpenAI GPT
Find Linkedin company page with Airtop
Automate vendor due diligence research with Gemini & Jina AI
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you