Send vendor follow-up emails for overdue POs with Google Sheets and Gmail

Chasing vendors for overdue Purchase Orders (POs) is a manual, repetitive task that eats up hours of procurement time. This workflow automates that entire process—intelligently.

It doesn't just send emails; it batches multiple overdue orders into a single message per vendor and includes a 7-day "anti-spam" cooldown to ensure you aren't nagging your suppliers every single day.

🎯 The Problem Manually checking spreadsheets for overdue dates is slow.

Sending individual emails for every single PO is annoying for vendors.

It’s hard to track when you last asked for an update.

🚀 The Solution This workflow:

Syncs your PO Log with your Vendor Contact database.

Filters for orders that are past due, incomplete, and haven't been followed up on in the last week.