Sports Bar Booking System - n8n Workflow Architecture
Trigger
Transform/Process
API Action
Output/Notification
Integrated Systems
SimplyBook.me
Booking Platform & Payment Processing
501 FUN Hub
Darts System Management
Lightspeed K-Series
POS System
Twilio
SMS/WhatsApp
Email Service
Customer & Staff Notifications
Google Sheets
Customer Database & Analytics
1. Core Booking & System Synchronization Workflow
Triggers when a new booking is confirmed in SimplyBook.me after successful deposit payment. Syncs booking data across all systems.
SimplyBook.me
Webhook
→
Webhook
New Booking Confirmed
Extract & Validate
Booking Data
→
Booking Data
Code Node
501 Hub API
Create Session
→
Create Session
HTTP Request
Lightspeed POS
Create Booking
→
Create Booking
HTTP Request
Store in
Google Sheets
Google Sheets
Customer Database
2. Customer Booking Confirmation Workflow
Sends immediate confirmation to customers via Email and SMS/WhatsApp after booking is synchronized.
Booking Sync
Complete
→
Complete
From Workflow 1
Format
Confirmation
→
Confirmation
Code Node
Send Email
Confirmation
→
Confirmation
Email Node
Send SMS/
WhatsApp
Twilio Node
3. Pre-Booking Reminder & Upsell Workflow
Runs daily to check bookings 24 hours ahead and sends reminders with upsell opportunities.
Schedule
Trigger
→
Trigger
Daily at 10 AM
Query Tomorrow's
Bookings
→
Bookings
Google Sheets
Generate Upsell
Offers
→
Offers
Code Node
Send Reminder
+ Upsell
+ Upsell
Twilio + Email
4. Internal Staff Notification Workflow
Notifies staff of new bookings, flagged bookings, and sends daily booking digests.
Multiple
Triggers
→
Triggers
New Booking / Schedule
Check Booking
Type & Flags
→
Type & Flags
IF Node
Email Staff
Alert
→
Alert
Email Node
SMS Alert
(if urgent)
(if urgent)
Twilio Node
5. Customer Loyalty & Recognition Workflow
Identifies returning customers and triggers loyalty rewards or personalized communications.
New Booking
Confirmed
→
Confirmed
From Workflow 1
Check Customer
History
→
History
Google Sheets
Calculate
Loyalty Status
→
Loyalty Status
Code Node
Send Loyalty
Reward
Reward
Email/SMS
6. Monthly Marketing Campaign Workflow
Manual or scheduled workflow for sending targeted marketing campaigns to customer segments.
Manual Trigger
or Schedule
→
or Schedule
Monthly/Event-based
Segment
Customers
→
Customers
Google Sheets Query
Personalize
Content
→
Content
Code Node
Batch Send
Campaign
Campaign
Email + Twilio
