Chasing unpaid invoices is the worst part of freelancing.
Here's a simple automation I built to handle it:
Invoice overdue 7 days → polite reminder
Invoice overdue 14 days → firm follow-up
Invoice overdue 21 days → final notice
How it works:
A Make.com scenario runs daily. It reads a Google Sheet filtered by Status = Pending, calculates days overdue, and routes each invoice through the right branch.
Each branch sends two emails — one to the client, one to you — then updates the Follow Up Level in the sheet so the same email never fires twice.
(Make.com's now returns milliseconds, not seconds — divide by 1000 first or you get results like "20,000 days overdue".)
Stack: Make.com free tier · Google Sheets · Gmail
Setup time: ~20 minutes
I packaged the full thing — blueprint, sheet template, setup guide — for anyone who wants to skip the build: https://alexkraft.gumroad.com/l/ktufg
Or just take the formula and build your own version.
Top comments (0)