I implement CRMs for local businesses. Recently, I built a setup for a US-based clinic, and thought the workflow decisions might be useful to others working with appointment-based businesses.

Before this, the front desk and owner handled most things manually: confirming appointments, checking intake forms, giving aftercare instructions and remembering who was due back. They used Excel for reminders, separate booking, invoicing and newsletter tools, and a personal phone for patient texts.

We spent about five hours across a week mapping their process before building it. Their priorities were fairly straightforward:

• Make communication specific to the treatment.
• Reduce missed appointments.
• Keep routine work out of the CRM interface where possible.
• Clearly divide responsibilities between the front desk and treatment provider.

One opportunity per appointment, linked to the patient

This was the main structural decision.

A patient can have two upcoming appointments with different confirmation statuses, preparation instructions and follow-up needs. A single patient-level opportunity wouldn’t represent those independently.

Each appointment therefore gets its own opportunity. The main appointment stages are:

• Upcoming, unconfirmed
• Upcoming, confirmed
• Critical, unconfirmed: within two days of the appointment

The critical stage is the front desk’s action list. Automated messages handle the initial chasing, then staff get notified when a call is needed.

The clinic also treats bookings made within four days of the visit as confirmed. That’s their operating rule rather than explicit confirmation from the patient (an important distinction when interpreting the pipeline).

Booking and intake

Patients book through the website and receive an acknowledgement by email and SMS.

The workflow checks whether they have previously completed the initial intake form. If not, the acknowledgement directs them to it. Known personal details are prefilled so they don’t have to enter them again.

Clinic calls and texts run through a dedicated number rather than the personal phone.

Reminders and escalation

The schedule includes:

• Booking acknowledgement
• Four days before
• One day before
• Two hours before

These use a mix of email and SMS. For unconfirmed bookings, the four-day message includes a confirmation link that updates the appointment record.

If the appointment reaches the critical stage without confirmation, automated chasing is followed by a front-desk notification if there’s still no response.

Cancellation and rescheduling links are included in the relevant messages, along with the clinic’s cancellation policy.

Six treatment categories determine the communication

The clinic offers multiple treatments. We grouped them into six categories, which control preparation instructions, aftercare and longer-term follow-up wording.

That gave us a manageable number of workflows while keeping messages relevant to what someone actually booked.

The day before the visit:

• The patient receives preparation instructions for their treatment category.
• The provider receives the relevant patient profile and intake information before the appointment.

Attendance without another login

Fifteen minutes after the appointment starts, the provider receives an SMS with a link to record attendance.

This lets them complete a routine action without opening the CRM.

Aftercare and return visits

The setup includes treatment-specific aftercare and a review request, with an internal check for whether a previous review has been recorded.

Longer-term follow-ups are scheduled at two, three and six months. Both the timing and treatment category affect the wording, rather than sending the same “time to book again” message repeatedly.

Treatment and follow-up tags also let the clinic identify relevant groups for future outreach.

The most useful part of the discovery work was deciding which actions needed a person, who owned them, and what information they needed at that moment. Building the automations came after that.

For others using a sales-oriented CRM for repeat appointments: do you use an opportunity per visit, a separate appointment object, or another structure? And what reminder cadence did you find most useful/relevant?

One issue with CRM systems that often gets overlooked is how data quality degrades when multiple teams follow different workflows. Sales may update contact details, support may maintain separate case notes, and management may rely on reports built from records that are already outdated.

Over time, these small inconsistencies create bigger problems: duplicate customer profiles, unreliable pipeline forecasts, incomplete interaction histories, and conflicting information across departments.

User adoption is another part of the problem. When the CRM requires more effort than the process it replaces, people tend to maintain parallel spreadsheets or enter only the minimum information required. That creates gaps that become difficult to identify later.

I think CRM reliability depends heavily on clear data ownership, consistent field definitions, and workflows that fit how teams actually operate. Without those foundations, even a well-configured system can produce misleading reports and poor decisions.

Hey everyone, I built a local tool for freelance solopreneurs.

Running cold outreach from a basic spreadsheet gets exhausting real fast:
dialing numbers by hand all day, jumping across windows, and stressing over missed callbacks.

Big-name CRMs are very expensive when you start out and are complete overkill when you work for yourself, while most sales tools feel bloated just to make a phone call.

So I built my own thing: Prospect Legend.

It’s a 100% local Windows app designed for freelancers (no cloud, no APIs, no accounts: you actually keep your data to yourself) that turns any .xlsx spreadsheet into a smooth workflow cockpit.

It lets you import your Excel file to click-and-call, instantly log outcomes so contacts automatically sort into the right tabs, and fire off pre-filled follow-up templates straight from your sheet (you can set up 4 custom templates).

You also get a built-in calendar for reminders so you never drop the ball, plus a bit of gamification with an XP system to keep morale up.

I’m looking for 5 to 6 more freelance beta-testers who deal with cold outreach.

For beta users: there’s a 30-day free trial period, an exclusive discount at launch, and a direct say in future features.

If you want in, drop a comment or DM me.

CRM implementation can become challenging when business processes are unclear or teams are not prepared for the transition. Inconsistent data, limited user training, and poor workflow alignment can create confusion and reduce productivity.

A well-planned implementation helps teams maintain reliable information, coordinate tasks, and manage customer relationships more effectively.