{
  "name": "Track employee attendance with analytics, email reports & Slack alerts using Google Sheets",
  "nodes": [
    {
      "id": "0e4bdcc5-f1e5-4bcd-8ebb-9345a564c334",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1440,
        0
      ]
    },
    {
      "id": "5f2a24aa-5e38-4296-8071-0c7630cc61fc",
      "name": "Fetch Attendance Records",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1216,
        -96
      ]
    },
    {
      "id": "0d136a8a-09d5-41bc-a74f-fe6e14a5686a",
      "name": "Fetch Employee Master Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1216,
        96
      ]
    },
    {
      "id": "7a72aa69-8c3d-472c-86d6-b04b4dfa0913",
      "name": "Analytics Engine",
      "type": "n8n-nodes-base.code",
      "position": [
        -992,
        0
      ]
    },
    {
      "id": "7651642d-6966-49bd-b503-7b57369026d2",
      "name": "Records Available",
      "type": "n8n-nodes-base.if",
      "position": [
        -768,
        0
      ]
    },
    {
      "id": "bc5e3d2a-5946-4223-af9a-696f54b79828",
      "name": "Critical Alerts",
      "type": "n8n-nodes-base.if",
      "position": [
        -544,
        -192
      ]
    },
    {
      "id": "36732aa7-c12f-4af0-acfe-e94b4f64b5ca",
      "name": "Format Email",
      "type": "n8n-nodes-base.code",
      "position": [
        -320,
        -192
      ]
    },
    {
      "id": "c6b97279-622c-479a-94b9-7591ac89b885",
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -96,
        -192
      ]
    },
    {
      "id": "674e5e0a-3f26-4980-be64-aeaf1cdc4b48",
      "name": "Format Slack",
      "type": "n8n-nodes-base.code",
      "position": [
        -544,
        0
      ]
    },
    {
      "id": "39c44862-38ad-4c32-aa12-c55f1a3d1de6",
      "name": "Post to Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        -320,
        0
      ]
    },
    {
      "id": "69043dab-0525-462b-b2de-12ce885def34",
      "name": "Log Summary",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -544,
        192
      ]
    },
    {
      "id": "b2f9027b-2c48-4e26-b175-081ee2fc73ea",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1472,
        -160
      ],
      "parameters": {
        "width": 150,
        "height": 288,
        "content": "Runs hourly to monitor attendance with zero manual effort."
      }
    },
    {
      "id": "1cda22e2-28de-40fa-b380-80264166deb3",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1280,
        -224
      ],
      "parameters": {
        "width": 416,
        "height": 464,
        "content": "Fetches attendance and employee master data, then merges them for enriched analytics and analyzes attendance, calculates key metrics, detects anomalies, and generates alerts."
      }
    },
    {
      "id": "e2fbe0c6-3e13-4509-a6cc-f941376979ae",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        -304
      ],
      "parameters": {
        "width": 448,
        "height": 656,
        "content": "Validates data, prioritizes alerts, and routes notifications via email, Slack, and database and logs daily summaries, maintains audit trails, and prepares data for trend analysis dashboards."
      }
    },
    {
      "id": "1dbde325-390a-4164-9e64-84f67fc6c1c8",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        -320
      ],
      "parameters": {
        "width": 416,
        "height": 464,
        "content": "Sends visually formatted reports with metrics, alerts, and detailed employee breakdowns."
      }
    }
  ],
  "connections": {
    "Format Email": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Slack": {
      "main": [
        [
          {
            "node": "Post to Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Critical Alerts": {
      "main": [
        [
          {
            "node": "Format Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Analytics Engine": {
      "main": [
        [
          {
            "node": "Records Available",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Fetch Attendance Records",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch Employee Master Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Records Available": {
      "main": [
        [
          {
            "node": "Critical Alerts",
            "type": "main",
            "index": 0
          },
          {
            "node": "Format Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Attendance Records": {
      "main": [
        [
          {
            "node": "Analytics Engine",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Employee Master Data": {
      "main": [
        [
          {
            "node": "Analytics Engine",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}