Weekly Client Report Automation for an India-Based Ads Agency

The client

Northlight Media · Agency · India · Engagement: 4 weeks · Team: 2-person WOW pod

The challenge

Northlight Media managed 32 client accounts across Google Ads, Meta Ads, and GA4. Every Monday, three account managers spent a full day pulling data into Google Sheets, writing commentary in Slides, and emailing reports out. Errors were common, formats varied by manager, and clients often complained the insights felt boilerplate.

What we built

WOW built a reporting engine on n8n that pulls performance data from Google Ads, Meta Ads, and GA4 APIs into BigQuery every night. A GPT-4o prompt chain generates client-specific narratives — comparing week-over-week and month-over-month performance, calling out anomalies, and suggesting next actions grounded in each client’s stated goals from a Notion brief. Reports render as branded PDFs and post to a shared client Slack channel every Monday at 9am IST, with the email version sent from the account manager’s own address. Account managers review and can override any section before send.

Results

Tech stack

“Monday used to be reporting day. Now Monday is strategy day. My team is finally doing the work clients pay us for.”