Implementation and results
The Problem
A growing UGC agency managing 30-60 creators across 4-5 clients had no infrastructure to sustain scale. Briefs were created manually, post tracking was done by hand, and there was no visibility into which creators were falling behind or going viral.
The Hypothesis
A single shared automation layer across Notion, Slack, and Google Sheets could replace the manual ops work entirely, routing the right information to the right people without anyone having to chase it.
The Outcome
Fully automated creator tracking, weekly brief generation, and Slack-based reporting across all clients and campaigns from one system.
Systems Architecture
Trigger: new week begins or creator posts
Logic: sync post data to Sheets, update Notion dashboard, flag missed posts and viral videos
Action: deliver briefs, weekly reports, and alerts to creators and campaign managers via Slack