Personalized hotel reward emails for high-spenders with Salesforce, Gemini AI & Brevo
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs on Salesforce events (custom object updated). Along the way it connects Salesforce, Google Vertex Chat Model and Brevo.
How it runs
Trigger: On Salesforce events (custom object updated).
- Extract Checkout information (Salesforce): get many (custom object)
- Look For VIP Clients (Code): runs custom JavaScript code
- Check the threshold exceedings (If): checks a condition and branches into true / false
- Basic LLM Chain: sends a prompt to an LLM, with model: Give Away Personalised Offers; output parser: Structured Output Parser
- Send offer via email (Brevo): uses Brevo
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Salesforce Trigger
n8n-nodes-base.salesforceTrigger - Salesforce
n8n-nodes-base.salesforce - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Vertex Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleVertex - Brevo
n8n-nodes-base.sendInBlue
From the author
This n8n workflow automatically detects high‑spending hotel guests after checkout and emails them a personalized, one‑time reward offer. --- 🔧 What it does - Watches Salesforce Guestc custom object for checkout updates. - Pulls guest spend data on optional…