Schedule Trigger First Or Last Working Day Of Month

    What this workflow does

    The workflow contains these steps: Run Once to Create Tables → Every Hour at Minute 5 → Schedule Settings → Setup Run? → Create Rules Table → Create Holidays Table → Create Run Log Table → Check Rules Table Empty → Rules Table Empty? → Example Rules → Add Example Rules → Find Data Tables → Tables Found? → Build Missing Tables Alert → Read Job Rules → Read Holidays → Read Run Log → Decide What Runs Now → Write Run Log Entry → Pick Jobs to Call → Any Jobs to Call? → Call Job Webhook → Check Job Response → Save Job Result → Build Summary Email → Send Summary Email → Tables Were Missing? → Stop: Tables Missing → Stop: Email Failed.

    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.
    • 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.
    • Code access for the Code steps listed in this workflow.
    • HTTP Request access for the HTTP Request steps listed in this workflow.
    • EmailSend access for the EmailSend steps listed in this workflow.
    • StopAndError access for the StopAndError steps listed in this workflow.

    Workflow nodes

    1. Run Once to Create Tables (n8n-nodes-base.manualTrigger)
    2. Every Hour at Minute 5 (n8n-nodes-base.scheduleTrigger)
    3. Schedule Settings (n8n-nodes-base.set)
    4. Setup Run? (n8n-nodes-base.if)
    5. Create Rules Table (n8n-nodes-base.dataTable)
    6. Create Holidays Table (n8n-nodes-base.dataTable)
    7. Create Run Log Table (n8n-nodes-base.dataTable)
    8. Check Rules Table Empty (n8n-nodes-base.dataTable)
    9. Rules Table Empty? (n8n-nodes-base.if)
    10. Example Rules (n8n-nodes-base.code)
    11. Add Example Rules (n8n-nodes-base.dataTable)
    12. Find Data Tables (n8n-nodes-base.dataTable)
    13. Tables Found? (n8n-nodes-base.if)
    14. Build Missing Tables Alert (n8n-nodes-base.code)
    15. Read Job Rules (n8n-nodes-base.dataTable)
    16. Read Holidays (n8n-nodes-base.dataTable)
    17. Read Run Log (n8n-nodes-base.dataTable)
    18. Decide What Runs Now (n8n-nodes-base.code)
    19. Write Run Log Entry (n8n-nodes-base.dataTable)
    20. Pick Jobs to Call (n8n-nodes-base.code)
    21. Any Jobs to Call? (n8n-nodes-base.if)
    22. Call Job Webhook (n8n-nodes-base.httpRequest)
    23. Check Job Response (n8n-nodes-base.code)
    24. Save Job Result (n8n-nodes-base.dataTable)
    25. Build Summary Email (n8n-nodes-base.code)
    26. Send Summary Email (n8n-nodes-base.emailSend)
    27. Tables Were Missing? (n8n-nodes-base.if)
    28. Stop: Tables Missing (n8n-nodes-base.stopAndError)
    29. Stop: Email Failed (n8n-nodes-base.stopAndError)
    StickyNoteManualTriggerScheduleSetIFDataTableCodeHTTP RequestEmailSendStopAndError
    35 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