AutomationMart
Home/Browse/Automated weekly project cost reports with MySQL and Outlook HTML emails
n8n

Automated weekly project cost reports with MySQL and Outlook HTML emails

n8nn8n6 modulesv1.0
Outlook

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
Automated weekly project cost reports with MySQL and Outlook HTML emails workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Who is this template for? This template is for any Microsoft Outlook user who wants a trained AI agent to reason and reply on their behalf. Teach your agent tone and writing style to replicate your own, or develop a persona for a shared inbox. Requirements - Outlook with authentication credentials - OpenAI account with authentication credentials - A few sample email replies of various lengths and topics How it works: 1. Connect your Outlook account. 2. Select (filter) which email sender(s) your

Free

Add new incoming emails to a Google Sheets spreadsheet as a new row

This n8n workflow automates the process of capturing and storing incoming email details in a structured spreadsheet format, such as Google Sheets or Excel. Whenever a new email is received, the workflow extracts key details—including the sender’s email, subject, email body, and optional attachments—and logs them as a new row in the spreadsheet. You can customise this workflow to extract additional details, filter emails based on specific criteria, or send notifications when new entries are added

Free

Automate purchase order form submissions from Outlook Excel attachments with AI

This n8n template imports purchase order submissions from Outlook and converts attached purchase order forms in XLSX format into structured output. Data entry jobs with user-submitted XLSX forms are time consuming, incredibly mundane but necessary tasks which in likelihood are inherited and critical to business operation. While we could dream of system overhauls and modernisation, the fact is that change is hard. There is another way however - using n8n and AI! N8N offers an end-to-end solution

Free

Automate new customer onboarding with HubSpot, Google Calendar, and AI-powered Gmail

This n8n workflow streamlines the onboarding process for new customers by automating personalized email communication, calendar scheduling, and contact assignment in HubSpot. It is perfect for businesses looking to ensure a smooth and personalized onboarding experience for new clients. --- 🧑‍💼 Who is this for? - Customer success teams who need to onboard new clients efficiently. - Sales teams who want to ensure smooth transitions from prospect to customer. - Small businesses that want to automat

Free

Create Excel and PDF documents with Plumsail and send them in Outlook

Run this scenario manually to create Excel and PDF files with Plumsail Documents. It uses a template stored in OneDrive and sends an email with the documents through Outlook.

Free

Process & summarize PDFs from email & messaging apps with OpenAI GPT

Process PDFs from Gmail, Outlook, Telegram and WhatsApp with OpenAI Transform PDF documents into actionable insights automatically across multiple platforms. This workflow monitors emails and messaging platforms for PDF attachments, extracts content, and delivers AI-powered summaries. Who's it for Business professionals, teams, and organizations needing automated PDF analysis from emails and messaging platforms. Perfect for processing contracts, reports, invoices, and documents requiring quick r

Free

Find Linkedin company page with Airtop

Automating LinkedIn Company Page Discovery Use Case Finding the official LinkedIn page of a company is crucial for tasks like outreach, research, or enrichment. This automation streamlines the process by intelligently searching the company’s website and LinkedIn to locate the correct profile. What This Automation Does This automation identifies a company's LinkedIn page using the following input parameters: - Company domain: The official website domain of the company (e.g., company.com). - Airto

Free

Automate vendor due diligence research with Gemini & Jina AI

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 👥 Who is this for? This workflow is designed for a variety of professionals who manage vendor relationships and data security. It is especially beneficial for: - 🛡️ GRC (Governance, Risk, and Compliance) Professionals: Streamline your risk assessment processes - 🔒 Information Security Teams: Quickly evaluate the security posture of third-party vendors - 📋 Procurement Departments: Enhance due dili

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free