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.

n8nRead on 2026-11-167 steps

Steps

  1. Trigger: Runs on a weekday-morning schedule
    Checks date.nager.at for public holidays.
  2. Reads invoices and prior chase historyGoogle Sheets
    Google Sheets ledger and an n8n Data Table.
  3. Holds invoices whose client replied in GmailGmail
  4. OpenAI drafts a nudge, reminder or final noticeOpenAI
  5. Validates and sanitizes the draft
  6. Sends the reminder via GmailGmail
    If dry_run is disabled.
  7. 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