Home/Case Studies

Customer RetentionLive October 2026

Automated email system for repeat customers

After every class, the owner of a firearms training academy typed each student into a document and sent the follow-up emails by hand. Now one form does the work, and every student gets the right email on the right day.

/ 01At a Glance

Client

A firearms training academy

Delivered in

About one week

Tech stack

  • Google Forms
  • Google Sheets
  • Apps Script
  • Make.com
  • Gmail

Value

Every student followed up automatically, for $0 a month to run

Logos identify third-party services we build with and do not imply any endorsement or partnership.

/ 02The Story

The problem

His students take one class and, ideally, come back for the next one. The follow-up is what brings them back. In his words: "I would have to send you a text message with an invoice after getting all the info from you. And then I would have to manually add you to an Excel document. And it was a pain in the butt."

He also had no way of knowing whether his emails landed. "Maybe half the students receive it, and the other people don't. And so maybe it's in a spam or a junk folder. I have no idea."

What we built

One Google Form he fills in once per class, with the class name, the last day of class, and the roster pasted straight out of his booking tool. It takes about two minutes. Two Make.com scenarios do the rest: the first splits the roster into students and queues their emails, and the second prepares each one in his Gmail on the morning it's due.

  • The next-steps email goes out the morning after class.
  • The 10-week check-up goes out ten weeks later and points students to the continuing classes.
  • Nothing goes out on a Sunday, a couple who booked together gets one email addressed to both of them, and a roster submitted twice is ignored.
  • Every email is logged in a sheet he can open anytime, so he knows exactly who got what and when.

Built for an owner who isn't a tech person

The owner put it plainly: "make things simplistic because I'm not the smartest when it comes to technology." So there's nothing new for him to learn. Everything runs in his own Google and Make accounts, and he got a written guide with screenshots for the rare day he needs to look under the hood.

The result

For now each email waits in his Gmail as a draft he can glance at before it goes, which is how we prove a new system on a real class. After his November class runs through it, it sends on its own.

/ 03Screenshots

The roster upload form: class name, last day of class, and the pasted roster
The one form the owner fills in
A Make.com scenario with ten modules, from the roster form submission through to the email queue
One of the two Make.com scenarios
The email queue spreadsheet, one row per student per email with a status column, filled with test data
The email queue, test data only

/ 04Review

Joe did a great job at listening to the concerns I was having with my business then creating a plan to fix those issues. With the setup he did, I feel the clients I work with will be able to more easily submit their applications in a timely manner as well as come back for future training with my business.

Joe went to work promptly and created a solution to the issues I was having, leaving my business in a better position to train instead of worrying about technology side that is outside of my ability. He continued to give me progress reports and keep me in the loop of his work. He sent reports over with instructions so that I could easily follow them.

It was a pleasure working with someone who was able to exceed my expectations and I'm looking forward to see how his system works out for my small business in the years to come! I would highly recommend Joe to others.

Owner, firearms training academy ยท October 2026

/ 06Start Here

Want to automate your business?

Show us where your time goes in a normal week. We'll give you a prioritized action plan to get incredible value from AI and Automation in your business. That customized report will be yours, whether you work with us or not.

joe@arowise.com