{
  "name": "AI-Powered Employee Database Management via Telegram using OpenAI and Airtable",
  "nodes": [
    {
      "id": "8d91665e-aaff-4142-bcb9-3d379a87618d",
      "name": "Telegram Trigger",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        760,
        240
      ]
    },
    {
      "id": "dde5b325-66a3-414e-996b-09135814d7dd",
      "name": "Create Employee AI Agent tool",
      "type": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "position": [
        420,
        840
      ]
    },
    {
      "id": "b7165659-3e7a-4bde-91ad-2143224477d5",
      "name": "Get departments data from airtable tool",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        900,
        840
      ]
    },
    {
      "id": "c19de0c1-cf62-4515-93fd-3313b81d9626",
      "name": "Get job titles data from airtable tool",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1060,
        840
      ]
    },
    {
      "id": "bc37498b-5b89-4140-9a26-ec1f55fa298d",
      "name": "Get employees data from airtable tool",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1220,
        840
      ]
    },
    {
      "id": "821c13e2-a1c5-421a-9d57-f28960b561ae",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        400,
        480
      ]
    },
    {
      "id": "c5a26dac-f55b-4a61-9236-133d9f67f07b",
      "name": "Simple Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        440,
        620
      ]
    },
    {
      "id": "b849b536-788d-40c1-84e8-2e5d6c45a3b8",
      "name": "Send Message to User",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1060,
        500
      ]
    },
    {
      "id": "3782507d-3270-470d-993d-6b3bd2959b2a",
      "name": "Create Department Tool",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        580,
        840
      ]
    },
    {
      "id": "f4aa10b4-8c66-45b2-80da-740f1045aaed",
      "name": "Create Job Title Tool",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        740,
        840
      ]
    },
    {
      "id": "a87618cd-10ec-4e43-ad71-12cd3ee13c76",
      "name": "Delete employee tool",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1400,
        840
      ]
    },
    {
      "id": "a687d442-126f-43dd-9519-f213d21b8428",
      "name": "Employee Management AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        660,
        500
      ]
    },
    {
      "id": "cfc30862-5069-4550-85b4-357edc875eae",
      "name": "Get departments data from airtable",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        680,
        1400
      ]
    },
    {
      "id": "47509e6e-8694-45ec-b29e-4006bec17bfc",
      "name": "Get job titles data from airtable",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        840,
        1400
      ]
    },
    {
      "id": "efdf756b-7a03-424d-a6c3-26f08b88b660",
      "name": "Create Employee AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        740,
        1040
      ]
    },
    {
      "id": "9b79d409-5064-4bd3-bf70-1b60fc4ff391",
      "name": "When Executed by Another Workflow",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        500,
        1040
      ]
    },
    {
      "id": "38d2ffff-daf4-49dd-8378-a7e138d723e9",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1480,
        1400
      ]
    },
    {
      "id": "781120f2-eb69-4f85-9b90-1dbfe74af02f",
      "name": "Create Department",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1000,
        1400
      ]
    },
    {
      "id": "fd13d5bd-1553-440c-bf8d-0811d18a73bb",
      "name": "Create Job Title",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1160,
        1400
      ]
    },
    {
      "id": "4c241fba-7e3f-4582-ba96-79e8bc773fde",
      "name": "Create employee",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1320,
        1400
      ]
    },
    {
      "id": "44c1ef1d-0847-4eb6-85ff-4a478f80bfab",
      "name": "Update Employee Data",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1120,
        1040
      ]
    },
    {
      "id": "163bfe25-0024-414e-9bb5-23a5d2ce4cbe",
      "name": "OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        520,
        1400
      ]
    },
    {
      "id": "70c33091-adb5-4bf2-bae3-67830d91b68f",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        -120
      ],
      "parameters": {
        "width": 460,
        "height": 460,
        "content": "## 🤖 AI-Powered Employee Database Management via Telegram using OpenAI and Airtable\n\n**What This Template Does:**\n- Provides an HR assistant chatbot interface through Telegram\n- Uses GPT-4 to interpre"
      }
    },
    {
      "id": "ea7867df-2d10-4ad5-a4ec-b98905374e44",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1000,
        -120
      ],
      "parameters": {
        "width": 500,
        "height": 460,
        "content": "## 📋 WORKFLOW PROCESS OVERVIEW  \nStep 1: 💬 Telegram Trigger receives natural language command from HR user  \nStep 2: 🧠 AI Agent (OpenA) interprets intent (view, create, delete, etc.)  \nStep 3: 🔀 Route"
      }
    },
    {
      "id": "7c257782-6d13-4c7b-b594-af8a4b721e40",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        -120
      ],
      "parameters": {
        "width": 280,
        "height": 320,
        "content": "## SETUP REQUIRED  \n**Author:** [Billy Christi](https://n8n.io/creators/billy/)\n\nAirtable Base Structure:  \n[Copy this Airtable Base](https://airtable.com/appgVjZcaRP8BsKf0/shrQAqQ2JUW50EEyW)\n\nRequire"
      }
    },
    {
      "id": "dd0eb916-f358-4b15-b7e2-1afabfd7754f",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1540,
        -120
      ],
      "parameters": {
        "width": 380,
        "height": 760,
        "content": "# 👋 Hi, I’m Billy\n![My Photo](https://i.ibb.co/Gvn63Bzc/Billy-Christi-AI-Automation.jpg)\nI help businesses build **n8n workflows** & **AI automation projects**.  \nNeed help with n8n or AI Automation p"
      }
    }
  ],
  "connections": {
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Create employee": {
      "ai_tool": [
        [
          {
            "node": "Create Employee AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Create Job Title": {
      "ai_tool": [
        [
          {
            "node": "Create Employee AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Telegram Trigger": {
      "main": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Department": {
      "ai_tool": [
        [
          {
            "node": "Create Employee AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Create Employee AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Delete employee tool": {
      "ai_tool": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Create Job Title Tool": {
      "ai_tool": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Create Department Tool": {
      "ai_tool": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Create Employee AI Agent": {
      "main": [
        [
          {
            "node": "Update Employee Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Create Employee AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Employee Management AI Agent": {
      "main": [
        [
          {
            "node": "Send Message to User",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Employee AI Agent tool": {
      "ai_tool": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get job titles data from airtable": {
      "ai_tool": [
        [
          {
            "node": "Create Employee AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "When Executed by Another Workflow": {
      "main": [
        [
          {
            "node": "Create Employee AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get departments data from airtable": {
      "ai_tool": [
        [
          {
            "node": "Create Employee AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get employees data from airtable tool": {
      "ai_tool": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get job titles data from airtable tool": {
      "ai_tool": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get departments data from airtable tool": {
      "ai_tool": [
        [
          {
            "node": "Employee Management AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}