A quality management and food safety training provider was drowning in manual certificate admin. A previous consultant had said automation wasn't possible.
At the end of every training cohort, a staff member would open an Excel spreadsheet and copy each delegate's details by hand into an Adobe PDF template, one certificate at a time. For large cohorts, this meant hours of repetitive work after an already long day.
It was slow, it was error-prone, and it was demoralising. And a previous consultant had told them automating it was not possible.
The same technical obstacle the previous consultant had hit presented itself here too, and a way around it was found. Using Python, a script was built that reads directly from the existing spreadsheet and generates every certificate automatically: correctly named, formatted, and saved.
The solution was built in a single day and requires no technical knowledge to run. The staff member runs it, and every certificate for the cohort appears, finished.
Client data never enters an AI model and never leaves their own computer. The system is fully owned by the organisation and works regardless of cohort size.
Hours of manual admin per cohort collapsed to the click of a button. The staff member who used to dread end-of-cohort admin got that time back. And the organisation owns the tool outright: no subscription, no dependency, no ongoing cost.
The broader lesson is one I see constantly: the barrier to useful automation is often not technical difficulty but a lack of someone willing to look for the way around the obstacle. What one consultant called impossible took a day.
If something in your business is still done by hand because someone said it couldn't be automated, that's often exactly the thing that can.