{"product_id":"short-term-rental-guest-messaging-cleaning-tasks-n8n","title":"Short-Term Rental Guest Messaging \u0026 Cleaning Tasks (n8n)","description":"\u003ch3\u003eAutomate Short-Term Rental guest messaging and cleaning checklists—end to end\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives new bookings\u003c\/strong\u003e through a \u003cem\u003ewebhook\u003c\/em\u003e, validates that required fields (guest, property, dates) are present and consistent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRejects invalid bookings\u003c\/strong\u003e by sending an alert to the host in \u003cstrong\u003eTelegram\u003c\/strong\u003e and an email in \u003cstrong\u003eGmail\u003c\/strong\u003e that includes the rejected payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRegisters valid stays\u003c\/strong\u003e by generating a booking ID, normalizing fields, appending the booking to the Google Sheets \u003cstrong\u003e“Bookings”\u003c\/strong\u003e tab, and notifying the host in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily (scheduled or on-demand)\u003c\/strong\u003e to scan “Bookings” and select confirmed stays due for:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eCheck-in message\u003c\/strong\u003e (tomorrow)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eCheckout message\u003c\/strong\u003e (today)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eReview request\u003c\/strong\u003e (two days after checkout)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts and sends guest emails\u003c\/strong\u003e using an \u003cstrong\u003eOpenAI (Deepseek) agent\u003c\/strong\u003e plus a \u003cstrong\u003eGoogle Sheets playbook tool\u003c\/strong\u003e to generate one plain-text message per booking, then logs it to \u003cstrong\u003e“GuestLog”\u003c\/strong\u003e, emails the guest via Gmail, and updates the host via Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates cleaning tasks on checkout-day\u003c\/strong\u003e in \u003cstrong\u003e“CleaningTasks”\u003c\/strong\u003e; if an address is present, it emails the cleaner and alerts the host in Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend consistent check-in, checkout, and review-request messaging for each confirmed short-term rental booking.\u003c\/li\u003e\n  \u003cli\u003eAutomatically generate cleaner assignments and cleaning tasks from checkout dates.\u003c\/li\u003e\n  \u003cli\u003eProvide operational visibility to hosts via Telegram notifications when messages send or payloads fail validation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/actions:\u003c\/strong\u003e if, set, code, webhook, gmail, telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e Google Sheets tabs: “Bookings”, “GuestLog”, “CleaningTasks”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI drafting:\u003c\/strong\u003e OpenAI (Deepseek) agent with a Google Sheets playbook tool\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865764454579,"sku":"N8N-18363","price":48.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/eTIZMwvGNT8GOkXBwnRjf_owAZDsfi.png?v=1787044502","url":"https:\/\/buyflowscripts.com\/products\/short-term-rental-guest-messaging-cleaning-tasks-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}