How to Index Notion to Supabase Vector Search?
Description
New pages in your Notion database become AI ready records in Supabase. The flow cleans, splits, and embeds the text so your team can power fast search or a chat bot over your knowledge. It fits knowledge bases, support guides, handbooks, and meeting notes.
When a page is added in Notion, the run starts. It fetches all blocks from the page, removes images and videos, and concatenates the remaining text into one body. The content gets metadata like page id and created time, then it is split into 256 token chunks with a 30 token overlap for better recall. OpenAI creates embeddings for each chunk, and the workflow inserts both text, vectors, and metadata into your Supabase table that has a vector column. This design keeps storage lean and makes search results more accurate.
Connect Notion, OpenAI, and Supabase, and point the trigger to the Notion database you use for source content. Prepare a Supabase table with a vector column, then map the table name in the node. Teams usually cut manual copy work to near zero and keep indexing current within minutes. Use it for policy search, engineering docs, product updates, or FAQ libraries. No coding is needed once connections are set.
Tools Required
What this workflow does?
- Listens for new pages in a selected Notion database and starts the run automatically.
- Retrieves all page blocks and keeps only text content for clean inputs.
- Concatenates the blocks into one body to prepare for chunking and embeddings.
- Adds metadata such as page id and created time to every document chunk.
- Splits text into 256 token chunks with a 30 token overlap to boost recall.
- Generates vector embeddings using OpenAI for each chunk.
- Writes text, vectors, and metadata into a Supabase table with a vector column.
- Configurable chunk size and overlap to match your content style.
What are the benefits?
- Reduce manual work from 60 minutes to 2 minutes per page
- Automate over 90 percent of indexing steps from Notion to Supabase
- Improve data consistency by eliminating copy and paste errors
- Handle 10 times more pages with chunking and batching
- Connect Notion and Supabase seamlessly for AI search
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Notion, OpenAI and Supabase. See the Tools Required section above for links to create accounts with these services.
- In the n8n credentials manager, open the Notion nodes and create a new Notion credential. Follow the on screen instructions to connect your Notion workspace.
- In Notion, share the source database with the integration you created so the workflow can read new pages.
- Open the Notion Page Added Trigger node and select your Notion credential. Choose the database to watch and keep the polling set to every minute.
- Check the Notion Retrieve Page Content node. The block id expression that uses the page URL is already set. Leave it as is.
- Review the Filter Non Text Content node. Confirm that image and video types are excluded so only text is processed.
- Create an OpenAI credential in n8n. Click the Embeddings node, choose Create new credential, and paste your OpenAI API key from the OpenAI account API page.
- Prepare Supabase: create a table with columns for text content, metadata, and a vector column sized for your chosen OpenAI embedding model. Enable the vector extension if needed in your project.
- In the Supabase Vector Store node, create a new Supabase credential with your project URL and key. Set the table name and map any column settings the node requires.
- Run a test: add a new page to the connected Notion database. Wait a minute, then open Executions in n8n to confirm a successful run. Check your Supabase table for new rows with vectors.
- Troubleshoot issues: if no run appears, confirm the Notion database is shared with the integration and the correct database is selected. If rows are missing vectors, verify the OpenAI key and table vector column type. Adjust chunk size or overlap if your content is very short or very long.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
