This n8n template implements a Calendly Booking & Cancellation Automation Hub that automatically processes Calendly web…
This n8n template implements a Calendly Booking & Cancellation Automation Hub that automatically processes Calendly webhook events, logs data to Google Sheets, and sends intelligent Slack notifications Who's it for This template is designed for professionals, teams, and businesses who use Calendly for scheduling and want to automate their booking management workflow. It's perfect for: Sales teams** who need instant notifications about new bookings and cancellations Service providers** (consultants, coaches, therapists) who want to track appointments automatically Businesses** that need centralized logging of all booking events for analytics Teams** that want smart categorization of urgent bookings and last-minute cancellations Organizations** requiring automated follow-up workflows based on booking status How it works / What it does This workflow creates a comprehensive Calendly automation system that automatically processes booking confirmations and cancellations. The system: Listens for Calendly events via webhook trigger for: invitee.created - New booking confirmations invitee.canceled - Booking cancellations Routes events intelligently using a Switch node to separate booking and cancellation processing For Bookings: Extracts and transforms all booking data (invitee info, event details, timing, location, guests) Calculates computed fields (formatted dates/times, duration, days until event, urgency flags) Detects urgent bookings (same-day or next-day appointments) for priority handling Logs complete booking information to Google Sheets Sends formatted Slack notifications with meeting links, reschedule/cancel options For Cancellations: Extracts cancellation details (reason, who canceled, timing) Categorizes cancellations into three types: Last Minute (within 24 hours of event) - High priority follow-up Standard (upcoming events) - Normal priority Past Event (already occurred) - Low priority Calculates hours before event for timing analysis Logs cancellation data to Google Sheets Sends categorized Slack alerts with follow-up priority indicators Data Management: Stores all bookings in a dedicated Google Sheets tab Stores all cancellations in a separate Google Sheets tab Maintains complete event history for analytics and reporting How to set up 1. Configure Calendly Webhook Trigger Go to developer.calendly.com Create an OAuth2 application or use Personal Access Token In n8n, add Calendly OAuth2 credentials The workflow automatically registers webhooks for invitee.created and invitee.canceled events Ensure your Calendly account has the necessary permissions 2. Set up Google Sheets Create a Google Sheets spreadsheet with two tabs: Bookings - For logging new booking confirmations Cancellations - For logging cancelled appointments Configure Google Sheets OAuth2 credentials in n8n Update the document ID in both Google Sheets nodes: "Log to Bookings Sheet1" node "Log to Cancellations Sheet" node The workflow uses auto-mapping, so ensure your sheet headers match the data fields 3. Configure Slack Notifications Create a Slack app at api.slack.com Add Bot Token Scopes: chat:write, channels:read Install the app to your workspace Add Slack OAuth2 credentials in n8n Update the channel name in both Slack nodes (default: "general") Customize notification messages if needed 4. Test the Workflow Activate the workflow in n8n Create a test booking in Calendly Verify that: Data appears in Google Sheets Slack notification is received All fields are correctly populated Test cancellation flow by canceling a booking 5. Customize (Optional) Adjust urgency detection logic (currently same-day or next-day) Modify Slack notification formatting Add email notifications using Email nodes Integrate with CRM systems (HubSpot, Salesforce, etc.) Add follow-up email automation Requirements Calendly account** with active scheduling links Google Sheets account** with a spreadsheet set up Slack workspace** with app installation permissions n8n instance** (self-hosted or cloud) OAuth2 credentials** for Calendly, Google Sheets, and Slack How to customize the workflow Modify Urgency Detection Edit the "Check Urgency" IF node to change what constitutes an urgent booking Currently flags same-day or next-day bookings Adjust the days_until_event threshold as needed Enhance Slack Notifications Customize message formatting in Slack nodes Add emoji or formatting to match your team's style Include additional fields from the booking data Add @mentions for urgent bookings Add Email Notifications Insert Email nodes after Slack notifications Send confirmation emails to invitees Notify team members via email Create email templates for different event types Integrate with CRM Add HTTP Request nodes to sync bookings to your CRM Update contact records when bookings are created Create opportunities or deals from booking data Sync cancellation reasons for analysis Add Analytics Create additional Google Sheets tabs for analytics Use formulas to calculate booking rates, cancellation rates Track popular time slots and event types Monitor team member availability Customize Data Fields Modify the "Transform Booking Data" and "Transform Cancellation Data" Set nodes Add custom fields based on your Calendly form questions Extract additional metadata from the webhook payload Calculate business-specific metrics Key Features Automatic event processing** - No manual intervention required Smart urgency detection** - Identifies same-day and next-day bookings automatically Intelligent cancellation categorization** - Classifies cancellations by timing and priority Comprehensive data extraction** - Captures all booking details including guests, questions, and metadata Dual logging system** - Separate sheets for bookings and cancellations Rich Slack notifications** - Formatted messages with meeting links and action buttons Computed fields** - Automatically calculates duration, days until event, formatted dates/times Error handling** - Nodes configured with continueRegularOutput to prevent workflow failures Scalable architecture** - Handles high-volume booking scenarios Use Cases Sales team automation** - Instant notifications when prospects book demos Consultant scheduling** - Track all client appointments in one place Service business management** - Monitor bookings and cancellations for service providers Team calendar coordination** - Keep team members informed about schedule changes Analytics and reporting** - Build dashboards from logged booking data Customer relationship management** - Sync booking data with CRM systems Follow-up automation** - Trigger email sequences based on booking status Resource planning** - Analyze booking patterns to optimize scheduling Data Fields Captured Booking Data Event ID, invitee name, email, first name Event name, start/end times (ISO format) Formatted date and time (human-readable) Timezone, duration in minutes Meeting URL (Google Meet, Zoom, etc.) Reschedule and cancel URLs Location type (virtual, in-person, etc.) Guest count and guest emails Questions and answers (JSON format) Days until event, same-day flag Urgency status and label Processing timestamp Cancellation Data Event ID, invitee name, email Original scheduled date and time Cancellation reason Who canceled (invitee/host) Canceler type Hours before event Last-minute flag (< 24 hours) Cancellation category and priority Cancellation timestamp Workflow Architecture The workflow uses a routing pattern to handle different event types: Calendly Webhook Trigger → Receives all events Route Event Type (Switch) → Separates bookings from cancellations Parallel Processing → Each path processes independently Data Transformation → Set nodes extract and format data Intelligent Routing → IF/Switch nodes categorize by urgency/type Data Logging → Google Sheets stores all events Notifications → Slack alerts team members Example Scenarios Scenario 1: New Booking Customer books a 30-minute consultation for tomorrow Workflow detects it's a next-day booking (urgent) Data logged to "Bookings" sheet with urgency flag Slack notification sent with 🚨 URGENT label Team member receives instant alert Scenario 2: Last-Minute Cancellation Customer cancels meeting 2 hours before scheduled time Workflow categorizes as "last-minute" cancellation Data logged to "Cancellations" sheet with high priority Slack alert sent with 🚨 LAST MINUTE label Team can immediately follow up or fill the slot Scenario 3: Standard Cancellation Customer cancels meeting 3 days in advance Workflow categorizes as "standard" cancellation Data logged with normal priority Slack notification sent with standard formatting Team can plan accordingly This template transforms your Calendly scheduling into a fully automated booking management system, ensuring no booking goes unnoticed and providing valuable insights into your scheduling patterns and customer behavior. An n8n automation workflow template by Omer Fayyaz.
Omer Fayyaz
web
free
Others in the same category, ranked by how often they are opened.
