Cal Com Webhook Bookings To Data Table With Email Reminders

    What this workflow does

    The workflow contains these steps: Run Once to Create Bookings Table → Receive Cal.com Webhook → Check Reminders Every 5 Minutes → Booking Settings → Setup Run? → Create Bookings Table → From Webhook? → Sign Raw Body → Check Delivery → Delivery Accepted? → Answer Rejected or Ignored → Secret Missing? → Fail Run: Secret Missing → Find Bookings Table → Bookings Table Found? → Webhook Delivery? → Caller Waiting? → Report Missing Table → Fail Run: Table Missing → Cancellation? → Reschedule? → Mark Old Booking Rescheduled → Old Booking Marked? → Look Up Booking → Already Stored? → Answer Duplicate → Nothing Stored Yet? → Insert Booking Row → Row Stored? → Answer Stored → Report Store Failure → Fail Run: Booking Not Saved → Cancel Booking Row → Cancel Saved? → Answer Cancel → Load Upcoming Bookings → Pick Due Reminders → Loop Over Reminders → Claim Reminder → Reminder Claimed? → Send Reminder Email → Release Reminder.

    What you need

    • An n8n instance to import and run the workflow.
    • StickyNote access for the StickyNote steps listed in this workflow.
    • ManualTrigger access for the ManualTrigger steps listed in this workflow.
    • Webhook access for the Webhook steps listed in this workflow.
    • Schedule access for the Schedule steps listed in this workflow.
    • Set access for the Set steps listed in this workflow.
    • IF access for the IF steps listed in this workflow.
    • DataTable access for the DataTable steps listed in this workflow.
    • Crypto access for the Crypto steps listed in this workflow.
    • Code access for the Code steps listed in this workflow.
    • RespondToWebhook access for the RespondToWebhook steps listed in this workflow.
    • StopAndError access for the StopAndError steps listed in this workflow.
    • Batch access for the Batch steps listed in this workflow.
    • EmailSend access for the EmailSend steps listed in this workflow.

    Workflow nodes

    1. Run Once to Create Bookings Table (n8n-nodes-base.manualTrigger)
    2. Receive Cal.com Webhook (n8n-nodes-base.webhook)
    3. Check Reminders Every 5 Minutes (n8n-nodes-base.scheduleTrigger)
    4. Booking Settings (n8n-nodes-base.set)
    5. Setup Run? (n8n-nodes-base.if)
    6. Create Bookings Table (n8n-nodes-base.dataTable)
    7. From Webhook? (n8n-nodes-base.if)
    8. Sign Raw Body (n8n-nodes-base.crypto)
    9. Check Delivery (n8n-nodes-base.code)
    10. Delivery Accepted? (n8n-nodes-base.if)
    11. Answer Rejected or Ignored (n8n-nodes-base.respondToWebhook)
    12. Secret Missing? (n8n-nodes-base.if)
    13. Fail Run: Secret Missing (n8n-nodes-base.stopAndError)
    14. Find Bookings Table (n8n-nodes-base.dataTable)
    15. Bookings Table Found? (n8n-nodes-base.if)
    16. Webhook Delivery? (n8n-nodes-base.if)
    17. Caller Waiting? (n8n-nodes-base.if)
    18. Report Missing Table (n8n-nodes-base.respondToWebhook)
    19. Fail Run: Table Missing (n8n-nodes-base.stopAndError)
    20. Cancellation? (n8n-nodes-base.if)
    21. Reschedule? (n8n-nodes-base.if)
    22. Mark Old Booking Rescheduled (n8n-nodes-base.dataTable)
    23. Old Booking Marked? (n8n-nodes-base.if)
    24. Look Up Booking (n8n-nodes-base.dataTable)
    25. Already Stored? (n8n-nodes-base.if)
    26. Answer Duplicate (n8n-nodes-base.respondToWebhook)
    27. Nothing Stored Yet? (n8n-nodes-base.if)
    28. Insert Booking Row (n8n-nodes-base.dataTable)
    29. Row Stored? (n8n-nodes-base.if)
    30. Answer Stored (n8n-nodes-base.respondToWebhook)
    31. Report Store Failure (n8n-nodes-base.respondToWebhook)
    32. Fail Run: Booking Not Saved (n8n-nodes-base.stopAndError)
    33. Cancel Booking Row (n8n-nodes-base.dataTable)
    34. Cancel Saved? (n8n-nodes-base.if)
    35. Answer Cancel (n8n-nodes-base.respondToWebhook)
    36. Load Upcoming Bookings (n8n-nodes-base.dataTable)
    37. Pick Due Reminders (n8n-nodes-base.code)
    38. Loop Over Reminders (n8n-nodes-base.splitInBatches)
    39. Claim Reminder (n8n-nodes-base.dataTable)
    40. Reminder Claimed? (n8n-nodes-base.if)
    41. Send Reminder Email (n8n-nodes-base.emailSend)
    42. Release Reminder (n8n-nodes-base.dataTable)
    StickyNoteManualTriggerWebhookScheduleSetIFDataTableCryptoCodeRespondToWebhookStopAndErrorBatchEmailSend
    48 nodesOther
    View on GitHub

    Need this workflow customized or debugged? Book a 30-min scope call →

    Want this set up for you? Book a 30-min scope call

    I build and fix n8n workflows for agencies and SaaS teams. 30-minute scope call — bring the problem, leave with an estimate.

    Related workflows