Templates / Supabase insertion & upsertion & retrieval

Supabase insertion & upsertion & retrieval

Ready for 3.0

by Ria ✓ · 29,305 views · created 2024-09-01 · Document Extraction, 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 16 nodes and runs when a chat message arrives. Along the way it connects Google Drive, OpenAI Chat Model, Supabase Vector Store and Embeddings OpenAI and 1 more.

How it runs

Trigger: When a chat message arrives.

  1. Question and Answer Chain: answers questions over your documents (RAG), with model: OpenAI Chat Model; retriever: Vector Store Retriever
  2. Customize Response (Edit Fields (Set)): sets 1 field: output
  3. Placeholder (File/Content to Upsert) (Edit Fields (Set)): sets or maps fields
  4. Update Documents (Supabase Vector Store): uses the Supabase vector store, with embeddings: Embeddings OpenAI
  5. Google Drive: download
  6. Insert Documents (Supabase Vector Store): stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
  7. Retrieve Rows from Table (Supabase): get many

Services it uses

Google DriveOpenAI Chat ModelSupabase Vector StoreEmbeddings OpenAISupabase

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

From the author

This is a demo workflow to showcase how to use Supabase to embed a document, retrieve information from the vector store via chat and update the database. Setup steps: - set your credentials for Supabase - set your credentials for an AI model of your choice -…

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