Templates / Build an All-Source Knowledge Assistant with Claude, RAG, Perplexity, and Drive

Build an All-Source Knowledge Assistant with Claude, RAG, Perplexity, and Drive

Ready for 3.0

by Paul ✓ · 10,608 views · created 2025-07-27 · Internal Wiki, AI RAG

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 30 nodes and runs manually, when you click “Execute workflow” (plus 3 other triggers). Along the way it connects Postgres Chat Memory, Embeddings OpenAI, Reranker Cohere and Anthropic Chat Model and 6 more.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 3 other triggers).

  1. Download file (Google Drive): download
  2. Knowledge Agent (AI Agent): runs an AI agent, with model: Anthropic Chat Model; 5 tools (Think, structured data, General knowledge, Message a model in Perplexity…); memory: Postgres Chat Memory
  3. Operation (Switch): routes items into 1 branches
  4. Add to Supabase Vector DB (Supabase Vector Store): stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
  5. Download File (Google Drive): download
  6. FileType (Switch): routes items into 5 branches
  7. Extract from PDF (Extract from File): extracts data from a file (pdf)
  8. Extract from CSV (Extract from File): extracts data from a file
  9. Analyse Image (OpenAI): analyze (image)
  10. Transcribe Audio (OpenAI): transcribe (audio)

…plus 2 more steps. See the full node list below.

Services it uses

Postgres Chat MemoryEmbeddings OpenAIReranker CohereAnthropic Chat ModelPostgresSupabase Vector StoreGoogle DriveOpenAIMCP ClientPerplexity

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 (23)

From the author

📜 Detailed n8n Workflow Description Main Flow The workflow operates through a three-step process that handles incoming chat messages with intelligent tool orchestration: 1. Message Trigger: The When chat message received node triggers whenever a user message…

Excerpt from Paul's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.