Can I change the 2-hour window?

Yes — edit the hoursUntil check in the "Filter Upcoming (2h)" code node.

Do I need a booking system integration?

No — this reads a plain Google Sheet, so it works with any booking flow that ends up adding a row there (manually, via Calendly, or a form).

HospitalityStructurally Validated

Reservation No-Show Reminder

Every hour, this automation checks your reservations sheet for bookings coming up in about 2 hours and sends a friendly SMS and email reminder — reducing no-shows without anyone on your team having to remember to call.

Automation flow

Step 1

Hourly Check

A schedule trigger reads your Reservations sheet every hour.

Step 2

Filter Upcoming

Reservations roughly 2 hours away that haven't been reminded are picked out.

Step 3

Send Reminders

An SMS and email go out to the guest.

Step 4

Mark Sent

The sheet is updated so the same reservation isn't reminded twice.

How it works

1Every hour, the workflow reads your Reservations sheet.
2Any reservation between 1.5 and 2.5 hours away (and not already reminded) triggers both an SMS and an email.
3The row is marked Reminder Sent = Yes so it won't fire twice.

Services used

Google SheetsTwilioGmail

What you'll need

An n8n Cloud or self-hosted account
A Google account (Sheets + Gmail)
A Twilio account (SMS reminders)

What's included

Works with any booking source that lands in a Sheet
Both SMS and email reminders included
Automatic dedupe — no repeat reminders
Adjustable reminder window

Estimate what this could save you

Times per week

Minutes each time

Your hourly value ($)

3.6 hours/month

≈ $108/month in your time

A rough estimate based on what you enter above — not a guarantee. Actual time saved depends on your process.

Works well with this automation

Post-Visit Review Request

Automatically asks customers for a Google or Yelp review 2 days after their visit, timed while the experience is still fresh.

$15

Ad Platform Lead Router

Meta/LinkedIn Lead Ads leads are instantly logged, auto-replied to, and pushed to sales on Slack.

$22

AI Customer Survey Insights Digest

Collects Google Forms survey responses as they arrive, then has AI write a weekly digest of sentiment, themes, and standout quotes.

$22

Save with the complete system: Real Estate, Hospitality & Events Bundle

Instead of buying separately: $177 — System: $79

View system

Questions about this template

$15one-time

Secure checkout via Polar. Delivered by email instantly.

Structurally validated: automatically checked for valid n8n format before every deploy.

Difficulty: Easy
Setup time: ~15 min
Integrations: 3
Node count: 6
Format: .json + guide