Overdue Invoice Reminders (Google Sheets)
Every morning, reads your invoice sheet, picks the unpaid invoices past their due date, and sends each customer a polite WhatsApp reminder and email. Invoices overdue longer than your escalation limit go to the finance manager.
Steps in this flow
- Every workday 9:00
- Google Sheets: read unpaid invoices
- For each unpaid invoice
- Past due date?
- WhatsApp reminder to customer
- Email reminder to customer
- Overdue more than 14 days?
- Escalate to finance manager