Send personalized hotel pre-arrival messages using OpenAI, Google Sheets and Slack
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Function (legacy), OpenAI (legacy). 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets and Slack.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Fetch Guest Profiles (Google Sheets): uses Google Sheets
- Alert on Workflow Failure (Slack): uses Slack
- Guest Exists? (If): checks a condition and branches into true / false
- Merge Returning Guest Data (Function): runs custom JavaScript (legacy Function node)
- Create First-Time Guest Profile (Function): runs custom JavaScript (legacy Function node)
- Save Updated Profile (Google Sheets): append or update
- Calculate Days Until Check-In (Function): runs custom JavaScript (legacy Function node)
- Within 2-Day Window? (If): checks a condition and branches into true / false
- Generate Personalized Welcome Message (OpenAI): uses OpenAI
- Check Message Generated (If): checks a condition and branches into true / false
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Function (legacy) in Merge Returning Guest Data, Create First-Time Guest Profile, Calculate Days Until Check-In: replace with Code node, mode 'Run Once for All Items'.
- OpenAI (legacy) in Generate Personalized Welcome Message: replace with OpenAI node (AI section).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Merge Returning Guest Data, Create First-Time Guest Profile, Calculate Days Until Check-In | Code node, mode 'Run Once for All Items' |
| OpenAI (legacy) Generate Personalized Welcome Message | OpenAI node (AI section) |
Nodes used (8)
- If
n8n-nodes-base.if - Function
n8n-nodes-base.function - OpenAI
n8n-nodes-base.openAi - Send Email
n8n-nodes-base.emailSend - Error Trigger
n8n-nodes-base.errorTrigger - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Slack
n8n-nodes-base.slack
From the author
Description This workflow automates a personalized pre-arrival guest experience for hotels by combining Google Sheets, OpenAI, Email, and Slack. It detects upcoming check-ins, maintains unified guest profiles for new and returning guests, and sends warm,…