Overdue invoice reminders in Gmail
GPT-4o-mini drafts overdue invoice emails and sets an escalation level. This n8n template runs every 24 hours and checks a Google Sheets invoice list for overdue payments. OpenAI GPT-4o-mini drafts a reminder email for each client and decides the escalation level. Gmail sends the email to the client, and an audit row is added to a recovery tab in the sheet. When nothing is overdue, a message is posted to Slack. If the AI recommends escalation, an internal email goes to the legal or AR team.
Steps
- Trigger: Runs every 24 hours on a schedule
- Reads the invoices tab in Google SheetsGoogle Sheets
Posts to Slack if there are no overdue invoices. - OpenAI (GPT-4o-mini) drafts the reminderOpenAI
Escalation level, HTML email, escalate or not. - Emails the client via GmailGmail
- Escalation email to the legal/AR teamGmail
If the AI recommends escalation. - Output: Updates the invoice row, appends an audit rowGoogle Sheets
- Output: Slack alert if the AI step errorsSlack
Limits
- Needs four separate credentials.
- Sends the email directly through Gmail; the page describes no draft mode.
What it does well
- Keeps an audit row for each recovery email.
- Posts a Slack message when nothing is overdue.
Before you import
After the import, add Google Sheets OAuth2, OpenAI, Gmail OAuth2 and Slack OAuth2 credentials.
Similar templates
Chase unpaid invoices with Claude
Also for invoicing and payments, 7 steps.
Chase unpaid invoices with OpenAI
Also for invoicing and payments, 7 steps.
Notion invoice reminders with Claude
Also for invoicing and payments, 7 steps.
Gmail and OpenAI: 29 templates compared
Same two apps, different steps.
Google Sheets and OpenAI: 24 templates compared
Same two apps, different steps.
Gmail and Google Sheets: 22 templates compared
Same two apps, different steps.
Gmail and Slack: 18 templates compared
Same two apps, different steps.
OpenAI and Slack: 17 templates compared
Same two apps, different steps.
Google Sheets and Slack: 16 templates compared
Same two apps, different steps.
Follow-ups and reminders
Other templates that do this task.