Add Holidays to ConnectWise PSA

The year end procedure in ConnectWise Manage can be a ~~bit~~very annoying. This makes it a little less annoying.

Step 1: Get Your Holidays from ChatGPT

First, find a list of statutory holidays for your region. You can Google something like “2026 statutory holidays [your province/state]” or use a government website.

Then, paste the list into ChatGPT with this prompt:

Take these holidays and return this JSON object shape:
{"holidays":[{"name":"...", "date":"YYYY-MM-DD"}]}

ChatGPT will return something like:

{
  "holidays": [
    { "name": "New Year's Day", "date": "2026-01-01" },
    { "name": "Family Day", "date": "2026-02-16" },
    { "name": "Good Friday", "date": "2026-04-03" },
    ...
  ]
}

Copy this JSON output for use in step 3 below.

The Workflow

{
  "nodes": [
    {
      "parameters": {},
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        0,
        112
      ],
      "id": "c7e50741-0f7e-4d2c-b6fe-7a5d0f73727e",
      "name": "When clicking 'Execute workflow'"
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "592034ed-4f1c-4107-8a75-4701bf3dcfb0",
              "name": "holidayListId",
              "type": "number",
              "value": 2
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        224,
        112
      ],
      "id": "173cecdc-db66-4278-8953-565ba5b55d32",
      "name": "Set Holiday List ID"
    },
    {
      "parameters": {
        "resource": "custom",
        "endpoint": "=/schedule/holidayLists/{{ $json.holidayListId }}/holidays",
        "returnAll": true,
        "orderBy": "date",
        "descending": true,
        "fields": "id,name,date"
      },
      "type": "@mspcopilot/n8n-nodes-connectwise.connectWisePsa",
      "typeVersion": 1,
      "position": [
        672,
        208
      ],
      "id": "cae8997c-08fc-4d2f-afd4-66e7cd13fe50",
      "name": "Get Holidays",
      "credentials": {
        "connectWisePsaApi": {
          "id": "YOUR_CREDENTIAL_ID",
          "name": "ConnectWise PSA account"
        }
      }
    },
    {
      "parameters": {
        "fieldToSplitOut": "holidays",
        "options": {}
      },
      "type": "n8n-nodes-base.splitOut",
      "typeVersion": 1,
      "position": [
        672,
        16
      ],
      "id": "466fc9e1-9905-44c3-b335-e43dc327b61f",
      "name": "Split Out"
    },
    {
      "parameters": {
        "mode": "combine",
        "fieldsToMatchString": "date",
        "joinMode": "keepNonMatches",
        "outputDataFrom": "input1",
        "options": {}
      },
      "type": "n8n-nodes-base.merge",
      "typeVersion": 3.2,
      "position": [
        896,
        112
      ],
      "id": "a7690723-edb5-4746-8db8-1a67f0772ef4",
      "name": "Return Missing Dates"
    },
    {
      "parameters": {
        "resource": "custom",
        "endpoint": "=/schedule/holidayLists",
        "returnAll": true,
        "fields": "id,name,_info/lastUpdated"
      },
      "type": "@mspcopilot/n8n-nodes-connectwise.connectWisePsa",
      "typeVersion": 1,
      "position": [
        0,
        -208
      ],
      "id": "3886052e-3c88-41fc-ad2c-a0a6db452fde",
      "name": "Get Holiday List ID",
      "notesInFlow": true,
      "credentials": {
        "connectWisePsaApi": {
          "id": "YOUR_CREDENTIAL_ID",
          "name": "ConnectWise PSA account"
        }
      },
      "notes": "Run this to get the holiday list ID to set in the first node"
    },
    {
      "parameters": {
        "mode": "raw",
        "jsonOutput": "{\n  \"holidays\": [\n    { \"name\": \"New Year's Day\", \"date\": \"2026-01-01\" },\n    { \"name\": \"B.C. Family Day\", \"date\": \"2026-02-16\" },\n    { \"name\": \"Good Friday\", \"date\": \"2026-04-03\" },\n    { \"name\": \"Easter Monday\", \"date\": \"2026-04-06\" },\n    { \"name\": \"Victoria Day\", \"date\": \"2026-05-18\" },\n    { \"name\": \"Canada Day\", \"date\": \"2026-07-01\" },\n    { \"name\": \"B.C. Day\", \"date\": \"2026-08-03\" },\n    { \"name\": \"Labour Day\", \"date\": \"2026-09-07\" },\n    { \"name\": \"Truth & Reconciliation Day\", \"date\": \"2026-09-30\" },\n    { \"name\": \"Thanksgiving Day\", \"date\": \"2026-10-12\" },\n    { \"name\": \"Remembrance Day\", \"date\": \"2026-11-11\" },\n    { \"name\": \"Christmas Day\", \"date\": \"2026-12-25\" }\n  ]\n}\n",
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        448,
        16
      ],
      "id": "ac8a25bf-fe21-439c-ae91-2735fe947a6d",
      "name": "Set Holidays"
    },
    {
      "parameters": {
        "method": "POST",
        "url": "=https://api-na.myconnectwise.net/v4_6_release/apis/3.0/schedule/holidayLists/{{ $('Set Holiday List ID').item.json.holidayListId }}/holidays",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBasicAuth",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"name\": {{ JSON.stringify($json.name) }},\n  \"date\": {{ JSON.stringify($json.date) }},\n  \"allDayFlag\": true\n}",
        "options": {}
      },
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.3,
      "position": [
        1120,
        112
      ],
      "id": "ace0ad05-d02f-4737-be8d-fdb280025c69",
      "name": "Create Holiday",
      "disabled": true
    }
  ],
  "connections": {
    "When clicking 'Execute workflow'": {
      "main": [
        [
          {
            "node": "Set Holiday List ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Holiday List ID": {
      "main": [
        [
          {
            "node": "Set Holidays",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Holidays",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Holidays": {
      "main": [
        [
          {
            "node": "Return Missing Dates",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Return Missing Dates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Return Missing Dates": {
      "main": [
        [
          {
            "node": "Create Holiday",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Holidays": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {}
}

Step 2: Get Your Holiday List ID

Before running the main workflow, you need to find your Holiday List ID in ConnectWise.

Click on the disconnected Get Holiday List ID node at the top-left
Execute just that node
Look at the output to find your holiday list’s id value

Depending on how you manage your holiday lists, you may only have one, or you need to find our most recent.

Step 3: Configure the Workflow

Set Holiday List ID

Open this node and change the holidayListId value to match the ID you found in Step 2.

Set Holidays

Open this node and replace the JSON with the holidays you got from ChatGPT. The format should be:

{
  "holidays": [
    { "name": "New Year's Day", "date": "2026-01-01" },
    { "name": "Your Holiday", "date": "2026-MM-DD" }
  ]
}

Create Holiday

This node uses the ConnectWise REST API directly to create each holiday. You’ll need to set up your ConnectWise API credentials.

How It Works

Set Holiday List ID stores your holiday list ID for the other nodes to use.
The workflow splits into two parallel paths:
- Set Holidays + Split Out takes your JSON and splits each holiday into a separate item
- Get Holidays fetches existing holidays from ConnectWise
Return Missing Dates compares the two lists and only outputs holidays that don’t already exist in ConnectWise (matching by date).
Create Holiday POSTs each new holiday to ConnectWise.

Step 4: Test Before Running

The Create Holiday node is disabled by default. This is intentional.

Run the workflow with the node disabled to see which holidays will be created
Verify the output looks correct
Enable the Create Holiday node
Run the workflow again to actually create the holidays

Notes

The workflow automatically skips holidays that already exist (matching by date)
If you need to update holiday names, you’ll need to delete them in ConnectWise first
You can run this workflow multiple times safely - it won’t create duplicates

Add Holidays to ConnectWise PSA

Step 1: Get Your Holidays from ChatGPT

The Workflow

Step 2: Get Your Holiday List ID

Step 3: Configure the Workflow

Set Holiday List ID

Set Holidays

Create Holiday

How It Works

Step 4: Test Before Running

Notes

Related Posts

ScreenConnect Cloud Migration - Agent Install Automation

Zabbix Multi-Tenant Ticketing Integration

Hosting n8n for MSPs

ConnectWise Date Formats in n8n