Step by step
- Keep one customer per row with columns Phone, Name, Appointment Date and Appointment Time. Keep phone cells as text so Excel does not drop the leading zero.
- Open WhatsApp Web, click the Wassender dock (Alt + W) and choose New campaign → Spreadsheet. Upload the file and select Phone as the phone column.
- Paste the message below. Column names become variables: Appointment Date is [appointment_date].
- Preview each recipient, keep the default human pacing, and start. For a reminder every day, schedule the campaign for a fixed time (Unlimited).
- Replies such as “1” or “2” arrive in WhatsApp as usual; an Autopilot keyword rule can answer them automatically.
Sample spreadsheet
| Phone | Name | Appointment Date | Appointment Time |
|---|---|---|---|
| 12025550101 | Mona | 15 October 2026 | 10:00 AM |
| 12025550102 | Omar | 16 October 2026 | 2:30 PM |
Paste this message into the campaign:
Hi [name], your appointment is on *[appointment_date]* at *[appointment_time]*. Reply 1 to confirm or 2 to reschedule.
What customers receive
Mona receives “Hi Mona, your appointment is on 15 October 2026 at 10:00 AM…”, and Omar receives his own date and time, 16 October 2026 at 2:30 PM.