Excel Automation Engine: From Single Workflow to Scalable System

In this video, we build a Zapier-style automation workflow directly inside Excel using VBA.

Instead of paying for automation tools, you can create your own Excel automation system that triggers multiple workflows like:

• Send task reminder emails automatically
• Trigger invoice payment reminders
• Run client follow-up notifications
• Manage workflows directly from Excel

We extend the automation from Part 1 by adding an Automation Type column, allowing Excel to run multiple workflows from one system.

This approach turns Excel into a lightweight automation platform, similar to tools like Zapier or Make, but fully customizable with VBA and Python integration.

You’ll learn how to:

✔ Build a multi-workflow automation system in Excel
✔ Trigger different automation types from a single sheet
✔ Automatically send Gmail messages
✔ Create a scalable automation structure using VBA
✔ Log automation activity inside Excel

0:00 – Intro: From Single Workflow → Automation Engine
Hook: “Last time we built this… but it had one big limitation.”

0:32 – What We Built in Version 1 (Quick Recap)

Task table

Email reminders

Logging + dashboard

Limitation: only 1 workflow

1:20 – The Upgrade: Multi-Workflow Automation Engine

What’s new

Why this matters (scalability)

2:05 – New Table Structure Explained

Automation table overview

Columns breakdown (ID, type, email, due date, etc.)

3:20 – The Key Upgrade: Automation Type Column

Task vs Invoice vs Follow-up

How Excel decides which workflow to run

4:30 – Notification Logic & Trigger Conditions

Notify flag

Due date logic

Preventing unnecessary runs

5:40 – Running the Automation Engine (Live Demo)

Click button

What happens step-by-step

6:40 – Logging System (Full Audit Trail)

Log sheet structure

Why this is powerful for real businesses

7:30 – Dashboard Updates in Real Time

Processed items

Emails sent

Errors + overdue

8:10 – VBA Engine Breakdown (Core Logic)

Looping through rows

Extracting values

Decision logic

9:30 – Multi-Workflow Logic (Main Upgrade)

Conditional branching by type

Different email templates

10:40 – Python + Gmail Integration

Shell execution

Auto-generating email drafts

11:40 – Preventing Duplicate Notifications

Last notified timestamp logic

12:20 – Updating the Table Automatically

Disabling notify flag

Writing timestamps

13:00 – Visual Report (UserForm Output)

Final workflow summary popup

13:40 – What You’ve Built (Big Picture)

“Mini automation platform inside Excel”

14:20 – How to Expand This System

Add new workflows

Scale logic

Business use cases

15:00 – What’s Coming in Part 3 (Hook)

Fully automated runs

Smarter scheduling

15:30 – Free Template + CTA

Download link

Subscribe + next video

This is perfect for anyone wanting to automate business workflows with Excel, VBA, Python, or AI tools.

Download the FREE Excel automation template used in this video to build your own system.
https://jacobautomation.gumroad.com/l/Vault

Download the Operational Efficiency Audit to identify workflow inefficiencies and automation potential:
👉www.jacobautomation.gumroad.com/l/audit

📁 Free Download Included
Get all my tutorial files in one place:
https://jacobautomation.gumroad.com/l/Vault

🛠️ Need a Custom Automation?
Submit a request here:
https://www.jacobautomation.com

🎁 Download My FREE Automation Toolkit
Streamline your work with templates & time-savers:
https://jacobautomation.gumroad.com/l/automationtoolkit

📲 Follow for Daily Content
Tips & tutorials on Excel VBA, SQL, Python & AI:

🔗 https://www.instagram.com/jacob.automation/

🔗 TikTok: https://www.tiktok.com/@jacob.automation

🛍️ Etsy Store: https://www.etsy.com/dk-en/shop/ExcelVbaAutomation
In this video, we take our Zapier-style system to the next level by upgrading it into a multi-workflow automation engine, demonstrating advanced excel automation. Learn how this system can scan records, update dashboards with status reports, and integrate Python for seamless email automation. This is a great example of workflow optimization for any business seeking better office automation.

Видео Excel Automation Engine: From Single Workflow to Scalable System канала Jacob Automation