AutomationFlowsAI & RAG › Create a Smart Chatbot Using Openai Gpt and Airtable Knowledge Base

Create a Smart Chatbot Using Openai Gpt and Airtable Knowledge Base

ByGegenfeld @gegenfeld on n8n.io

This workflow creates an intelligent chatbot that uses your Airtable database as a knowledge base. The AI agent can automatically query your Airtable records to provide accurate, contextual responses based on your stored data.

Chat trigger trigger★★★☆☆ complexityAI-powered9 nodesOpenAI ChatAirtable ToolChat TriggerAgentMemory Buffer Window
AI & RAG Trigger: Chat trigger Nodes: 9 Complexity: ★★★☆☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #6470 — we link there as the canonical source.

This workflow follows the Agent → Airtabletool recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "nodes": [
    {
      "id": "dcca2d23-15fa-417b-a126-b7e654c73cf6",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        560
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "515f872d-8e26-481b-8eeb-e8f7fb9914a6",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        64,
        560
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8e4bff7d-a759-4600-a4f8-45f998354eb2",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        416,
        560
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ecea4d58-50c7-4778-8f5c-d05de0f07554",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9061e1c2-7c9b-482b-a7c9-04e32333fb98",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -144,
        400
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "c5ecac3c-3841-4879-873e-18cc64fe2c66",
      "name": "Airtable Database",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        496,
        400
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "5e4f7b05-437e-444a-854c-bd1ebe431e6c",
      "name": "Start Chat Conversation",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -192,
        176
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "238d4ef4-0c07-4858-ba5a-00ab9f184bb1",
      "name": "Smart AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        64,
        176
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "5be2fd82-7256-4f70-a15e-00ca35037555",
      "name": "Remember Chat History",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        176,
        400
      ],
      "parameters": {},
      "typeVersion": 1.3
    }
  ],
  "connections": {
    "Airtable Database": {
      "ai_tool": [
        [
          {
            "node": "Smart AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Smart AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Remember Chat History": {
      "ai_memory": [
        [
          {
            "node": "Smart AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Start Chat Conversation": {
      "main": [
        [
          {
            "node": "Smart AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow creates an intelligent chatbot that uses your Airtable database as a knowledge base. The AI agent can automatically query your Airtable records to provide accurate, contextual responses based on your stored data.

Source: https://n8n.io/workflows/6470/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

✨ Intro This workflow shows how to go beyond a “plain” AI chatbot by:

Telegram, OpenAI, OpenAI Chat +13
AI & RAG

Build an MCP server with Airtable. Uses chatTrigger, agent, memoryBufferWindow, mcpClientTool. Chat trigger; 13 nodes.

Chat Trigger, Agent, Memory Buffer Window +4
AI & RAG

Build an MCP server with Airtable. Uses chatTrigger, agent, memoryBufferWindow, mcpClientTool. Chat trigger; 13 nodes.

Chat Trigger, Agent, Memory Buffer Window +4
AI & RAG

This template is designed for anyone who wants to integrate MCP with their AI Agents using Airtable. Whether you're a developer, a data analyst, or an automation enthusiast, if you're looking to lever

Chat Trigger, Agent, Memory Buffer Window +4
AI & RAG

🔥 AI Agent with Airtable. Uses agent, lmChatOpenAi, memoryBufferWindow, chatTrigger. Chat trigger; 11 nodes.

Agent, OpenAI Chat, Memory Buffer Window +2