Issue · 2026-07-11 · Email subscribers
Friendly payment reminders — click-by-click Google Sheets, Zapier, and Gmail guide
You finished the job. You sent the invoice. Then silence — and you're the one who feels awkward dialing to ask for money you already earned.
Invoice chase automation watches a Google Sheet. Seven days after you mark an invoice sent, Zapier re-checks that status is still unpaid, then sends a polite reminder from your Gmail. Still open at day 14? A firmer second nudge. After day 21, the row is flagged overdue so you know who needs a call — without living in your inbox.
The outcome: typically recover overdue invoices with timed email nudges on schedule (in our tests); teams that mark paid promptly usually see fewer phone chases within a few weeks — results vary by niche and payment terms.
Who this is for
- Service businesses tracking invoices in Google Sheets or PDF + email
- Owners who hate phone tag for money already earned
- Teams without QuickBooks/Xero reminder coverage on every invoice
Not for you if… every invoice already lives in QuickBooks, Xero, or Stripe Invoicing with built-in reminders you actually use.
What's on this page vs email
This page covers why and what to expect. The full playbook — tracker columns, Zapier delays, status re-check before send, both email templates, overdue flagging, privacy and cost notes — is free via email (Playbook #5 in Season 1).
Pairs well with: Quote follow-up so won quotes become delivered work that gets invoiced. Upstream: Job completion checklist for same-day wrap-up before billing.
Frequently asked questions
When should the first invoice payment reminder go out?
Day 7 after send typically gives clients time to pay on normal terms without feeling chased (in our tests). Add a day-14 firmer nudge only after five clean day-7 runs.
Will this email someone who already paid?
Not if you update status to paid or written_off before the delay fires. The playbook re-reads the Sheet and filters on unpaid status before Gmail sends.
What tools do I need?
Google Sheets (invoice tracker), Gmail, and Zapier. Free Zapier tier can work at low volume; delays still consume tasks.
Should I use QuickBooks or Xero instead?
Use their built-in reminders if every invoice lives there. Wire this playbook when invoices are Sheet- or PDF-based and you want nudges from your Gmail.
What happens after day 21 if still unpaid?
The playbook flags the row overdue and can alert your ops inbox. Phone, stop-work, deposit next time, or payment plan stays a human decision.
How long does setup take?
About 35 minutes for a first-time builder (closer to 20–25 if you already know Zapier), including the Sheet, day-7 Zap, and a shortened test.
Is client invoice data safe in Zapier?
Names, emails, amounts, and due dates pass through Sheets and Zapier to Gmail. Restrict Sheet access to billing staff and confirm your Workspace/Zapier terms (and a DPA where needed) before live client data.
How do I get the step-by-step setup?
Subscribe free — Playbook
Get the invoice chase playbook free
Tracker columns, day-7 and day-14 timing, status re-check before send, and email templates — Playbook