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.

n8nRead on 2026-11-167 steps

Steps

  1. Trigger: Runs every 24 hours on a schedule
  2. Reads the invoices tab in Google SheetsGoogle Sheets
    Posts to Slack if there are no overdue invoices.
  3. OpenAI (GPT-4o-mini) drafts the reminderOpenAI
    Escalation level, HTML email, escalate or not.
  4. Emails the client via GmailGmail
  5. Escalation email to the legal/AR teamGmail
    If the AI recommends escalation.
  6. Output: Updates the invoice row, appends an audit rowGoogle Sheets
  7. 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