How to Reduce Restaurant No-Shows by 75% with Automated Reminders

The moment someone makes a reservation, they should receive a text. Not an email—a text. Texts have a 98% open rate. Emails have 20%. This is your first automation, and it costs nothing if you're already using OpenTable.

In OpenTable: Go to Settings → Communications → Guest confirmations. Enable SMS confirmations. Edit the default message to this:

"Hi [Name]! Your reservation at [Restaurant] is confirmed for [Date] at [Time] for [Party size]. Reply CANCEL to cancel or call us at [number]. We can't wait to see you!"

That's it. This message goes out automatically every single time someone books. You'll see an immediate spike in confirmations—people appreciate the instant reassurance, and you get their phone number in your system.

This is the most important message you'll send. It goes out exactly 48 hours before the reservation. Why 48 hours? Because it's far enough away that people won't ignore it, but close enough that they'll remember to show up. And crucially, it gives people time to cancel properly instead of ghosting.

The message must include a YES/NO reply mechanic:

"Reminder: You have a reservation at [Restaurant] this [Day] at [Time] for [Party size]. Please reply: YES to confirm | NO to cancel. If we don't hear from you by [24 hours before], your reservation may be released."

The YES/NO mechanic is key. It gives wavering guests an easy, guilt-free exit. Instead of ghosting, they reply NO. You immediately fill that slot from your waitlist. Everyone wins.

In OpenTable: Same location—Settings → Communications. Enable the 48-hour reminder and customize the message above.

Send a final message 2–3 hours before the reservation. This is NOT a reminder—it's an excitement builder. It makes guests feel remembered and valued. It dramatically reduces "running late" no-shows.

"Can't wait to see you tonight, [Name]! A few things: we're at [address], parking is [where]. If you're running late, call us at [number]—we'll hold your table 15 minutes. See you at [time]!"

This message does three things:

• Confirms the reservation one final time (reducing second-guessing)
• Provides practical details (address, parking) so they don't cancel last-minute due to logistics confusion
• Opens a communication channel for people running late (instead of ghosting, they call)

You can set this up in OpenTable directly, or use Zapier + Twilio for more customization.

No-show prevention only works if you can fill the gaps when people do cancel. This is where your 48-hour reminder shines—people reply NO instead of ghosting, and you have 48 hours to fill the slot from your waitlist.

If you use OpenTable: Enable the native waitlist feature. OpenTable will automatically notify the first person on the waitlist the moment a reservation opens. This is built-in and requires zero extra setup.

If you use a simpler reservation system or Google Forms, set up this Zapier workflow:

• Trigger: When a reservation is cancelled (or when someone replies "NO" to the 48-hour reminder)
• Action 1: Find the earliest waitlist entry matching that date/time/party size
• Action 2: Send SMS: "A table just opened at [Restaurant] for [Date/Time] for [party size]. Reply YES to claim it—first reply gets it!"

For the DIY approach, create a Google Form for your waitlist:

• Form fields: Name, Phone, Email, Preferred Date/Time, Party Size
• Responses auto-populate a Google Sheet
• Zapier watches that sheet and triggers SMS when a table opens

Cost: $20/month (Zapier) + a few cents per text = one filled cancellation pays for itself.

If you take reservations by phone and record them in a spreadsheet or paper book, you can still automate everything. Here's the complete DIY system:

Step 1: Create a Google Form for Reservations

• Title: "[Restaurant] Reservation Form"
• Fields: Full Name, Phone Number, Email, Preferred Date, Preferred Time, Party Size, Special Requests
• Embed the form on your website or send the link via phone/text when customers call
• Form responses auto-populate a Google Sheet (Form → Link to Sheets → Create new sheet)

Step 2: Connect Google Sheets to Zapier

• In Zapier, create a new Zap
• Trigger: Google Sheets—"New row"
• Connect your form's Google Sheet
• Select the sheet and table
• This watches for new reservation rows automatically

Step 3: Set Up Twilio SMS in Zapier

• Action: Twilio—"Send SMS"
• Connect your Twilio account (free to create, add phone number)
• Create three Zaps:
  • Zap 1 (Immediate): When new row → immediately send confirmation text
  • Zap 2 (48 hours before): When new row → wait 48 hours → send YES/NO reminder
  • Zap 3 (2 hours before): When new row → wait (reservation time - 2 hours) → send excitement text

Total cost: Zapier Starter $20/month + Twilio ~$0.0075/text = ~$25/month for 500 reminders. That's less than the cost of one no-show table.

For Friday/Saturday dinner service or special events, require a credit card to hold the reservation. This single change reduces no-shows to near zero for your most profitable shifts.

The message customers see at booking:

"To secure your table, we require a credit card on file. No charge unless you cancel within 24 hours of your reservation—in which case a $15/person late cancellation fee applies."

This policy does two things:

• Serious customers lock in their reservation (commitment device)
• People who aren't sure cancel 48 hours early (via your reminder), not 2 hours before service

In OpenTable: Settings → Prepayments & Deposits → Enable "Require CC hold." You can set different policies for different shifts:

• Weekday lunch: No CC hold required
• Weekday dinner: No CC hold required
• Friday/Saturday dinner: CC hold required ($15 cancellation fee if within 24h)
• Special events (Valentine's, Mother's Day, NYE): CC hold required ($25 cancellation fee)