Hospitality guest intake workflow that deduplicates submissions, enriches new guest records in Airtable, sends personalized allergy and VIP notifications, and backs everything up to Google Sheets with admin error monitoring.
n8n · workflow canvasproduction build
Context
Event and hospitality teams needed a dependable way to capture guest details, avoid duplicate CRM records, and trigger the right follow-up for allergies, VIPs, and large parties without manual sorting.
Approach
Built two connected n8n workflows: the main flow parses and normalizes guest submissions, checks Airtable for duplicates, creates and logs new guest records, backs data up to Sheets, and routes condition-based notifications for allergies, 5-star guests, and large parties; a separate error monitor emails the admin on failures.