Meta: Stop hand-building monthly client reports. Free automation that assembles stats from your tools and emails the digest on schedule — the 30-minute setup.

Client reporting automation for small agencies

Every small agency has the same month-end ritual: gather stats from three tools, paste them into a deck, email it, and hope the client doesn't ask "what about X?" — then repeat for every client. A $500/month reporting tool is overkill for most. A free automation isn't.

What clients actually want in a report

1. What you did (tasks, deliverables — one line each)
2. How it performed (the 3–5 numbers you agreed on)
3. What's next (next month's plan)

Clients rarely read 20 pages. They read the summary and check that numbers moved. Design for that.

The free 30-minute build

• Source of truth: one Google Sheet per client with a metrics tab (your agreed KPIs: visits, leads, posts, hours — whatever the contract says).
• Collection: n8n (free) pulls from the tools that have exports or APIs — Search Console CSV, social exports, your time tracker — and appends to the sheet weekly.
• Delivery: a monthly cron builds the digest from the sheet and emails it to the client and your archive address.

The template that takes 2 minutes to fill, not 2 hours

`` [Client] — [Month] report Done: [3 bullets] (you write these — 90 seconds) Metrics: [KPI table from the sheet] (automated) Next month: [3 bullets] (you write these — 90 seconds) `` The automated part kills the data-gathering; the manual part stays human — which is exactly what makes the report feel personal.

Where agencies lose (and automation wins)

• Late reports — schedule it for the 1st, 09:00. "It sends itself" is a feature clients notice.
• Inconsistent numbers — one sheet per client, appended weekly, means the monthly number is never re-derived from memory.
• Hourly cost — at 1 hour/client/month and 10 clients, that's 10 hours. Automating 80% of it buys back a full day, every month.

The Agency Client Report pack ($39) ships this exact pipeline — sheet templates, weekly collectors, monthly digest — with a setup video. Or build it from the recipe above; the structure matters more than the tools.

One warning: automate the *gathering*, never the *judgment*. "What does this number mean for next month?" stays yours — that's the part clients are actually paying for.