Intelligent guest registration system that parses form submissions, deduplicates against Airtable CRM, creates enriched records with calculated tags, and fires targeted alerts for allergies, VIP status, and large parties — ensuring no guest detail is missed and staff receives actionable real-time notifications.
n8n · workflow canvasproduction build
Context
Event and hospitality teams manually processed guest registrations, struggled with duplicate entries, missed critical details like allergies or VIP status, and lacked automated notifications for special handling cases like large parties or 5-star guests.
Approach
Built two interconnected n8n sub-workflows — the main pipeline parses and normalizes form data, checks for duplicate emails in Airtable, creates new guest records with computed classification tags, runs three parallel conditional checks (allergies, 5-star, party size 8+), triggers targeted Gmail and Slack alerts, backs up data to Google Sheets, and logs interactions. A global error handler monitors all stages.
