A Production Company Processed Millions of Game Show Applications in Under a Week
of applicants processed at scale
to get automation live
for Season 2
The Bottom Line
A Los Angeles-based production company that creates content for major streaming platforms needed to process millions of applicants for a major game show with less than a week to spare. Their existing Airtable setup wasn't built to handle that volume. ProsperSpark designed a MAKE automation architecture that split incoming webform submissions across multiple Airtable bases and routed approved applicants forward for continued review.
The client's own developer did the implementation while ProsperSpark provided training and advisory support throughout. The automation went live in time, handled the full applicant load, and was reused for the following season.
Situation
The production team was managing applicant intake for a high-volume game show and had built their tracking setup in Airtable. What they hadn't anticipated was the scale. Applications came in by the millions, and Airtable's record limits made it impossible to store everything in a single base without hitting a hard ceiling.
The timeline made it worse. They had under a week before the system needed to be live and processing real submissions. Their current setup could handle around 200,000 applicants. They needed to handle many times that.
They came to ProsperSpark for help. Not a full rebuild from scratch, but a practical solution that could work within Airtable's structure, use their existing tools, and get their own developer up and running fast.
We built it once. They've run it twice.
Solution
ProsperSpark designed a multi-base architecture using MAKE and Airtable that could absorb the full applicant volume without running into record limits.
The approach used secondary bases organized by applicant segment to capture incoming webform submissions. MAKE handled the routing logic, directing each submission to the appropriate base automatically. Once applicants reached the review stage, approved candidates were moved into a separate base for continued evaluation, keeping the working dataset clean and manageable as the process moved forward.
Because the client had a developer in-house, ProsperSpark's role focused on designing the architecture, training the developer on MAKE and Airtable, and providing troubleshooting support as the setup came together. The goal was to get the client's team capable of running the system independently, not to create ongoing dependency.
Results
The automation went live before the deadline and processed the full volume of applicants without issue. What had been a hard ceiling of roughly 200,000 records became a non-issue once the data was distributed across the right base structure.
Beyond the raw volume, the architecture gave the team a cleaner way to manage the review process. Approved applicants moved into a dedicated base for continued evaluation, which meant the team was always working against a focused, relevant dataset rather than a single overcrowded table.
The most direct measure of the solution's value: the production team used the same system for the following season. They didn't need ProsperSpark to rebuild it or retrain anyone. They ran it themselves.
Let's make your tech work for you, not the other way around. Schedule a FREE no-pressure chat with us today.
At a Glance
Client
Entertainment production company
Organization
- Production company behind competition and reality programming for major streaming platforms
Business Challenge
- Existing Airtable setup had a hard ceiling of around 200,000 records
- Millions of applicants needed to be processed in under a week
- No automation in place to route or distribute submissions at scale
Services
-
- Make automation design
- Airtable architecture
- Developer training
- Implementation advisory support
Market Considerations
- High-volume intake events can quickly outpace what a single database can handle
- The right architecture before launch is the difference between a system that holds and one that breaks
Key Takeaways
- A distributed Airtable architecture with automated routing can scale well beyond a single base's limits
- Training the client's team to run it independently kept the solution sustainable long-term