This n8n workflow automates an intelligent knowledge management and chatbot system leveraging AI and data integrations. It starts with a webhook trigger for chat messages, which then process and enrich data using OpenAI embeddings and a re-ranking system from Cohere. The workflow also interacts with Google Sheets to handle tabular data and performs real-time web searches to gather fresh information. The core component is an AI agent powered by OpenAI’s chat model, which accesses stored personal and knowledge data via a vector database (Supabase) and a maintenance memory system with Postgres. It also can retrieve external knowledge through the MCP client tool and answer user queries incorporating recent search data. Practical use cases include customer support bots, dynamic FAQ systems, or intelligent personal assistants that blend stored knowledge with live data, providing accurate, context-aware responses.

Node Count

11 – 20 Nodes

Nodes Used

@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.chatTrigger, @n8n/n8n-nodes-langchain.embeddingsOpenAi, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.mcpClientTool, @n8n/n8n-nodes-langchain.mcpTrigger, @n8n/n8n-nodes-langchain.memoryPostgresChat, @n8n/n8n-nodes-langchain.rerankerCohere, @n8n/n8n-nodes-langchain.vectorStoreSupabase, googleSheetsTool, perplexityTool, stickyNote