Back to work
n8nCase study

Guest Relationship Automation

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
Guest Relationship Automation workflow

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.

Architecture

  1. Form submission
  2. parse + normalize
  3. Airtable duplicate check
  4. Duplicate: log duplicate + Gmail admin notice
New guest
  1. calculate tags
  2. Airtable create record
  3. log interaction
  4. Sheets backup
  5. allergies
  6. Gmail + Slack
  1. 5-star
  2. Slack celebration
  1. party 8+
  2. Gmail event lead
  3. Error Trigger
  4. Gmail admin error alert

Results

~3 hrs/weekGuest intake time saved
EliminatedDuplicate CRM records
0%Allergy/VIP alerts missed