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 Guest__c 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.

✨ Why it matters Rewarding guests who already spend boosts loyalty and repeat bookings — without generic discounts. The offer feels personal, relevant, and exclusive.