Invoice Reminder AI Agent

What this agent does

Chasing late payments is a task freelancers and small businesses both hate and both delay, which is exactly why invoices stay unpaid longer than they should. This agent watches your invoice tracker and sends the right reminder at the right time — friendly at first, firmer as it ages — so payment follow-up never depends on you remembering.

1. invoice-tracker — reads your invoice source (a Google Sheet or Notion database with due dates and paid/unpaid status) and identifies every invoice that's due soon, due today, or overdue.
2. reminder-drafter — for each invoice needing a nudge, drafts an email using the appropriate tone tier (a friendly heads-up before the due date, a direct reminder just after, a firmer follow-up for anything 14+ days overdue) and saves it as a draft for your review — nothing sends without your sign-off.

Every run logs which invoices were checked and which reminders were drafted, so you always know what's pending in your outbox.

Requirements

• An invoice tracker in Google Sheets or Notion with at minimum: client name, email, amount, due date, and paid/unpaid status.
• Gmail or Outlook access for drafting (never auto-sending).
• Works on OpenClaw (scheduled trigger + Sheets/Notion + email plugin).

Setup

1. Unzip the package into your workspace, keeping the folder structure intact.
2. Point config/invoice-source.md at your Sheet ID or Notion database ID and map the column/property names.
3. Edit config/reminder-tones.md to adjust the wording for each tone tier and the day thresholds that trigger them.
4. Run the starter prompt in starter-prompts.md against your current tracker to see what it would draft today.
5. Schedule automation-prompt.md to run daily.

What's included

• Skills/invoice-tracker/SKILL.md and Skills/reminder-drafter/SKILL.md
• config/invoice-source.md — Sheet/Notion source and column mapping
• config/reminder-tones.md — editable wording and day thresholds per tone tier
• installation-prompt.md — Sheets/Notion and email plugin setup
• automation-prompt.md — daily schedule instructions
• starter-prompts.md — example prompt for a dry-run pass
• assets/ — pipeline diagram