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 ? It will become hidden in your post, but will still be visible via the comment's permalink. as well , this person and/or