Automated Weekly Project Cost Reports with MySQL and Outlook HTML Emails
n8n template #3453Summary
Use templateAutomated 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 Schedule Trigger – Runs every Monday at 8 AM MySQL Node – Connects and runs SQL to fetch project data missing budgetedprojectcost Switch Node – Routes logic based on costcenter (e.g., Retail, Service, Projects) Outlo
Hand off to your agent
Prompt
Help me set up the n8n workflow "Automated Weekly Project Cost Reports with MySQL and Outlook HTML Emails" (https://n8n.io/workflows/3453). It uses: MySQL, Microsoft Outlook. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Similar workflows
NameViews
- Generate Monthly Financial Reports with Gemini AI, SQL, and Outlook14K
- Create a Branded AI-Powered Website Chatbot88K
- Auto Categorise Outlook Emails with AI39K
- Generate SQL queries from schema only - AI-powered38K
- Phishing Analysis - URLScan.io and VirusTotal27K
- Import CSV into MySQL13K
- Build an AI-Powered Tech Radar Advisor with SQL DB, RAG, and Routing Agents12K
- Two way sync Pipedrive and MySQL11K