02 — Automation · Workflow System · 2025
Invoice Autopilot — From inbox chaos to paid on time
An automation that watches a freelancer's inbox and tools, drafts invoices, chases late payments politely, and logs everything in one dashboard.
- Role
- Automation Architect
- Year
- 2025
- Category
- Automation
- Stack
- Make + Airtable
“When a project is marked done, a draft invoice is created, a polite sequence of reminders is scheduled, and payments reconcile automatically.”
01
Project overview
Remove the weekly admin scramble: forgotten invoices, awkward follow-ups, and revenue scattered across tools.
02
Problem
Invoicing happened when there was time — which meant late. Payment status lived across email, Stripe, and memory. Follow-ups felt personal and were avoided, so cash flow suffered quietly.
P
Process
- 1
Audited two weeks of real invoices and follow-ups to find the repeatable 80% worth automating.
- 2
Designed a human-in-the-loop flow: automation drafts and reminds, the human approves and sends anything sensitive.
- 3
Added guardrails — idempotency keys, duplicate checks, and a single Airtable source of truth — so the system fails safe, not loud.
03
Solution
When a project is marked done, a draft invoice is created, a polite sequence of reminders is scheduled, and payments reconcile automatically. The owner sees one board: to draft, awaiting payment, and paid.
04
Reflection
Automation earns trust by being boring and predictable. The approval step looked like friction on paper but is exactly why the owner trusts it with client-facing messages.
R
Result
Weekly admin time reduced to a short review instead of an afternoon of chasing
Every invoice followed up consistently and politely — nothing slips
One dashboard answers 'who owes what' without opening four apps
Note: outcomes are described qualitatively. No invented metrics, awards, or client logos.