Personalized hotel reward emails for high-spenders with Salesforce, Gemini AI & Brevo
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 updat...
Template notes
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 paid amenities: - Room Service - Minibar - Laundry - Late Checkout - Extra Bed - Airport Transfer - Calculates total spend to identify VIP guests (≥ $50). - Uses AI to: - Spot unused services. - Randomly pick one unused service. - Generate a realistic, short promo like: "Free late checkout on your next stay" - Parses AI output into JSON. - Sends a polished HTML email to the guest with their personalized offer.
---
📦 Key nodes - Salesforce Trigger → monitors new checkouts. - Salesforce → fetches detailed spend data. - Function → sums up total amenity spend. - IF → filters for VIP guests. - LangChain LLM + Google Vertex AI → drafts the offer text. - Structured Output Parser → cleans AI output. - Brevo → delivers branded email.
---
📊 Example output > Subject: John, We Have Something Special for Your Next Stay > Offer in email: Enjoy a complimentary minibar selection on your next stay.
---