Upsert huge documents in a vector store with Supabase and Notion
n8n template #2568Summary
Use templatePurpose This workflow adds the capability to build a RAG on living data. In this case Notion is used as a Knowledge Base. Whenever a page is updated, the embeddings get upserted in a Supabase Vector Store. It can also be fairly easily adapted to PGVector, Pinecone, or Qdrant by using a custom HTTP request for the latter two. Demo How it works A trigger checks every minute for changes in the Notion Database. The manual polling approach improves accuracy and prevents changes from being lost between cached polling intervals. Afterwards every updated page is processed sequentially The Vector Database is searched using the Notion Page ID stored in the metadata of each embedding. If old entries ex
How to set it up
- Open template #2568 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
- Create 5 credentials under Credentials → Add credential: Notion, Supabase, Embeddings OpenAI, OpenAI Chat Model, Supabase Vector Store. Then open each of those nodes and pick the credential.
- Check the model in the OpenAI Chat Model node. The template may point at a model your account can't use; swap it for one you have access to.
- Click Execute workflow and step through each node's output to confirm the data looks right.
- Toggle the workflow to Active so its trigger runs on its own.
Hand off to your agent
Prompt
Help me set up the n8n workflow "Upsert huge documents in a vector store with Supabase and Notion" (https://n8n.io/workflows/2568). It uses: Notion, Supabase, Question and Answer Chain, Embeddings OpenAI, OpenAI Chat Model, Vector Store Retriever, Token Splitter, Supabase Vector Store, Default Data Loader. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
NotionSupabaseQuestion and Answer ChainEmbeddings OpenAIOpenAI Chat ModelVector Store RetrieverToken SplitterSupabase Vector StoreDefault Data Loader
Questions
Yes. Mario published it free on n8n.io as a verified creator, and it has 12K views. It runs on n8n Cloud or a self-hosted n8n instance.
Notion, Supabase, Embeddings OpenAI, OpenAI Chat Model, Supabase Vector Store. The other 4 nodes are built into n8n.
Similar workflows
NameViews
- Supabase Insertion & Upsertion & Retrieval24K
- WordPress - AI Chatbot to enhance user experience - with Supabase and OpenAI11K
- AI Agent To Chat With Files In Supabase Storage68K
- Advanced AI Demo (Presented at AI Developers #14 meetup)24K
- Build a PDF Document RAG System with Mistral OCR, Qdrant and Gemini AI20K
- Store Notion's Pages as Vector Documents into Supabase with OpenAI6,262
- AI Agent To Chat With Files In Supabase Storage and Google Drive5,693
- Explore n8n Nodes in a Visual Reference Library5,197