The client
A 10-person design agency in Munich manages dozens of client campaigns every month. Project briefs came in through JotForm and had to be logged in Excel – by hand, with delays, errors and duplicated work.
The challenges
- Copy-pasting dozens of fields every day cost 2–3 hours
- Typos and missing fields caused confusion
- Failed imports left half-filled “orphan” rows
- Errors only surfaced hours later
My solution
I built a Make.com workflow with rollback protection that:
- captures JotForm submissions instantly
- maps and inserts all data into Microsoft 365 Excel
- works atomically: either the full row is written correctly, or nothing is written
- rolls back and sends an alert if any step fails, keeping the sheet clean
The results
- Zero manual entry: 2–3 hours a day back for the team
- Clean data: no partial or duplicate rows
- Faster kickoffs: new briefs appear in Excel in under a minute – 40% shorter lead time
- Full transparency: rollback alerts flag issues immediately
Conclusion
With rollback-protected automation, the agency now runs a reliable intake-to-Excel pipeline – faster client onboarding, trustworthy data, and more time for creative work instead of spreadsheets.
Free 15-minute automation check
Running similar manual processes? In 15 minutes I'll show you which steps can be automated right away, how much time you get back each month, and which tools fit your setup.
