Store Notion's Pages as Vector Documents into Supabase with OpenAI
detail.loadingPreview
Automates storing Notion pages as vector documents in Supabase using OpenAI embeddings.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of storing content from Notion pages as vector documents within a Supabase database. It's designed to create a searchable knowledge base from your Notion content, leveraging OpenAI for text embeddings and Supabase for scalable vector storage.
Key Features
- Triggers on new pages added to a specified Notion database.
- Retrieves all block content from Notion pages.
- Filters out non-textual content like images and videos.
- Concatenates and summarizes block content into a single text.
- Generates embeddings for the text content using OpenAI.
- Splits text into manageable chunks for embedding.
- Creates metadata including page ID, creation time, and page title.
- Stores processed documents and their embeddings into a Supabase table with a vector column.
- Includes error handling for robust execution.
How To Use
- Set up Supabase: Ensure you have a Supabase project with a table that includes a vector column. Refer to the Supabase Vector Columns Guide.
- Configure Notion Trigger: Set up the
Notion - Page Added Triggernode to monitor your desired Notion database. - Configure Notion Credentials: Ensure your Notion API credentials are correctly set up in n8n.
- Configure OpenAI Credentials: Ensure your OpenAI API key is correctly set up in n8n.
- Configure Supabase Credentials: Ensure your Supabase project URL and API keys are correctly set up in n8n.
- Specify Supabase Table: In the
Supabase Vector Storenode, specify the target table name for storing the vector documents. - Set Chunk Size/Overlap: Adjust the
Token Splitternode'schunkSizeandchunkOverlapparameters as needed for your embedding strategy. - Activate Workflow: Enable the workflow to start processing new Notion pages.
Apps Used
Workflow JSON
{
"id": "362f3c80-8c32-4db1-94ae-63f4aeeb27a8",
"name": "Store Notion's Pages as Vector Documents into Supabase with OpenAI",
"nodes": 0,
"category": "Data Integration",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 362f3c80-8c32...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Google Drive Loader to Vector DB
Loads files from Google Drive into a Vector Database using OpenAI embeddings.
Community Contributed: Import CSV to PostgreSQL
Automate the import of CSV files into a PostgreSQL database.
Icypeas Real-time Search Results Listener
Listen to Icypeas search results in real-time and process them.
Community Contributed: XML to Google Sheets
This workflow downloads an XML file, parses its content, and writes the data to a Google Sheet.
Customer Datastore API Integration
Integrates with the Customer Datastore API to retrieve and process customer data.
Automate Notion Content Ingestion to Pinecone Vector Store
This workflow automatically ingests new Notion pages, processes their content, and stores them as embeddings in a Pinecone vector store using the Notion Trigger, Token Splitter, and Google Gemini Embeddings nodes.