A paid media agency with 18 employees came to us with a problem every agency operator knows: client reporting was eating their account managers alive. Each AM spent roughly 14 hours per week pulling data from ad platforms, formatting spreadsheets, writing summaries, and assembling PDF reports.
We built a single n8n workflow that replaced the entire process. Here is exactly how it works.
The reporting stack before ThinkFlow
Each account manager managed 4 to 6 clients. Every week, they logged into Meta Ads Manager, Google Ads, LinkedIn Campaign Manager, and HubSpot. They exported CSVs, copied numbers into a Google Sheets template, built charts, wrote a performance summary, and exported the whole thing to PDF.
The process took 2 to 3 hours per client. With 6 clients, that is 14 hours per AM per week spent on reporting alone. Time that should have gone to campaign optimization and client strategy.
The n8n workflow we built
The workflow runs every Monday at 6 AM. It connects to Meta Marketing API, Google Ads API, LinkedIn Ads API, and HubSpot via HTTP request nodes. It pulls the previous week's performance data for every client, normalizes the metrics into a consistent schema, and calculates week-over-week changes.
Then it sends the structured data to Claude via API for a natural-language performance summary. Claude generates a 3 to 4 paragraph analysis highlighting what improved, what declined, and what the AM should focus on next week. The summary and data feed into a branded HTML template, and Puppeteer renders it as a PDF.
The final PDF gets uploaded to the client's shared drive folder and an email goes out automatically with the report attached. The AM reviews it in Slack (where we post a preview) and can flag anything that needs a manual edit before the client sees it.
The result
14 hours per AM per week dropped to roughly 40 minutes of review time. The agency reclaimed over 50 hours per week across their team. Report quality actually improved because Claude's summaries were more consistent than what the AMs were writing manually under time pressure.
The workflow has been running for 4 months with 99.9% uptime. Total build time was 3 weeks.
Ready to put this into action?
Book a free consultation and we'll show you exactly how to apply these ideas to your business.
Book Free Consultation
