Calendly Booking and Cancellation Tracker with Google Sheets & Slack - n8n Workflow

Sales managers needing real-time visibility into booked demos.
Customer Success teams tracking rescheduling trends.
Operations specialists who need reliable logging of scheduling events.
Users looking for advanced n8n templates for scheduling automation.

• Anyone wanting a robust, reliable n8n node-based solution for Calendly integration.

Managing scheduled events often requires real-time data tracking and immediate team communication. This sophisticated n8n workflow addresses this by providing a complete automation hub for Calendly events. It solves the problem of manual data entry and delayed notifications.

When a new meeting is booked or cancelled in Calendly, this n8n automation instantly processes the data, calculates urgency (such as 'last-minute' cancellations or 'urgent' same-day bookings), logs all necessary details to dedicated Google Sheets tabs, and sends context-rich notifications to Slack. This specific n8n workflow ensures your team is always informed, allowing for quicker follow-ups and better resource allocation. It utilizes powerful n8n node logic, including complex expressions for date manipulation, making it one of the most effective n8n templates for scheduling.

The entire process is initiated by a specific n8n trigger. The Calendly Webhook Trigger is set to listen for both invitee.created (new bookings) and invitee.canceled (cancellations).

1. Trigger and Routing: The Calendly n8n trigger captures the event payload. The 'Route Event Type' n8n node then examines the event type to branch the workflow into two distinct paths: Booking or Cancellation.


2. Booking Processing: If it's a new booking, the 'Transform Booking Data' n8n node extracts critical details (like attendee name, meeting URL, duration) and computes metrics (like days until the event). The 'Check Urgency' node uses conditional logic to determine if the booking is urgent (same-day or next-day). The data is labeled ('Urgent' or 'Normal') and then merged.


3. Booking Logging & Notification: The merged booking data is sent to the 'Log to Bookings Sheet' n8n node, appending a new row in Google Sheets. Subsequently, the 'Slack Booking Notification' n8n node sends a formatted message to Slack, complete with urgency labels and meeting links.


4. Cancellation Processing: If the event is a cancellation, the 'Transform Cancellation Data' n8n node calculates how many hours before the original start time the cancellation occurred, labeling it 'Last Minute' if under 24 hours. The 'Categorize Cancellation' n8n node routes the event based on this timing.


5. Cancellation Logging & Notification: The labeled cancellation data is merged, logged to the dedicated 'Cancellations Sheet' using a Google Sheets n8n node, and finally, the 'Slack Cancellation Alert' n8n node sends a detailed alert to Slack, indicating the follow-up priority.

To deploy this comprehensive n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Calendly Setup (n8n trigger): Edit the 'Calendly Webhook Trigger1' n8n node. You must connect your Calendly OAuth2 credentials, ensuring you have the necessary scopes configured in your Calendly developer account (as detailed in the sticky note).


3. Google Sheets Setup: Create a new Google Spreadsheet with two tabs: Bookings and Cancellations. Connect your Google Sheets OAuth2 credentials to both 'Log to Bookings Sheet1' and 'Log to Cancellations Sheet' n8n node instances, selecting the correct Spreadsheet ID and tab names.


4. Slack Setup: Connect your Slack API credentials to both Slack notification n8n node instances. Configure the target channel (e.g., #general) where notifications should be sent.


5. Activate: Save and activate the n8n workflow. The Calendly n8n trigger will now automatically register the necessary webhooks with Calendly.

Calendly Webhook Trigger (Calendly Webhook Trigger1): This specialized n8n trigger initiates the entire process upon receiving events from Calendly, configured to monitor invitee.created and invitee.canceled event types.
Switch (Route Event Type): A core logic n8n node that routes the workflow execution path based on the incoming event type ($json.event).
Set (Transform Booking Data / Transform Cancellation Data): These crucial n8n node instances extract raw data and use JavaScript expressions (Jinja2) to calculate new fields like formatteddate, durationminutes, and islastminute. This data preparation is vital for downstream logging and notifications.
If (Check Urgency): This conditional n8n node checks if a booking is urgent (same day or next day), enabling the workflow to apply priority tagging.
Google Sheets (Log to Bookings Sheet1 / Log to Cancellations Sheet): These n8n node instances handle persistent storage, appending enriched event data to the respective tabs in the specified Google Sheet document.
Slack (Slack Booking Notification / Slack Cancellation Alert): These n8n node instances generate and dispatch highly formatted, markdown-based notifications to Slack, clearly indicating urgency or cancellation reasons, leveraging the labels created earlier in the n8n workflow.