Chase unpaid invoices with OpenAI
OpenAI drafts tiered invoice reminders, sent through Gmail. This n8n template runs on weekday mornings and works from an invoice sheet in Google Sheets. An OpenAI-compatible model drafts a nudge, a firm reminder or a final notice, with the tone set by days overdue and the client's payment history. If dry_run is disabled, Gmail sends the reminder and an n8n Data Table keeps chase counts and last-chased dates; one Slack digest lists what was sent or held. A public holiday lookup is called over HTTP. It is meant for teams that bill clients and chase payments by email.
Steps
- Trigger: Runs on a weekday-morning schedule
Checks date.nager.at for public holidays. - Reads invoices and prior chase historyGoogle Sheets
Google Sheets ledger and an n8n Data Table. - Holds invoices whose client replied in GmailGmail
- OpenAI drafts a nudge, reminder or final noticeOpenAI
- Validates and sanitizes the draft
- Sends the reminder via GmailGmail
If dry_run is disabled. - Output: Posts a single Slack digestSlack
Limits
- Calls an outside holiday service, date.nager.at.
What it does well
- One Slack digest lists what was sent and what was held.
- Keeps a chase count and last-chased date per invoice.
Before you import
After the import, add Google Sheets, Gmail, Slack and OpenAI-compatible credentials, set the sheet URL and the Slack channel, and create an n8n Data Table named invoice_chases.
Similar templates
Notion invoice reminders with Claude
Also for invoicing and payments, 7 steps.
CFO agent with six finance agents
Also for invoicing and payments, 5 steps.
Invoices to Sheets with Mistral OCR
Also for invoicing and payments, 4 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.