{
  "name": "Automated error monitoring and reporting system using data tables",
  "nodes": [
    {
      "id": "d468bbe6-751d-4438-b859-cd1daa7ee8ce",
      "name": "Error Trigger",
      "type": "n8n-nodes-base.errorTrigger",
      "position": [
        160,
        -224
      ]
    },
    {
      "id": "795cbfbd-3f08-4c9d-a0be-0459c309ad73",
      "name": "Ignore Manual Failures",
      "type": "n8n-nodes-base.filter",
      "position": [
        384,
        -224
      ]
    },
    {
      "id": "2f6722be-39f7-478f-a47d-4a16002dc008",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        816,
        460
      ]
    },
    {
      "id": "f30573e0-c346-47c2-99f5-b86d6310a109",
      "name": "Time Saved",
      "type": "n8n-nodes-base.timeSaved",
      "position": [
        832,
        -224
      ]
    },
    {
      "id": "8bd9894a-ec9a-443e-819b-be43a6fbc70a",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1360,
        720
      ]
    },
    {
      "id": "fea0ae9a-650d-4816-b02b-a26f20dff39c",
      "name": "Update Last Emailed At",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        1616,
        720
      ]
    },
    {
      "id": "e23d7bed-2310-40ab-9d34-465d56ddcd28",
      "name": "Get Errors that were not Emailed",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        368,
        460
      ]
    },
    {
      "id": "9cc66afe-89cb-4dbf-9aff-05c56e181521",
      "name": "map fields to data table",
      "type": "n8n-nodes-base.set",
      "position": [
        608,
        -224
      ]
    },
    {
      "id": "83076dd7-5b22-427d-8365-71279af62184",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1496,
        432
      ]
    },
    {
      "id": "31f714b3-2931-4221-957a-270215a0c32d",
      "name": "AI Error Summarizer",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1488,
        208
      ]
    },
    {
      "id": "e38c352e-5e5f-43c2-82a2-baaa24da284b",
      "name": "Email Error Details",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1840,
        312
      ]
    },
    {
      "id": "dd482380-098a-439e-9539-31407defc725",
      "name": "Insert Error Details",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        1056,
        -224
      ]
    },
    {
      "id": "5020cc8e-f172-4007-9fa1-c669066cf4b9",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        -16
      ],
      "parameters": {
        "width": 448,
        "height": 512,
        "content": "## Automated error monitoring and reporting system\n\n**How it works:**\n1. Error Trigger activates on workflow failures. Ignore Manual Failures filters out testing runs.\n2. Error details (workflow name,"
      }
    },
    {
      "id": "71ef77a5-6918-41c6-8ff0-37a0883b22b2",
      "name": "Calculator",
      "type": "@n8n/n8n-nodes-langchain.toolCalculator",
      "position": [
        1624,
        432
      ]
    },
    {
      "id": "30e8edaf-def4-4a18-821a-b439a095026c",
      "name": "Sort",
      "type": "n8n-nodes-base.sort",
      "position": [
        592,
        460
      ]
    },
    {
      "id": "eeaba522-a90a-4450-ad29-46dc0c9d66b6",
      "name": "high error count or been a day1",
      "type": "n8n-nodes-base.filter",
      "position": [
        1040,
        460
      ]
    },
    {
      "id": "a0e8e245-d98c-4832-8138-b0bca4e7f6af",
      "name": "Run every hour",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        144,
        460
      ]
    },
    {
      "id": "7378503f-bd85-4fdb-9144-a1fcb1354455",
      "name": "Generate Workflow Errors Table HTML",
      "type": "n8n-nodes-base.html",
      "position": [
        1264,
        312
      ]
    },
    {
      "id": "26d49e97-fed8-453e-929e-c7f3e89d9f9d",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1216,
        96
      ],
      "parameters": {
        "width": 880,
        "height": 464,
        "content": "## Generate & Send Error Notification\nConsolidate errors into a single table with an email with AI Powered Insights & sends the Email"
      }
    },
    {
      "id": "6065144a-c242-494e-9c0d-e54ecd239a42",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        624
      ],
      "parameters": {
        "width": 608,
        "height": 336,
        "content": "## Update Errors that were notified\nUpdate Errors that were emailed to they're not picked up next time"
      }
    },
    {
      "id": "8572a97f-f58b-4b96-a781-deeb5f18fdf7",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        336
      ],
      "parameters": {
        "width": 832,
        "height": 336,
        "content": "## Filter & Prepare errors to report\nSort errors that are to be reported and filter only if error count is beyond a threshold"
      }
    },
    {
      "id": "7a2030b0-dd2e-4b04-9909-a5dc518e6059",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        -352
      ],
      "parameters": {
        "width": 960,
        "height": 384,
        "content": "## Store errors\nIgnore Manual Errors and store automatic errors into our Error Data Table"
      }
    }
  ],
  "connections": {
    "Sort": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "high error count or been a day1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Update Last Emailed At",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculator": {
      "ai_tool": [
        [
          {
            "node": "AI Error Summarizer",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Time Saved": {
      "main": [
        [
          {
            "node": "Insert Error Details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Error Trigger": {
      "main": [
        [
          {
            "node": "Ignore Manual Failures",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run every hour": {
      "main": [
        [
          {
            "node": "Get Errors that were not Emailed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Error Summarizer",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "AI Error Summarizer": {
      "main": [
        [
          {
            "node": "Email Error Details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email Error Details": {
      "main": [
        []
      ]
    },
    "Ignore Manual Failures": {
      "main": [
        [
          {
            "node": "map fields to data table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "map fields to data table": {
      "main": [
        [
          {
            "node": "Time Saved",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "high error count or been a day1": {
      "main": [
        [
          {
            "node": "Generate Workflow Errors Table HTML",
            "type": "main",
            "index": 0
          },
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Errors that were not Emailed": {
      "main": [
        [
          {
            "node": "Sort",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Workflow Errors Table HTML": {
      "main": [
        [
          {
            "node": "AI Error Summarizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}