Recipe 05Track A: Start AI-native
How do I get paid on time without chasing invoices?
Keep every invoice in one sheet, and let a weekly automation find the overdue ones and draft polite reminders into your Gmail drafts. You review and hit send. No invoice sits unpaid because you forgot to ask.
- For
- service businesses, freelancers and agencies
- Setup
- about 2 hours
- Cost
- $0 self-hosted
Ingredients
- Google Sheets: client, email, invoice number, amount (USD), due date, status
- n8n, self-hosted Community Edition (free, unlimited workflows and executions; you pay for the server)
- Claude or ChatGPT API, or n8n’s built-in AI node
- Gmail
Zapier’s free plan won’t work here. This needs more than two steps.
Steps
0 of 6 done- Move every open invoice into the sheet. One row each.
- In n8n, set a schedule trigger for Monday 9am in your time zone.
- Read the sheet. Filter rows where status is not “paid” and the due date has passed.
- For each one, have AI write a reminder using the prompt below. The tone gets firmer with days overdue.
- Save each reminder as a Gmail draft, not a sent email.
- Monday morning: review the drafts, send, and mark paid invoices in the sheet.
Copy this prompt
Write a payment reminder email.
Client: {{name}}. Invoice {{number}} for ${{amount}}, due {{due_date}}, now {{days_overdue}} days overdue.
Tone: 1–7 days = friendly nudge. 8–30 days = clear and direct. 30+ days = firm, mention next steps.
Under 90 words. Include the invoice number and amount. No guilt-tripping.Human check
reminders are drafts. Money emails never send on their own.
Done when
no invoice goes more than seven days overdue without a reminder.
Free-tier details checked 29 Oct 2026