{
  "name": "Monitor TP-Link Omada network disconnections with Gmail & Pushover",
  "nodes": [
    {
      "id": "376b4f9c-7bf1-40a1-88a3-11bbdd1824b8",
      "name": "Process Email and Extract",
      "type": "n8n-nodes-base.code",
      "position": [
        464,
        176
      ]
    },
    {
      "id": "6808c535-be1a-4bce-8a55-17e4878b2c3b",
      "name": "Append Row in Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        896,
        176
      ]
    },
    {
      "id": "bc91b08b-924a-4c0f-8e8b-d1d69d218a33",
      "name": "Check Every 5 minutes",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        64,
        800
      ]
    },
    {
      "id": "f35f5433-0aa4-41ba-9665-a749daae3a5a",
      "name": "Get Row(s) in Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        288,
        800
      ]
    },
    {
      "id": "6db058b2-c4d5-4875-b536-ac14285cacf3",
      "name": "Check Device and Notify",
      "type": "n8n-nodes-base.code",
      "position": [
        512,
        800
      ]
    },
    {
      "id": "17b9806a-7ed4-4f49-bbdf-941277fe74ae",
      "name": "Update Alert",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        944,
        784
      ]
    },
    {
      "id": "64082460-3cfb-4af2-82c5-dea73f6fe80a",
      "name": "Receives Alert",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        16,
        176
      ]
    },
    {
      "id": "1a29a2dd-f37c-45e7-b0b3-9f21f70c7738",
      "name": "Clear sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        144,
        1328
      ]
    },
    {
      "id": "a1d48f39-9906-4c5d-99d6-10e953afb397",
      "name": "Clear Rows Every 2 days",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -80,
        1328
      ]
    },
    {
      "id": "c66fc6f3-9923-45d5-89e7-0631c22d1bf1",
      "name": "Alert User",
      "type": "n8n-nodes-base.pushover",
      "position": [
        944,
        992
      ]
    },
    {
      "id": "77784bb9-3cae-4150-8346-e423b720a71d",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        16
      ],
      "parameters": {
        "width": 464,
        "height": 448,
        "content": "## This workflow monitors device connection status from Omada Controller alerts.\n\nHow it works:\n- Gmail Trigger receives Omada alert emails\n- Code node parses the alert into structured fields\n- Data i"
      }
    },
    {
      "id": "b2e2974a-5cf2-40df-9a76-64d3f3ff3534",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 224,
        "height": 144,
        "content": "**Receives Alert**: \n\nGmail trigger for Omada Controller emails  "
      }
    },
    {
      "id": "7a743261-e183-4302-9a0d-90c97433c3c5",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        0
      ],
      "parameters": {
        "width": 224,
        "height": 144,
        "content": "**Process Email and Extract**: \n\nExtracts timestamp, device name, MAC, severity, status  "
      }
    },
    {
      "id": "75723c9f-062e-438b-974e-9d3154b5d140",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        0
      ],
      "parameters": {
        "width": 224,
        "height": 144,
        "content": "**Append Row in Sheet**: \n\nLogs data to Google Sheets  "
      }
    },
    {
      "id": "b1e05077-659a-4774-a7b5-82586944fd07",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        576
      ],
      "parameters": {
        "width": 304,
        "height": 144,
        "content": "**Check Every 5 minutes**: \n\nScheduled polling to detect overdue disconnections  "
      }
    },
    {
      "id": "29b5289b-d53c-44fe-85df-db475a119ebf",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        576
      ],
      "parameters": {
        "width": 224,
        "height": 144,
        "content": "**Check Device and Notify**: \n\nFilters devices disconnected >30 minutes  \n"
      }
    },
    {
      "id": "7f0bf309-1e30-43ff-8d18-2ed136e5b82f",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        1168
      ],
      "parameters": {
        "width": 224,
        "height": 144,
        "content": "**Alert User**: \n\nSends push notification via Pushover. You can change this to any notifying app"
      }
    },
    {
      "id": "6c01c483-f76b-47f1-ac07-5ab2ef149541",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        576
      ],
      "parameters": {
        "width": 224,
        "height": 144,
        "content": "**Update Alert**: \n\nMarks row as alerted in Google Sheets  \n"
      }
    },
    {
      "id": "639d6524-794d-49ea-bfef-2556d4e00d1e",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        1136
      ],
      "parameters": {
        "width": 224,
        "height": 144,
        "content": "**Clear Rows Every 2 days**: \n\nCleans up old entries to keep data fresh  \n"
      }
    }
  ],
  "connections": {
    "Receives Alert": {
      "main": [
        [
          {
            "node": "Process Email and Extract",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Row(s) in Sheet": {
      "main": [
        [
          {
            "node": "Check Device and Notify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Every 5 minutes": {
      "main": [
        [
          {
            "node": "Get Row(s) in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Device and Notify": {
      "main": [
        [
          {
            "node": "Update Alert",
            "type": "main",
            "index": 0
          },
          {
            "node": "Alert User",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clear Rows Every 2 days": {
      "main": [
        [
          {
            "node": "Clear sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Email and Extract": {
      "main": [
        [
          {
            "node": "Append Row in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}