Build an appointments and follow-up system

Where appointments fall through the cracks

On Monday a customer sends a WhatsApp message: “Can I bring my car in for service on Thursday?” A colleague replies, “Let me check,” and then nothing happens. Or two colleagues book the same time slot: one on the phone, the other at the front desk. On Thursday there are two cars waiting for one lift.

This is rarely due to unwillingness. It comes from having no single place where everything is recorded, and no fixed agreements about who does what. In this lesson you build a simple system with three parts:

• One place where every appointment request ends up: a shared spreadsheet, a shared calendar, or both with a clear division of tasks.
• Fixed steps for every request: check availability, confirm, send a reminder if the customer wants one, and follow up.
• Fixed people responsible: every open request shows who is handling it and when it will be looked at again.

In lesson 2 you created a callback process and in lesson 3 you set up WhatsApp Business. Appointment requests from those channels now go into one list, as do those from customers who walk in. You do not need to buy anything: a spreadsheet and the calendar you already use are enough.

Choose one place and record only what you need

The most important decision in this lesson: where does the truth live? If an appointment can be in two places, sooner or later it goes wrong. So choose one fixed place for each kind of information, and tell the whole team which one it is.

A workable combination: the calendar shows when something is scheduled, the list shows what still needs to happen. A confirmed time always goes into the calendar first and only then into the list. If you work with the list alone, the Confirmed time column is your calendar.

What to record for each request, at a minimum

For each request, record no more than you need to make the appointment and keep it. This is enough:

Setting up the list in Google Sheets or Excel

You can download the ready-made list; the columns, drop-down lists and the count are already in it. If you would rather build it yourself, or want to understand how it works, follow the steps below.

1. Open or create the list

   Google Sheets: on sheets.google.com choose a blank spreadsheet, or upload the downloaded .xlsx file to Google Drive and open it with Google Sheets. Excel: open the file or create a new workbook. Give it a clear name, such as “Appointments and follow-up [Business name].”

2. Put the columns in row 1

   In row 1, from column A to M, type: Request date, Source, Customer, Contact, Service / question, Requested time, Confirmed time, Status, Responsible, Follow-up date, Consent to contact?, Next action, Notes.

3. Freeze the header row

   That keeps the headings visible when you scroll. Google Sheets: View → Freeze → 1 row. Excel: View → Freeze Panes → Freeze Top Row.

4. Create a drop-down list for Status

   Select column H from row 2 down. Google Sheets: Data → Data validation → Add rule → Dropdown. Excel: Data → Data Validation → Allow: List, with the options separated by commas (or semicolons, depending on your settings). The options: New, Waiting for customer, Confirmed, Rescheduled, Canceled, No-show, Completed.

5. Create drop-down lists for Source and Consent to contact

   Source (column B): Phone, WhatsApp, Website/email, Walk-in, Other. Consent to contact (column K): Yes, No. Then nobody types “whatsap” or “yeah sure,” and filters and counts stay correct.

6. Make sure dates are real dates

   Always type dates in columns A and J the same way: month, day, year, as in 10/16/2026 for October 16. A date the program recognizes is right-aligned in the cell by default. Only then do sorting and counting by date work.

7. Turn on a filter

   Google Sheets: Data → Create a filter. Excel: Data → Filter. Sort the Follow-up date column in ascending order, so the oldest date is at the top. Under Status, uncheck Completed and Canceled, and you see only what is still open.

8. Count what needs following up today

   On a second tab (for example, Overview), enter the formula below. It counts the open rows with a follow-up date of today or earlier. In the download this count is already set up.

9. Share the list only with those who need it

   Google Sheets: Share → add your colleagues' email addresses → Editor for those who update the list, Viewer for those who only look. Leave General access set to Restricted, not “Anyone with the link.” Excel: save the file in OneDrive or SharePoint and share it with specific people. Remove someone's access as soon as they leave.

What each status means

Booking and confirming without double bookings

Double bookings nearly always happen the same way: someone says yes before checking, or checks an overview that has not been updated. Three habits prevent most of them:

1. Check first, then commit. Never confirm a time from memory. Look in the calendar, even if you think the slot is free.
2. Record first, then confirm. Put the appointment in the calendar before you send the customer the confirmation. Then a colleague can no longer give that time away.
3. Know your capacity. A time slot is not just a time, but also a table, a mechanic with a lift or a chair with a staff member. Allow for the length of the service, plus some slack in between.

“Let me check” is a perfectly good answer, as long as there is a follow-up. Set the request to New with a follow-up date of today, and tell the customer when they will get an answer.

Checklist: booking and confirming

• The service and how long it takes are clear, and you know who will do it.
• The time has been checked in the calendar, including the table, lift, chair or practitioner.
• The appointment is in the calendar before the customer gets the confirmation.
• The row in the list is updated: confirmed time, status Confirmed, person responsible.
• The confirmation states the day, date, time and address, what the customer needs to bring and how they can reschedule or cancel.
• You have asked whether you may send one reminder, and the answer is recorded under Consent to contact.
• When in doubt (a large group, an unknown duration, a special request), consult first and only then confirm.

Rescheduling, canceling and no-shows

Appointments change, and that is normal. Above all, the system must make sure that a freed-up time really does become available, and that the customer knows where they stand.

Rescheduling

1. Set the status to Rescheduled and note the old time under Notes.
2. Release the old time in the calendar right away.
3. Suggest two specific times instead of asking “What time works for you?” That saves messages going back and forth.
4. If the customer chooses one: new time in the calendar, status Confirmed, fill in the new confirmed time and send a new confirmation.
5. No response: set a follow-up date and check back once. If you still hear nothing, close the row as Completed with a “no response” note.

Canceling

With a cancellation, three things matter: the customer gets confirmation that their message has arrived, the time becomes free in the calendar, and the row is closed with status Canceled and an empty follow-up date. Do not press for the reason if the customer does not give it themselves.

No-shows

A customer who does not show up costs you a time slot. Even so, an angry response rarely helps: often something came up, or the appointment was not clear enough. Start in a friendly way and offer a new appointment.

Decide your own policy in advance and mention it when booking, not afterward. What fits depends on your business. Examples of choices businesses make:

• After the first time: only a friendly message offering a new appointment.
• After a second time: ask the customer to confirm the day before that they are coming.
• For long treatments or jobs: ask for a deposit in advance, in a safe way and without payment details in the list.
• At a restaurant: release a table after a fixed waiting time, if you said so when taking the reservation.

Under Notes, record factually how often it has happened (for example, “first no-show”), worded so that you could let the customer read it.

Reminding and following up, only with consent

A reminder helps a customer who is busy. Three reminders feel pushy. So work with three rules:

1. Only with consent. When confirming, ask whether you may send a reminder and record the answer under Consent to contact. If it says No or nothing at all, you do not send a reminder.
2. One reminder. Usually the day before, or on the last business day before if you are closed on the weekend. Not again every day.
3. An easy way out. In every follow-up message, say how the customer can let you know they do not want any more messages, and stick to it. Then set Consent to contact to No right away.

Following up after a request

Not every request turns into an appointment right away. Someone asks about the price, wants to talk it over at home or first needs to see their schedule. Without follow-up you often hear nothing more. With one short, agreed follow-up you usually get an answer, or at least you know it is not going to happen.

When a request is unusual: pass it to a person

A standard way of working works for ordinary appointments. Some requests do not fit it. Decide in advance which ones those are and who decides in that case, so nobody has to guess. Examples:

• A large group, a private party or a reservation outside business hours.
• A job nobody knows the length of, such as a fault that first needs to be investigated.
• A special request: a treatment you rarely do, or a question about a price agreement.
• A complaint, or a customer who is angry about an earlier appointment.
• Any question about health, medication or an urgent situation. Front desk staff do not give advice on that; the question goes to the doctor or practitioner. In an emergency, refer the person to the emergency room or the emergency number.

The approach is always the same: say honestly that you will check, say when the customer will get an answer, and put the request in the list with the decision-maker as the person responsible and a follow-up date of today or tomorrow.

The daily routine and who does what

A list only works if someone looks at it every day. Plan a fixed ten-minute slot for it, for example right after opening or at the end of the afternoon. The time matters less than the regularity.

1. Look at the count (1 minute)

   How many follow-ups are due today or earlier? At the end of the routine that number is zero, or every open row has been given a new follow-up date.

2. Handle new requests (3 minutes)

   Filter by status New. Check availability, propose a time or confirm, and update the row.

3. Send reminders for tomorrow (2 minutes)

   Find tomorrow's confirmed appointments with Consent to contact set to Yes. Send each customer one reminder and note under Next action that it has been done.

4. Wrap up yesterday (2 minutes)

   Set yesterday's appointments to Completed or No-show and clear the follow-up date where nothing more needs to happen. For a no-show, send the friendly message.

5. Check the open rows (2 minutes)

   Does every open row have a person responsible and a follow-up date? Fill in what is missing. Anything you cannot solve yourself goes to the decision-maker.

Mini work instruction: who does what

In a small team one person sometimes has several roles, as long as each role has a name and a backup. Also agree on the following with the whole team:

• A request you take is yours until you assign it to someone else in the list.
• Nobody confirms a time without checking the calendar.
• An open row always has a follow-up date.
• No health or payment details in the list, the calendar or WhatsApp labels.

Example: a week in a garage's list

In lesson 5 you turn that weekly look into a regular measurement: how many appointment requests became an appointment and how much follow-up was still open at the end of the week.

Checklist for this lesson

Downloads for this lesson

Test your knowledge

What to do now

• This week, set up the appointments and follow-up list and add all the open requests that are still sitting in WhatsApp, notebooks or someone's head.
• With your team, choose a fixed time for the ten-minute daily routine and appoint a daily coordinator and a backup.
• Adapt the messages from this lesson and save them as quick replies in WhatsApp Business.
• Then continue with lesson 5: measure and improve, where you track every week how many requests become an appointment and how much follow-up is still open.