# Send overdue invoice reminders and aging reports from Google Sheets with Gmail

> Quick Overview This workflow runs every weekday, reads open invoices from Google Sheets, and uses Gmail to send staged overdue payment reminders or escalation emails. It also sends a weekly receivables aging report to a finance inbox and logs each sent reminder stage back to the sheet. How it works 1. Runs every weekday at 9:00 on a schedule. 2. Reads all rows from the Invoices tab in Google Sheets using unformatted values for consistent date handling. 3. For each invoice that is not marked Paid or Cancelled, calculates days overdue and selects the next unsent reminder stage (for example day 0, 7, and 14) or triggers escalation once the escalation day is reached. 4. Sends the selected email via Gmail either to the customer (or to the finance inbox when test mode is enabled) or to the escalation contact for manual follow-up. 5. Updates the corresponding Google Sheets row with laststagesent and lastsentat so the same stage is not sent twice. 6. On the configured weekday, builds a receiva

- **Domain**: `n8n-workflow-20173.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20173
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20173.n8n.io
- Documentation: https://n8n.io/workflows/20173