Automated Invoice Follow-Up Reminders

What It Does

This automation checks your invoices daily and sends polite follow-up emails to clients whose payments are overdue. It escalates the tone after each reminder — friendly at first, then firm — so you never have to chase money manually.

How It Works

1. Trigger: Runs every morning at 9 AM via a scheduled cron
2. Step 1: Pulls all unpaid invoices from your Google Sheet / Airtable
3. Step 2: Checks how many days overdue each invoice is
4. Step 3: Sends the appropriate email based on the overdue tier:
   • 3 days overdue: Gentle reminder ("Just a friendly nudge…")
   • 7 days overdue: Firm follow-up ("This invoice is now a week past due…")
   • 14 days overdue: Final notice ("Please settle this at your earliest…")
5. Step 4: Updates the invoice row with "Last Reminded" date and reminder count

Why It Matters

Chasing payments is uncomfortable and time-consuming. Most freelancers and small businesses lose thousands per year to late payments simply because they forget to follow up. This automation is polite, consistent, and never forgets.

Who Is This For?

• Freelancers and consultants who invoice clients manually
• Small businesses with no accounts receivable team
• Anyone who feels awkward sending payment reminders