Weekly Client Report Generator
Client reporting is the chore that quietly eats your Friday. This workflow pulls each client's weekly metrics, drops them into a clean, branded summary, and emails it on a schedule — one report per client, sent without you touching a spreadsheet.
Every Friday you export numbers, paste them into a doc, reformat, write the same intro, and send — repeated for each client until the afternoon's gone.
Reports assemble and send themselves on schedule. You spend your time on the insight worth adding, not the copy-paste.
How it works
- 1Run on schedule — A cron trigger fires weekly (your day and time) and loops over each active client in your list.
- 2Pull the metrics — Fetches the week's numbers per client from your data source — analytics, ads, a sheet, or an API.
- 3Format the summary — Maps the data into a reusable template so every report is clean, on-brand, and consistent client to client.
- 4Send per client — Gmail sends each personalized report to the right contact, and the send is logged so you can see exactly what went out.
Built with
Best for
- ✓Agencies sending recurring client updates
- ✓Freelancers who report to multiple clients
- ✓Anyone whose Friday disappears into reporting
Questions
Can each client get different metrics?
Yes. The per-client loop lets you vary the data source and template fields, so a retainer client and a project client each get the right report.
Where do the numbers come from?
Any source with an API or a sheet — Google Analytics, an ad platform, a database, or a maintained spreadsheet. The data node is yours to point.
What's it tested on?
Tested on n8n v1.58+. You connect your own data source and Gmail.
In the Pro bundle
Get on the early list to be first when bundles open — launch pricing for the list. Start with the free sample to see the quality.