Manage rental guest messaging and cleaning ops with Deepseek and Google Sheets

by Khaisa Studio ✓ · 2 views · created 2026-08-17 · Miscellaneous, AI Chatbot

What this workflow does

This AI workflow has 36 nodes and runs when an HTTP POST request hits its webhook URL (plus 3 other triggers). Along the way it connects Telegram, Gmail, Google Sheets and OpenAI Chat Model.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 3 other triggers).

1. Validate Booking (If): checks a condition and branches into true / false
2. Read Bookings (Google Sheets): read
3. Read Bookings for Digest (Google Sheets): read
4. Prepare Booking Record (Edit Fields (Set)): sets 12 fields: booking_id, received_at, guest_name…
5. Send Invalid Booking Alert to Telegram (Telegram): uses Telegram
6. Compute Due Actions (Code): runs custom JavaScript code
7. Compute Digest Stats (Code): runs custom JavaScript code
8. Append Booking to Bookings Sheet (Google Sheets): append
9. Send Invalid Booking Notice by Gmail (Gmail): send (message)
10. Collect Due Bookings (Code): runs custom JavaScript code

…plus 19 more steps. See the full node list below.

Services it uses

TelegramGmailGoogle SheetsOpenAI Chat Model

Before you upgrade to n8n 3.0

Nodes used (11)

• Webhookn8n-nodes-base.webhook
• Ifn8n-nodes-base.if
• Telegramn8n-nodes-base.telegram
• Gmailn8n-nodes-base.gmail
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• AI Agent@n8n/n8n-nodes-langchain.agent
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Google Sheets Tooln8n-nodes-base.googleSheetsTool

From the author

Quick overview This workflow captures short-term rental bookings via webhook, stores them in Google Sheets, drafts guest emails with a Deepseek AI agent using a Google Sheets playbook, sends messages through Gmail, creates checkout-day cleaning tasks, and…

View the original on n8n.io → Check your own copy