AutomationFlowsAI & RAG › Query and Answer Questions From Excel Spreadsheets with Gpt-4 Mini

Query and Answer Questions From Excel Spreadsheets with Gpt-4 Mini

ByGegenfeld @gegenfeld on n8n.io

This workflow creates an intelligent chatbot that uses your Microsoft Excel workbooks as a knowledge base. The AI agent can automatically query your Excel spreadsheets to provide accurate, contextual responses based on your stored data and information.

Chat trigger trigger★★★☆☆ complexityAI-powered9 nodesOpenAI ChatChat TriggerAgentMemory Buffer WindowMicrosoft Excel Tool
AI & RAG Trigger: Chat trigger Nodes: 9 Complexity: ★★★☆☆ AI nodes: yes Added:

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

This workflow follows the Agent → Chat Trigger 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
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "8bab2b5d-18cb-41dc-99c7-b16e4ae700df",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -464,
        320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0a599d05-8162-44de-bedc-9dddf8ef6284",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "50e228fb-edfa-47ac-84c1-5f2328d29c4f",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7e19996a-2473-42c7-a6fe-ab0497b89dfa",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -336,
        -320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "05e4892e-503d-4f30-a424-28c48556c878",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -384,
        160
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "196e5d4a-36a8-429a-b568-52bf237d89de",
      "name": "Start Chat Conversation",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -432,
        -64
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "349eb81d-a532-49a4-8a79-101e11651c88",
      "name": "Smart AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -176,
        -64
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "9b8a74f3-b40f-4be2-8e1e-3ed3051346a3",
      "name": "Remember Chat History",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -64,
        160
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "49cb6b81-702e-4902-b4d9-37b2ecd6899f",
      "name": "Get Excel Data",
      "type": "n8n-nodes-base.microsoftExcelTool",
      "position": [
        272,
        160
      ],
      "parameters": {},
      "typeVersion": 2.1
    }
  ],
  "connections": {
    "Get Excel Data": {
      "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 Microsoft Excel workbooks as a knowledge base. The AI agent can automatically query your Excel spreadsheets to provide accurate, contextual responses based on your stored data and information.

Source: https://n8n.io/workflows/6624/ — 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

Generate Sql Queries From Schema Only Ai Powered. Uses lmChatOpenAi, memoryBufferWindow, noOp, mySql. Chat trigger; 29 nodes.

OpenAI Chat, Memory Buffer Window, MySQL +3
AI & RAG

Generate SQL queries from schema only - AI-powered. Uses lmChatOpenAi, memoryBufferWindow, noOp, mySql. Chat trigger; 29 nodes.

OpenAI Chat, Memory Buffer Window, MySQL +3
AI & RAG

Generate SQL queries from schema only - AI-powered. Uses lmChatOpenAi, memoryBufferWindow, noOp, mySql. Chat trigger; 29 nodes.

OpenAI Chat, Memory Buffer Window, MySQL +3
AI & RAG

This workflow is a modification of the previous template on how to create an SQL agent with LangChain and SQLite.

OpenAI Chat, Memory Buffer Window, MySQL +3
AI & RAG

This n8n template provides a powerful AI-powered chatbot that acts as your personal Spotify DJ. Simply tell the chatbot what kind of music you're in the mood for, and it will intelligently create a cu

OpenAI Chat, Spotify, Chain Llm +7