Short-Term Rental Guest Messaging & Cleaning Tasks (n8n)

Automate Short-Term Rental guest messaging and cleaning checklists—end to end

This n8n workflow automatically captures short-term rental bookings via webhook, records them in Google Sheets, and sends timed guest emails through Gmail using an OpenAI (Deepseek) property playbook. On checkout, it also creates cleaning tasks in Google Sheets and alerts both hosts and cleaners via Telegram and email.

What this workflow does

• Receives new bookings through a webhook, validates that required fields (guest, property, dates) are present and consistent.
• Rejects invalid bookings by sending an alert to the host in Telegram and an email in Gmail that includes the rejected payload.
• Registers valid stays by generating a booking ID, normalizing fields, appending the booking to the Google Sheets “Bookings” tab, and notifying the host in Telegram.
• Runs daily (scheduled or on-demand) to scan “Bookings” and select confirmed stays due for:
  • Check-in message (tomorrow)
  • Checkout message (today)
  • Review request (two days after checkout)
• Drafts and sends guest emails using an OpenAI (Deepseek) agent plus a Google Sheets playbook tool to generate one plain-text message per booking, then logs it to “GuestLog”, emails the guest via Gmail, and updates the host via Telegram.
• Creates cleaning tasks on checkout-day in “CleaningTasks”; if an address is present, it emails the cleaner and alerts the host in Telegram.

Use cases

• Send consistent check-in, checkout, and review-request messaging for each confirmed short-term rental booking.
• Automatically generate cleaner assignments and cleaning tasks from checkout dates.
• Provide operational visibility to hosts via Telegram notifications when messages send or payloads fail validation.

Technical details

• n8n nodes/actions: if, set, code, webhook, gmail, telegram
• Data storage: Google Sheets tabs: “Bookings”, “GuestLog”, “CleaningTasks”
• AI drafting: OpenAI (Deepseek) agent with a Google Sheets playbook tool