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. 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: sql SELECT projectname, costcenter FROM tabProject WHERE status = 'Open' AND projecttype = 'External' AND budgetedprojectcost IS NULL;