Templates / Document-based RAG chat assistant with Google Drive, Supabase & OpenAI

Document-based RAG chat assistant with Google Drive, Supabase & OpenAI

Ready for 3.0

by Jainik Sheth · 794 views · created 2025-10-09 · 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 32 nodes and runs when a chat message arrives (plus 3 other triggers). Along the way it connects OpenAI Chat Model, Supabase Vector Store, Embeddings OpenAI and Google Drive and 2 more.

How it runs

Trigger: When a chat message arrives (plus 3 other triggers).

  1. Switch: routes items into 2 branches
  2. Edit Fields (Edit Fields (Set)): sets 3 fields: file_id, file_type, source
  3. Edit Fields (Edit Fields (Set)): sets 3 fields: file_id, file_type, source
  4. Search files and folders (Google Drive): work with file folder
  5. Extract From PDF (Extract from File): extracts data from a file (pdf)
  6. AI Agent: runs an AI agent, with model: OpenAI Chat Model; 1 tool (Supabase Vector Store); memory: Chat Memory
  7. Delete a row (Supabase): delete
  8. Download file (Google Drive): download
  9. Get many rows (Supabase): get many
  10. Merge: merges the data from its input branches

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

Services it uses

OpenAI Chat ModelSupabase Vector StoreEmbeddings OpenAIGoogle DriveSupabasePostgres Chat Memory

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

From the author

What is this? This RAG workflow allows you to build a smart chat assistant that can answer user questions based on any collection of documents you provide. It automatically imports and processes files from Google Drive, stores their content in a searchable…

Excerpt from Jainik Sheth'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.