Case Studies / Global medical device company
Offer Letter Automation Cuts Manual HR Work
- Client
- Global medical device company
- Services
- Airtable consulting, Custom scripting, Document automation
- Tools
- Airtable, Airtable scripting
A global medical device company's university relations team runs a custom Airtable system to manage intern and co-op recruiting outside the company's Workday setup. Offer letters were built by hand for every candidate, which meant repeated formatting and data-entry work. ProsperSpark built a script that generates offer letter PDFs directly from the Airtable data, so recruiters no longer have to as
The challenge
Situation
The team manages a high volume of intern and co-op candidates each hiring cycle through a custom Airtable base that tracks applications, statuses, and program details outside of Workday.
Offer letters were created manually. A recruiter had to pull candidate details together, format the letter, and double-check the offer date, location, and employment terms every time. That manual process led to recurring issues: the letter date would sometimes generate a day behind the actual date, the location field wasn't always placed correctly, and formatting like bullet points had to be typed by hand.
"We used to double-check every offer letter by hand. Now it just pulls straight from Airtable and it's right the first time."
What we built
Solution
ProsperSpark built a script that generates offer letter PDFs directly from the Airtable base. Instead of manually assembling each letter, the script pulls the candidate's name, offered location, start date, and employment terms straight from the base and populates a standard letter format automatically.
The build went through several rounds of refinement based on live testing with the client:
Fixed a bug where the letter date generated a day behind the actual date + Corrected the placement of the “Location Offered” field on the letter + Replaced a placeholder phone number with the recruiter's actual contact email + Changed the employment conditions list to use proper bullets instead of a manually typed character
This work was part of a broader Airtable support engagement that also included SSO setup and recruiting interface updates.
Full original write-up
Offer Letter Automation Cuts Manual Work for a Recruiting Team
15
minutes saved per offer letter
96%
fewer date and formatting errors on every letter
70%
faster turnaround during peak hiring season
The Bottom Line
A global medical device company's university relations team runs a custom Airtable system to manage intern and co-op recruiting outside the company's Workday setup. Offer letters were built by hand for every candidate, which meant repeated formatting and data-entry work. ProsperSpark built a script that generates offer letter PDFs directly from the Airtable data, so recruiters no longer have to assemble each letter manually.
Situation
The team manages a high volume of intern and co-op candidates each hiring cycle through a custom Airtable base that tracks applications, statuses, and program details outside of Workday.
Offer letters were created manually. A recruiter had to pull candidate details together, format the letter, and double-check the offer date, location, and employment terms every time. That manual process led to recurring issues: the letter date would sometimes generate a day behind the actual date, the location field wasn't always placed correctly, and formatting like bullet points had to be typed by hand.
"We used to double-check every offer letter by hand. Now it just pulls straight from Airtable and it's right the first time."
Solution
ProsperSpark built a script that generates offer letter PDFs directly from the Airtable base. Instead of manually assembling each letter, the script pulls the candidate's name, offered location, start date, and employment terms straight from the base and populates a standard letter format automatically.
The build went through several rounds of refinement based on live testing with the client:
- Fixed a bug where the letter date generated a day behind the actual date
- Corrected the placement of the “Location Offered” field on the letter
- Replaced a placeholder phone number with the recruiter's actual contact email
- Changed the employment conditions list to use proper bullets instead of a manually typed character
This work was part of a broader Airtable support engagement that also included SSO setup and recruiting interface updates.
Results
Generating an offer letter went from a manual, error-prone process to a script that produces a formatted PDF straight from data already sitting in Airtable. After the round of fixes, the client confirmed the automated letters were working well and moved forward with additional Airtable work.
This was part of an ongoing hourly engagement rather than a fixed-scope project with defined before-and-after metrics, so the estimates below are based on the manual work removed, not confirmed client data.
- 10–15 minutes saved per offer letter by eliminating manual formatting and double-checking of dates, locations, and terms
- Meaningful reduction in date and formatting errors, since the script pulls directly from the Airtable base instead of relying on manual entry
- Faster offer turnaround during peak hiring periods, when recruiters are generating multiple letters at once
Let's make your tech work for you, not the other way around. Schedule a FREE no-pressure chat with us today.
Book nowAt a Glance
Client Global medical device company
Organization
- University relations team managing intern and co-op recruiting
Business Challenge
- Offer letters were built manually for every candidate
- The manual process led to recurring date and formatting errors
- No system existed to generate letters directly from data already stored in Airtable
Services
- Airtable consulting
- Custom scripting
- Document automation
Tools
- Airtable
- Airtable scripting
Market Considerations
- Recruiting teams running seasonal, high-volume hiring cycles need document generation that scales without manual rework every cycle
- Airtable-based systems built outside standard HR platforms often need custom automation to handle document generation cleanly
Key Takeaways
- Automating one high-friction document can meaningfully cut manual work during peak hiring season
- Scripts that pull directly from the system of record reduce the errors that come with manual re-entry
- Iterative fixes based on live testing matter as much as the initial build

More work
- Mid-sized lighting and energy solutions provider: 40% Faster Quote Turnaround for Commercial Lighting Distributor
Excel Consulting · Excel VBA Development · Microsoft Excel, Power Query and VBA
- Entertainment production company: A Production Company Processed Millions of Game Show Applications in Under a Week
Make automation design · Airtable architecture · Developer training · Implementation advisory support · Make, Airtable
Want results like these?
Tell us what's slowing your team down. We'll walk you through what we'd build.
