Make.com

Reliable Booking Request Logging with Rollback Automation for Marketing Agency

A Munich-based marketing agency needed a reliable way to capture project briefs from JotForm into Excel without errors or duplicates. I built a Make.com scenario with rollback logic that ensures every row is 100% correct – or nothing is written – saving hours of manual work and guaranteeing clean data.

Automatisierung - TK-Agency.dev - KI Agenten - AI Agends - Zapier - Make.com - Atlassian Support
2–3 staff hours saved daily · 40% faster project kickoffs
20 Stunden pro Woche sparen - TK-Agency.dev - Automatisierungen
2 Weeks
Make.com
JotForm
Microsoft Excel

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.

Book your free automation check →