AutomationMart
Home/Browse/Upsert huge documents in a vector store with Supabase and Notion
n8n

Upsert huge documents in a vector store with Supabase and Notion

n8nn8n19 modulesv1.0
Notion

Purpose 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

At a glance

Upsert huge documents in a vector store with Supabase and Notion is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Notion. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Notion
Modules
19
Price
Free
Version
v1.0
Upsert huge documents in a vector store with Supabase and Notion workflow diagram

About this workflow

Purpose 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 exist, they are deleted. - All blocks of the Notion Database Page are retrieved and combined into a single string - The content is embedded and split into chunks if necessary. Metadata, including the Notion Page ID, is added during storage for future reference. - A simple Question and Answer Chain enables users to ask questions about the embedded content through the integrated chat function Prerequisites - To setup a new Vector Store in Supabase, follow this guide - Prepare a simple Database in Notion with each Database Page containing at least a title and some content in the blocks section. You can of course also connect this to an existing Database of your choice. Setup - Select your credentials in the nodes which require those - If you are on an n8n cloud plan, switch to the native Notion Trigger by activating it and deactivating the Schedule Trigger along with its subsequent Notion Node - Choose your Notion Database in the first Node related to Notion - Adjust the chunk size and overlap in the Token Splitter to your preference - Activate the workflow How to use Populate your Notion Database with useful information and use the chat mode of this workflow to ask questions about it. Updates to a Notion Page should quickly reflect in future conversations.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Turns Reddit Pain Points into Comic Ads using Dumpling AI and GPT-4o

Description 🤖 What this workflow does This workflow turns Reddit pain points into emotionally-driven comic-style ads using AI. It takes in a product description, scrapes Reddit for real user pain points, filters relevant posts using AI, generates ad angles, rewrites them into 4-panel comic prompts, and finally uses Dumpling AI to generate comic-style images. All final creatives are uploaded to Google Drive. --- 🧠 What problem is this solving? Crafting ad content that truly speaks to custom

Free

Log daily mood & weather to Notion with Telegram and OpenWeatherMap

The Daily Mood & Weather Logger 🚀 is more than just a utility; it's a hands-on n8n workflow designed to teach you core automation concepts. By setting up and exploring this template, you'll gain practical experience with triggers, API calls, data manipulation using the Code node, and integrating with external services like Notion. It automates tracking your daily mood alongside local weather, logging it all into a Notion database. --- 🎯 Learning Objectives: What You'll Master This workflow templ

Free

Search and update Notion database items using API key authentication

Easily search and update Notion database items using API key authentication. Automate data retrieval and modification with Notion and HTTP modules.

Free

Generate SEO blog posts from web searches with Mistral AI and Google Drive

Overview This template automates the process of researching a keyword, scraping top-ranking articles, cleaning their content, and generating a high-quality SEO-optimized blog post. It uses Google Search via RapidAPI, Ollama with Mistral AI, and Google Drive to deliver an end-to-end automated content workflow. Ideal for content creators, SEO specialists, bloggers, and marketers who need to quickly gather and summarize insights from multiple sources to create superior content. ⚙️ Prerequisites Bef

Free

Conduct SWOT analysis on competitors with ChatGPT and add the information to a Notion Database item

Utilize ChatGPT to perform a comprehensive SWOT analysis on competition, and effortlessly update a Notion Database item with vital insights to power your competitive strategy.

Free

Create Facebook ads copy with Notion and ChatGPT: BAB formula

Craft compelling Facebook Ads copy using Notion and ChatGPT with the Before After Bridge (BAB) framework. Elevate your marketing strategy by creating persuasive, targeted ad content that bridges the gap between your audience's current state and their desired outcome.

Free

Automated AI lead enrichment: Hubspot to Explorium for enhanced prospect data

HubSpot Contact Enrichment with Explorium Template Download the following json file and import it to a new n8n workflow: hubspot\flow.json Overview This n8n workflow monitors your HubSpot instance for newly created contacts and automatically enriches them with additional contact information. When a contact is created, the workflow: 1. Detects the new contact via HubSpot webhook trigger 2. Retrieves recent contact details from HubSpot 3. Matches the contact against Explorium's database using name

Free

Local document question answering with Ollama AI, Agentic RAG & PGVector

n8n Local AI Agentic RAG Template Author: Jadai kongolo What is this? This template provides an entirely local implementation of an Agentic RAG (Retrieval Augmented Generation) system in n8n that can be extended easily for your specific use case and knowledge base. Unlike standard RAG which only performs simple lookups, this agent can reason about your knowledge base, self-improve retrieval, and dynamically switch between differ

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free