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.
Deal data stays governed. Material decisions stay human.
We design M&A systems around least-privilege access, documented data flows, protected credentials, traceable activity, and approval gates. Systemify does not use client information to train its own models, and no AI provider receives deal data until the provider, purpose, and retention approach are agreed.
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
Fractional COO Leadership
Senior fractional operations leadership for M&A teams that need clearer deal processes, stronger accountability, and reliable execution from first contact through close.
Explore service ?Operations Streamlining
We streamline M&A workflows across sourcing, intake, valuation, buyer matching, documents, diligence, and pipeline monitoring—without forcing your team into a new platform.
Explore service ?Automation & AI Systems
We build custom M&A AI systems for sourcing, qualification, valuation, buyer-seller matching, CIMs, LOIs, diligence, and deal-pipeline intelligence.
Explore service ?