Web form to search people in Google Sheets and confirm appointments via WhatsApp
Say goodbye to phone tag and endless emails. One form. One click. WhatsApp does the rest, so you get more time (and sanity).
Chasing after clients to confirm appointments by manually searching names in your spreadsheets, hunting down phone numbers, and individually sending WhatsApp messages is not just tedious—it’s an operational bottleneck. Each step piles onto your daily workload, prone to error and repetition, causing missed confirmations, wasted slots, and lost revenue. Without automation, this task drains time, limits your ability to scale, and risks damaging your professional image when confirmations slip through the cracks.
This Botize formula gives you a frictionless transformation: every time someone fills out a simple web form with their name and surname, the automation instantly finds them in your Google Sheets, extracts their WhatsApp number, sends an interactive message with buttons to confirm or reschedule, and records their response right back into the sheet. No more manual lookups, copy-paste loops, or message tracking—just instant, seamless appointment management. And the best part? You keep control over when it runs, can filter for specific clients, and tailor the frequency to fit your workflow.
Ready to cut the chaos and keep your appointments on track? Follow the step-by-step instructions to get this formula up and running, or jump right in with the ready-to-use template on Botize. Automation is just a click away—your clients and your calendar will thank you!
Start using this automation
It's ready to go. Choose how to set it up in your account.
Open it in the Botize editor
Load it into your account and customize it in the visual panel, with everything in view.
Open it in Claude or ChatGPT
Copy this and paste it into ChatGPT or Claude (with the free Botize connector): it'll load the automation, tailor it with you and save it to your account.
Not connected yet? Claude guide · ChatGPT guide
Automated Appointments: Confirm and Manage via WhatsApp, Instantly
Fill in a simple web form with a name and last name. Our system looks up the person in your Google Sheet, sends them a friendly WhatsApp message with two buttons—confirm or reschedule—and saves their answer automatically. No code, no headaches, just clarity.
| Manual | Botize | |
|---|---|---|
| Checking your sheet for the person | 2 minutes | 0 Minutes |
| Copying number & writing WhatsApp message | 3 minutes | 0 Minutes |
| Waiting for reply, updating response | 5 minutes | 0 Minutes |
| Total | 10 minutes per appointment | 0 Minutes |
Looking to make your appointment confirmations as easy as breathing? You’re in the right place. No more copy-pasting or chasing people—let automation do the legwork.
Doctor’s Office
Patients get a WhatsApp message to confirm their visit. Click, confirm, schedule filled. No calls, no fuss.
Faster Replies
Get confirmations in seconds, not hours—or days.
Zero Manual Work
The days of hunting down responses are over. Let it flow.
Real Conversations
Reach people where they actually reply: WhatsApp.
Consultant Appointments
You keep your client database in Google Sheets. Each time someone fills the form, you get real-time confirmations and less back-and-forth.
⌾︎ You run appointments and are tired of chasing confirmations.
⌾︎ You want to look professional without hiring another assistant.
✕ You don’t use WhatsApp for your business (yet).
✕ You need complex forms or custom workflows with 15+ steps.
✓ Change WhatsApp message text (make it friendly or formal).
✓ Add/change buttons for different booking actions (like 'Cancel' or 'More Info').
✓ Integrate your own Google Sheet or use extra columns for more context.
This automation generates a web form with the fields Name and Last Name. When submitted, it searches for the person in a Google Sheets file, retrieves their phone number, and sends them a WhatsApp message with buttons to confirm the appointment or request a new date. The selected option is automatically saved back into the same sheet. The Google Sheets file must have the following columns in the first row: Name, Last Name, and Phone. WhatsApp communication is handled through Whapi (an unofficial WhatsApp API), which must be configured beforehand.
Related automations
Other ready-to-use automations you may find useful.
Apps in this automation
These are the apps this automation connects. Open any of them to discover everything you can automate with it.
Actions used
These are the exact steps this automation runs. Each action can be reused in other automations.