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
- Run Once to Create Bookings Table (n8n-nodes-base.manualTrigger)
- Receive Cal.com Webhook (n8n-nodes-base.webhook)
- Check Reminders Every 5 Minutes (n8n-nodes-base.scheduleTrigger)
- Booking Settings (n8n-nodes-base.set)
- Setup Run? (n8n-nodes-base.if)
- Create Bookings Table (n8n-nodes-base.dataTable)
- From Webhook? (n8n-nodes-base.if)
- Sign Raw Body (n8n-nodes-base.crypto)
- Check Delivery (n8n-nodes-base.code)
- Delivery Accepted? (n8n-nodes-base.if)
- Answer Rejected or Ignored (n8n-nodes-base.respondToWebhook)
- Secret Missing? (n8n-nodes-base.if)
- Fail Run: Secret Missing (n8n-nodes-base.stopAndError)
- Find Bookings Table (n8n-nodes-base.dataTable)
- Bookings Table Found? (n8n-nodes-base.if)
- Webhook Delivery? (n8n-nodes-base.if)
- Caller Waiting? (n8n-nodes-base.if)
- Report Missing Table (n8n-nodes-base.respondToWebhook)
- Fail Run: Table Missing (n8n-nodes-base.stopAndError)
- Cancellation? (n8n-nodes-base.if)
- Reschedule? (n8n-nodes-base.if)
- Mark Old Booking Rescheduled (n8n-nodes-base.dataTable)
- Old Booking Marked? (n8n-nodes-base.if)
- Look Up Booking (n8n-nodes-base.dataTable)
- Already Stored? (n8n-nodes-base.if)
- Answer Duplicate (n8n-nodes-base.respondToWebhook)
- Nothing Stored Yet? (n8n-nodes-base.if)
- Insert Booking Row (n8n-nodes-base.dataTable)
- Row Stored? (n8n-nodes-base.if)
- Answer Stored (n8n-nodes-base.respondToWebhook)
- Report Store Failure (n8n-nodes-base.respondToWebhook)
- Fail Run: Booking Not Saved (n8n-nodes-base.stopAndError)
- Cancel Booking Row (n8n-nodes-base.dataTable)
- Cancel Saved? (n8n-nodes-base.if)
- Answer Cancel (n8n-nodes-base.respondToWebhook)
- Load Upcoming Bookings (n8n-nodes-base.dataTable)
- Pick Due Reminders (n8n-nodes-base.code)
- Loop Over Reminders (n8n-nodes-base.splitInBatches)
- Claim Reminder (n8n-nodes-base.dataTable)
- Reminder Claimed? (n8n-nodes-base.if)
- Send Reminder Email (n8n-nodes-base.emailSend)
- Release Reminder (n8n-nodes-base.dataTable)
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.