Postgres Appointment Booking Form Staff Conflict Check
What this workflow does
The workflow contains these steps: Run Once to Create Table → Create Bookings Table → Booking Request Form → Booking Settings → Validate Request → Request Valid? → Request Not Possible → Reserve First Free Staff → Booked? → Send Confirmation → Record Email Failure → Booking Confirmed → Already Booked by You? → Existing Booking → Load Upcoming Bookings → Suggest Free Times → Time Taken.
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.
- Postgres access for the Postgres steps listed in this workflow.
- FormTrigger access for the FormTrigger steps listed in this workflow.
- Set access for the Set steps listed in this workflow.
- Code access for the Code steps listed in this workflow.
- IF access for the IF steps listed in this workflow.
- Form access for the Form steps listed in this workflow.
- EmailSend access for the EmailSend steps listed in this workflow.
Workflow nodes
- Run Once to Create Table (n8n-nodes-base.manualTrigger)
- Create Bookings Table (n8n-nodes-base.postgres)
- Booking Request Form (n8n-nodes-base.formTrigger)
- Booking Settings (n8n-nodes-base.set)
- Validate Request (n8n-nodes-base.code)
- Request Valid? (n8n-nodes-base.if)
- Request Not Possible (n8n-nodes-base.form)
- Reserve First Free Staff (n8n-nodes-base.postgres)
- Booked? (n8n-nodes-base.if)
- Send Confirmation (n8n-nodes-base.emailSend)
- Record Email Failure (n8n-nodes-base.postgres)
- Booking Confirmed (n8n-nodes-base.form)
- Already Booked by You? (n8n-nodes-base.if)
- Existing Booking (n8n-nodes-base.form)
- Load Upcoming Bookings (n8n-nodes-base.postgres)
- Suggest Free Times (n8n-nodes-base.code)
- Time Taken (n8n-nodes-base.form)
StickyNoteManualTriggerPostgresFormTriggerSetCodeIFFormEmailSend
21 nodesData Processing
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
Postgres Sales Dashboard With Period Comparison Via Webhook
25 nodesStickyNoteManualTriggerPostgres
N8n Data Tables Daily Backup To Postgres
34 nodesStickyNoteManualTriggerPostgres
Postgres Smtp Approval Requests With Approve Reject Email Links
40 nodesStickyNoteManualTriggerPostgres
Manual Postgres Automate Triggered
4 nodesManualTriggerSetPostgres