APIANT.ai / Stories / Personal training studio

Customer story · Personal training studio · Mindbody, Google Sheets, and Gmail

A personal training studio wanted website visitors to book a consultation straight into Mindbody. It was live 35 minutes after sign-up.

Clients, contracts, and appointments live in Mindbody. The studio wanted its website to show the consultation times that are really open, take the booking, and put it on the right person in Mindbody, with nobody typing it in. They asked for it, and the first booking from a visitor arrived that same evening.

The challenge

The studio starts new people with a consultation, and keeps its clients, contracts, and appointments in Mindbody. It wanted visitors to its website to see the consultation times that are really free, pick one, and have the booking land in Mindbody on the right person: matched when they are already a client, and added as a new prospect when they are not.

Once bookings were coming in, it wanted the business visible without opening Mindbody: who booked a consultation, who bought their first personal training, who cancelled or came back, and whether every active client had signed both the liability waiver and the contract.

The journey

  1. Day 1

    Live 35 minutes after sign-up

    The studio connected Mindbody and asked for two pieces behind its website. The first reads the bookable consultation times from Mindbody and turns them into start times every 15 minutes. The second takes the booking: it looks the visitor up in Mindbody by email, adds them as a new prospect if they are not there yet, and books the consultation, asking Mindbody to send its confirmation email. Both were switched on 35 minutes after sign-up, and within the hour the first one also kept only the starts where the whole session fits.

    The studio's website runs on WordPress. A small booking calendar on its consultation page calls both pieces straight from the visitor's browser: it asks for the open times when a visitor opens it, and sends the booking back when they pick one.

    Live on day 1

  2. Day 1, that evening

    The first booking from a visitor

    The owner made a few test bookings of their own, then left it running. That evening the first consultation booked by a visitor arrived in Mindbody.

  3. Days 1 to 27

    Bookings on their own

    From day 1 to day 27, 17 people booked 18 consultations from the website, on 13 different days. 15 of them were new to the studio and were added to Mindbody as prospects, marked as coming from the website booking page. 2 were already clients and were matched to their record. One visitor booked a second time minutes later and was matched to the record their first booking had created.

    18 consultations booked

  4. Day 26

    The business in a spreadsheet

    The owner then asked for the studio's comings and goings in Google Sheets. Consultations booked, first-time personal training clients, cancellations, and returning clients are each written to a sheet as they happen in Mindbody, with an email to the owner through Gmail.

    Another check runs whenever a client's contract is created or changes, and records whether the liability waiver and the contract are both signed. It is set up to remind the client after 24 hours and to tell the owner after 48 hours if anything is still unsigned.

What they built

AutomationWhat it doesRuns
Open timesReads the bookable consultation times from Mindbody and returns start times every 15 minutes where the whole session fitsEach time the booking page asks
BookingFinds the visitor in Mindbody by email or adds them as a new prospect, then books the consultation and asks Mindbody to send its confirmation emailFor each booking
Consultations bookedEach new consultation in Mindbody written to a sheet, with an email to the ownerAs consultations are booked
New clientsA client's first personal training purchase written to a sheet, with an email to the ownerOn each sale
Cancellations and returnsCancelled contracts, and contracts started again after a cancellation, written to the sheet, with an email to the ownerOn each contract change
Waiver and contract checkRecords whether a client with an active contract has signed the waiver and the contract, with reminders set up for anything unsignedOn each new or changed contract

Booking figures cover day 1 to day 27 and leave out the owner's own test bookings.

Why it worked

More stories

What would you ask for?

Start freeRead more stories

Details are taken from the account's own run history and shared without the studio's name. No client or staff details are included.