Tools: day 3 : No-code invoice follow-up automation: Make.com + Google Sheets + Gmail

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. Templates let you quickly answer FAQs or store snippets for re-use. Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink. Hide child comments as well For further actions, you may consider blocking this person and/or reporting abuse