{
  "name": "Monitor Kimai project deadlines and budgets with daily email alerts",
  "nodes": [
    {
      "id": "fc46a11c-cb88-470d-ac28-314a4f911676",
      "name": "Send an Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2704,
        176
      ]
    },
    {
      "id": "51e18cb1-20e1-486a-9ea5-a9c65bb72a27",
      "name": "Every Day at 9:00",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        736,
        256
      ]
    },
    {
      "id": "f228e077-eae6-4442-abd5-46d713a980ff",
      "name": "GET Projects",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        960,
        256
      ]
    },
    {
      "id": "055cc8ac-f30a-4f69-a236-edd0425b58cc",
      "name": "Get only Bilable",
      "type": "n8n-nodes-base.code",
      "position": [
        1184,
        256
      ]
    },
    {
      "id": "0e709eaf-f296-4e60-8fa5-20739dd4a9e8",
      "name": "GET Projects Details",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1552,
        160
      ]
    },
    {
      "id": "0a14fabc-e525-4c78-8291-b1f9dad92492",
      "name": "GET Timesheet Records",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1408,
        352
      ]
    },
    {
      "id": "3453b9a8-0e24-422b-972f-ad490bdc8fcf",
      "name": "Calculate Budget Uses",
      "type": "n8n-nodes-base.code",
      "position": [
        1632,
        352
      ]
    },
    {
      "id": "381fbd24-3e48-4d3f-8b92-ae73df6d8456",
      "name": "Combine Data",
      "type": "n8n-nodes-base.merge",
      "position": [
        1856,
        256
      ]
    },
    {
      "id": "1f697c3b-9d42-4f15-ac8e-98c5b0490a38",
      "name": "Calculate expiration",
      "type": "n8n-nodes-base.code",
      "position": [
        2080,
        256
      ]
    },
    {
      "id": "753c9210-efd8-43bf-993c-6f50799b0dfb",
      "name": "Need Email?",
      "type": "n8n-nodes-base.if",
      "position": [
        2304,
        256
      ]
    },
    {
      "id": "a5294383-503e-4c15-a5e7-51e6e3ec0ed8",
      "name": "Build Email HTML - Report",
      "type": "n8n-nodes-base.code",
      "position": [
        2528,
        176
      ]
    },
    {
      "id": "d9e85095-fd10-4ad2-aa0e-15d2a44163d5",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2016,
        544
      ],
      "parameters": {
        "width": 224,
        "height": 80,
        "content": "To Customize the Range of Day to check customize here."
      }
    },
    {
      "id": "e0c4fc70-0a02-47e4-985a-8f30eca5690c",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        32
      ],
      "parameters": {
        "width": 256,
        "height": 608,
        "content": "## 1. Scheduled Start"
      }
    },
    {
      "id": "b7ef4e00-7322-4614-85aa-2d99ef0f5656",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        912,
        32
      ],
      "parameters": {
        "width": 1072,
        "height": 608,
        "content": "## 2.  Get Information from Kimai"
      }
    },
    {
      "id": "e70f095a-c231-4a93-b813-ffd7d1acfb46",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2000,
        32
      ],
      "parameters": {
        "width": 256,
        "height": 608,
        "content": "## 3. Check Expiration"
      }
    },
    {
      "id": "59990bba-f5c5-4b4a-8fb0-f845d04e3d8b",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2272,
        32
      ],
      "parameters": {
        "width": 624,
        "height": 608,
        "content": "## 4. Build & Send Email"
      }
    },
    {
      "id": "6aae9924-997a-4887-a127-1a8a35a7fd15",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        32
      ],
      "parameters": {
        "width": 768,
        "height": 608,
        "content": "# 📅 Kimai — Deadline & Budget Monitor\n\n## Monitors billable Kimai projects daily and sends an HTML alert email when a deadline is within 10 days or the hour budget exceeds 80%.\n\nRuns every weekday at "
      }
    }
  ],
  "connections": {
    "Need Email?": {
      "main": [
        [
          {
            "node": "Build Email HTML - Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Data": {
      "main": [
        [
          {
            "node": "Calculate expiration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GET Projects": {
      "main": [
        [
          {
            "node": "Get only Bilable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get only Bilable": {
      "main": [
        [
          {
            "node": "GET Projects Details",
            "type": "main",
            "index": 0
          },
          {
            "node": "GET Timesheet Records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Every Day at 9:00": {
      "main": [
        [
          {
            "node": "GET Projects",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate expiration": {
      "main": [
        [
          {
            "node": "Need Email?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GET Projects Details": {
      "main": [
        [
          {
            "node": "Combine Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Budget Uses": {
      "main": [
        [
          {
            "node": "Combine Data",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "GET Timesheet Records": {
      "main": [
        [
          {
            "node": "Calculate Budget Uses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Email HTML - Report": {
      "main": [
        [
          {
            "node": "Send an Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}