Personalized Hotel VIP Reward Emails: Salesforce, Gemini AI & Brevo

This n8n workflow monitors Salesforce Guest__c objects for checkout updates, fetching detailed spend data on amenities like room service, minibar, laundry, late checkout, extra bed, and airport transfers. It calculates total spend and filters for VIP guests exceeding $50. AI (Google Vertex AI/Gemini via LangChain) analyzes unused services, randomly selects one, and crafts a realistic, personalized promo offer, such as 'Free late checkout on your next stay'. The output is parsed into structured JSON for clean integration.

The workflow then delivers a branded HTML email through Brevo with a dynamic subject like 'John, We Have Something Special for Your Next Stay' and the tailored offer. This ensures offers feel exclusive and relevant, avoiding generic discounts.

Benefits include increased guest loyalty, higher repeat bookings, and efficient automation of personalized marketing. Ideal for hotels aiming to reward high-spenders without manual effort. Use cases: Post-checkout retention campaigns, upsell prevention via free perks, CRM-driven personalization at scale.