Answer hotel guest messages with GPT-4o mini, Slack, and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 11 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects OpenAI Chat Model, Slack and Google Sheets.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Normalize Payload (Code): runs custom JavaScript code
- Guest Assistant Agent (AI Agent): runs an AI agent, with model: GPT 4o mini; output parser: Reply Structure Parser
- Needs Human? (If): checks a condition and branches into true / false
- Notify Front Desk (Slack): uses Slack
- Route By Channel (Switch): routes items into 2 branches
- Send a message (Slack): uses Slack
- Log Conversation (Google Sheets): append
- Respond to Guest Gateway (Respond to Webhook): sends the response back to the webhook caller
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Guest Assistant Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Guest Assistant Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook - Webhook
n8n-nodes-base.webhook
From the author
Quick Overview This workflow receives guest messages via a webhook, uses OpenAI (GPT-4o-mini) to generate multilingual hotel support replies with an escalation flag, notifies the front desk in Slack when needed, logs the interaction to Google Sheets, and…