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

    1. Run Once to Create Table (n8n-nodes-base.manualTrigger)
    2. Create Bookings Table (n8n-nodes-base.postgres)
    3. Booking Request Form (n8n-nodes-base.formTrigger)
    4. Booking Settings (n8n-nodes-base.set)
    5. Validate Request (n8n-nodes-base.code)
    6. Request Valid? (n8n-nodes-base.if)
    7. Request Not Possible (n8n-nodes-base.form)
    8. Reserve First Free Staff (n8n-nodes-base.postgres)
    9. Booked? (n8n-nodes-base.if)
    10. Send Confirmation (n8n-nodes-base.emailSend)
    11. Record Email Failure (n8n-nodes-base.postgres)
    12. Booking Confirmed (n8n-nodes-base.form)
    13. Already Booked by You? (n8n-nodes-base.if)
    14. Existing Booking (n8n-nodes-base.form)
    15. Load Upcoming Bookings (n8n-nodes-base.postgres)
    16. Suggest Free Times (n8n-nodes-base.code)
    17. Time Taken (n8n-nodes-base.form)
    StickyNoteManualTriggerPostgresFormTriggerSetCodeIFFormEmailSend
    21 nodesData Processing
    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