8 VAs Replaced With 1 — Custom Influencer CRM Centralises 250+ Spreadsheets
A D2C hair care brand was managing 250+ influencer contracts across 250 separate Google Sheets with 8 virtual assistants. We built a custom CRM that centralised everything into one system. One VA now runs what 8 couldn't keep up with.
Quick Overview
The Challenge
250 Spreadsheets, 8 VAs, and Still Losing Data
Every influencer had their own Google Sheet. Tracking required: contract terms, payment structures, video submission status, follower counts, engagement rates, earnings per video based on deal terms, approval status, and payment history. Eight virtual assistants were employed full-time just to manage these spreadsheets.
The problems were systematic. Data entry errors across 250 manual files. No single source of truth — to understand the programme's performance you'd need to check every sheet. Duplicate tracking, inconsistencies between files, and a founder with no overview unless they dug through hundreds of documents.
And the most critical problem: the model couldn't scale. Adding more influencers meant adding more VAs, adding more sheets, adding more chaos.
Key Pain Points:
- 8 full-time VAs consumed by spreadsheet management — not strategy
- 250+ separate Google Sheets with inconsistent data and entry errors
- No single view of programme performance
- Manual follower counts and metric tracking prone to errors
- Adding influencers required adding headcount — bottleneck on growth
The Solution
One Custom CRM to Replace All 250 Sheets
The CRM centralises every influencer, contract, and performance metric in one place. Follower counts and video performance metrics are pulled automatically via social media API integrations — no manual entry. The earnings per video are calculated automatically based on the contract terms stored in the database.
For the video validation workflow — which requires human judgment on brand voice and content quality — we built a single interface where the VA reviews submissions, approves or rejects with notes, and the result triggers payment logic automatically. The human stays in the loop where human judgment matters. Everything else is automated.
How It Works:
- All influencer data and contract terms stored in Supabase database
- Social media APIs auto-pull follower counts and video metrics daily
- Earnings calculated automatically based on stored contract terms
- VA reviews video submissions in one interface — approve/reject with notes
- Payment triggers fire automatically on approval
- Dashboard shows programme performance across all creators in real time
Implementation: Custom build
Technical Challenge: The original prototype was built in Bolt.new, but the application complexity required migrating to Replit for proper scalability. Supabase handles the database layer with real-time updates. The most complex piece was mapping the earnings calculation logic against variable contract structures.
The Results
8 VAs → 1. 250 Sheets → 1 CRM.
| Metric | Before | After | Impact |
|---|---|---|---|
| VA headcount | 8 full-time VAs | 1 VA | 87.5% labor reduction |
| Data management | 250+ Google Sheets | 1 centralised CRM | Zero spreadsheets |
| Data accuracy | Manual entry errors | Automated API tracking | Errors eliminated |
| Scalability | Each influencer = more VAs | Unlimited influencers | No proportional cost |
Data accuracy improved dramatically because the sources of manual error — copying metrics between sheets, calculating earnings by hand — were replaced with automated API pulls and database calculations.
Most importantly, the growth bottleneck was removed. Based Bodyworks can now scale their influencer programme as aggressively as their marketing strategy demands, without any proportional increase in operational cost.
Hear From the Client
Frequently Asked Questions
Why build a custom CRM rather than use an existing influencer platform?
Off-the-shelf influencer tools are built for generic use cases. Based Bodyworks' payment structures, contract terms, and video validation workflow were specific enough that adapting a generic tool would have left most of the manual work in place. Building to their workflow eliminated the manual work entirely.
Does the automation replace human judgment on content quality?
No — and deliberately not. Video quality, brand voice, and messaging alignment require human review. The system automates everything around that decision: pulling metrics, calculating earnings, triggering payments. The human makes the creative judgement call; the machine handles everything before and after it.
Download the Full Case Study
Get the complete PDF with detailed implementation notes, research citations, and ROI calculations.
Request Case Study PDFServices That Can Help Your Business
Explore the automation services we used to achieve these results
Personalised Outreach at Scale
Reach hundreds of ideal prospects with messages that read like they were written specifically for each one — their business, their situation, their language. At scale, automatically.
Explore service →Personalised Lead Response
Every lead receives a message that feels personally written for them — whether they come to you or you reach out to them. Their business, their situation, what they care about. Not a template. Not a generic reply.
Explore service →Instant Value Delivery
Before competitors have even replied, your lead has a custom quote, a personalised proposal, or a tailored document — built from what they told you, delivered automatically.
Explore service →