Skip to content
← All work

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.”

MakeAirtableStripeGmail APIWebhooks

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. 1

    Audited two weeks of real invoices and follow-ups to find the repeatable 80% worth automating.

  2. 2

    Designed a human-in-the-loop flow: automation drafts and reminds, the human approves and sends anything sensitive.

  3. 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.

Next step

Have a project in mind? Let's make it happen.

Tell me what you're trying to build or fix — I'll reply with honest scope and next steps.

Start a Project