{
  "name": "Automate ETL error monitoring with AI classification, Sheets logging & Jira alerts",
  "nodes": [
    {
      "id": "d2758ac0-1d11-4457-ba1b-948d4c9d80de",
      "name": "Prepare ETL Logs",
      "type": "n8n-nodes-base.function",
      "position": [
        -2928,
        -80
      ]
    },
    {
      "id": "d980fe54-c902-4361-9ad3-ff02b1a95135",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -2864,
        112
      ]
    },
    {
      "id": "f0e0adfb-371a-4890-87bd-e4b562048da0",
      "name": "Parse Output",
      "type": "n8n-nodes-base.code",
      "position": [
        -2416,
        -80
      ]
    },
    {
      "id": "c040fc8c-4c6c-40b6-90b3-7c483a7e6d3a",
      "name": "Create Jira Task",
      "type": "n8n-nodes-base.jira",
      "position": [
        -1744,
        -80
      ]
    },
    {
      "id": "62a996cd-422a-4c42-918c-602bf619dbc9",
      "name": "ETL Failure Alert",
      "type": "n8n-nodes-base.slack",
      "position": [
        -1312,
        112
      ]
    },
    {
      "id": "b551342b-5e61-45f2-851d-73d092b4f90c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3312,
        -208
      ],
      "parameters": {
        "width": 224,
        "height": 272,
        "content": "Starts the workflow whenever a new ETL error log is received."
      }
    },
    {
      "id": "72ee4738-5a66-4a65-a968-b1559f2e3622",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        48
      ],
      "parameters": {
        "width": null,
        "height": 224,
        "content": "Sends a Slack message to notify the team about the issue."
      }
    },
    {
      "id": "53923033-a815-48f5-b69a-a23a00fab0bd",
      "name": "AI Severity Classification",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -2720,
        -80
      ]
    },
    {
      "id": "1d8d29dc-93be-4381-9a5d-8f763965a135",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1392,
        -288
      ],
      "parameters": {
        "width": 256,
        "height": 224,
        "content": "Sends an email with full error details to the team."
      }
    },
    {
      "id": "93377b90-5cad-4c8a-bca9-c9abe1efeb2d",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2240,
        -224
      ],
      "parameters": {
        "width": 720,
        "height": 336,
        "content": "## Save & Report the Issue\nThese steps organize the final error details, save them into Google Sheets for tracking, and automatically create a Jira ticket whenever the issue is important or needs atte"
      }
    },
    {
      "id": "1fc9bbc4-35ae-4f63-9ce6-ecc74e0077e5",
      "name": "store ETL logs",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1968,
        -80
      ]
    },
    {
      "id": "c704fd97-5912-49ac-b2fa-ff7c052089f9",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3072,
        -256
      ],
      "parameters": {
        "width": 816,
        "height": 496,
        "content": "## Analyze & Classify the Error\nThese steps extract key error details, create a short preview and shareable log link, use AI to understand the issue and rate its severity, and then convert the AI’s ou"
      }
    },
    {
      "id": "4c2e2034-6771-47ad-9fdc-87b3549628d1",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4000,
        -688
      ],
      "parameters": {
        "width": 496,
        "height": 720,
        "content": "## How It Works\n\nThis workflow automatically processes ETL errors and organizes them in a clean, easy-to-review format. When an error occurs, the workflow extracts the important information, creates a"
      }
    },
    {
      "id": "641239c2-9a0e-40ee-a800-a4856a8532ec",
      "name": "Get ETL Error",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -3232,
        -80
      ]
    },
    {
      "id": "0b414b97-8249-410f-b445-c87202e042da",
      "name": "Prepare Data for logging",
      "type": "n8n-nodes-base.set",
      "position": [
        -2192,
        -80
      ]
    },
    {
      "id": "3a2b8b08-1442-40ba-8290-a4751e9fee0c",
      "name": "ETL Failure Notify",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -1344,
        -224
      ]
    }
  ],
  "connections": {
    "Parse Output": {
      "main": [
        [
          {
            "node": "Prepare Data for logging",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get ETL Error": {
      "main": [
        [
          {
            "node": "Prepare ETL Logs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "store ETL logs": {
      "main": [
        [
          {
            "node": "Create Jira Task",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Jira Task": {
      "main": [
        [
          {
            "node": "ETL Failure Alert",
            "type": "main",
            "index": 0
          },
          {
            "node": "ETL Failure Notify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare ETL Logs": {
      "main": [
        [
          {
            "node": "AI Severity Classification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Severity Classification",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Data for logging": {
      "main": [
        [
          {
            "node": "store ETL logs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Severity Classification": {
      "main": [
        [
          {
            "node": "Parse Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}