Influencer Agency Platform
Automated workflows, a live dashboard, and an AI matching system for Uncharted Influencer Agency, a seven figure agency managing hundreds of creators from a single Google Sheet.
Overview
Uncharted Influencer Agency manages hundreds of creators who together generate millions in campaign revenue, and for years the entire operation ran out of one Google Sheet. The problem is that influencer data never sits still. Follower counts move, average views shift, and contact details go stale. The team wanted to keep the sheet as their source of truth, so we met them where they were. The first phase was a set of automations that update the sheet directly through APIs, with AI enrichment layered on top to capture the qualitative side of each creator. From there we built a dashboard that syncs with the sheet automatically, vectorizes the roster, and runs an AI matching system that suggests the best creators for any campaign brief.
What We Did
Automations on Top of Google Sheets
The team trusted their spreadsheet and wanted to keep it, so the first phase worked entirely inside it. Scheduled jobs pull fresh follower counts and average views through platform APIs and write them straight back into the sheet, keeping hundreds of rows current without anyone touching a cell.
AI Enrichment for Every Creator
Raw numbers only tell half the story. An AI pipeline reviews each creator and adds qualitative context like content style and niche fit, and it also reads the contact details in their bio to judge which email is actually the right one to reach them at.
A Live Creator Directory
The dashboard syncs automatically with the Google Sheet, which stays the source of truth. Hundreds of creators become a searchable directory with tiers, niches, audience breakdowns, and rates, refreshed every night with no manual data entry.
AI Campaign Matching
The whole roster is vectorized so the platform can run retrieval over it. Drop in a campaign brief and the matching system ranks the creators that fit best, each with a transparent score breakdown across audience, average views, tier, rates, and content fit.
Google Sheets API Sync
AI Data Enrichment
Vector Search & RAG
Nightly Auto Sync
What the client said
The problem
Hours of manual data entry needed by our VAs when it came to our influencer database, which meant tons of wasted time, especially with data that needed monthly updating like follower size, average views, and engagement rates. Just messy data in general as well.
Working together
Kai is the best developer we've worked with on AI and automation. He actually gets the business problem and not just the code. His level of flexibility and urgency when it comes to updates is insane. There were times where we've needed last minute functions added and he got it done and exceeded what was requested. A lot of the time we'd ask for a function and he'd think of a better process to implement.
The result
Hundreds of hours saved with database upkeeping, as well as a custom platform built to assist with creator matching for complex creator campaigns.
Would you recommend us?
Definitely yes. As Kai is still building out his primary client base, it's the perfect time to get his help, as he's super talented and has the resources to go above and beyond for you, compared to a large AI agency at scale with hundreds of clients.
