Create a private document Q&A system with Llama3, Postgres, Qdrant and Google Drive
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs when a chat message arrives (plus 2 other triggers). Along the way it connects Ollama Chat Model, Postgres Chat Memory, Qdrant Vector Store and Ollama Model and 3 more.
How it runs
Trigger: When a chat message arrives (plus 2 other triggers).
- AI Agent: runs an AI agent, with model: Ollama Chat Model; 1 tool (Answer questions with a vector store); memory: Postgres Chat Memory
- Set File ID (Edit Fields (Set)): sets 2 fields: file_id, folder_id
- Download File (Google Drive): download
- Extract Document Text (Extract from File): extracts data from a file (text)
- Qdrant Vector Store: stores documents in the Qdrant vector store, with embeddings: Embeddings Ollama; document loader: Default Data Loader
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat - Qdrant Vector Store
@n8n/n8n-nodes-langchain.vectorStoreQdrant - Ollama Model
@n8n/n8n-nodes-langchain.lmOllama - Embeddings Ollama
@n8n/n8n-nodes-langchain.embeddingsOllama - Vector Store Question Answer Tool
@n8n/n8n-nodes-langchain.toolVectorStore - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter
From the author
⚙️ How It Works: LocalRAG.AI ⚠️ Note: This system only works for self-hosted n8n instances. It will not function on n8n.cloud or other remote setups. LocalRAG.AI is a private, on-prem AI assistant that uses your own documents to answer questions…