Automate hotel booking requests from Gmail to Google Sheets with GPT-5-mini
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 26 nodes and runs on Gmail events. Along the way it connects Google Sheets, Gmail, Guardrails and Google Gemini Chat Model and 1 more.
How it runs
Trigger: On Gmail events.
- Get many messages (1) (Gmail): get many
- Guardrails: uses Guardrails, with model: GEMINI 2.5 FLASH
- Configuration: User Settings (Edit Fields (Set)): sets or maps fields
- If: checks a condition and branches into true / false
- Filter: keeps only the items that match a condition
- Set Invalid Email Error (Edit Fields (Set)): sets or maps fields
- Check for Attachment (If): checks a condition and branches into true / false
- Log Invalid Email Error (Google Sheets): append
- Extract Attachment Data (Extract from File): extracts data from a file (pdf)
- OpenAI Model for Email Text (AI Agent): runs an AI agent, with model: CHAT GPT 5 mini
…plus 13 more steps. See the full node list below.
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 OpenAI Model for Email Text2 (v1.9), OpenAI Model for PDF (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
- Also check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll).
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) OpenAI Model for Email Text2 (v1.9), OpenAI Model for PDF (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - AI Agent
@n8n/n8n-nodes-langchain.agent - Guardrails
@n8n/n8n-nodes-langchain.guardrails - Filter
n8n-nodes-base.filter - Extract from File
n8n-nodes-base.extractFromFile - Gmail Trigger
n8n-nodes-base.gmailTrigger - Code
n8n-nodes-base.code - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Who’s it for This workflow is for hotel managers, travel agencies, and hospitality teams who receive booking requests via email. It eliminates the need for manual data entry by automatically parsing emails and attachments, assigning booking cases to the right…