Store Notion's Pages as Vector Documents into Supabase with OpenAI
detail.loadingPreview
Automate the storage of 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 taking pages from a specified Notion database and storing them as vector documents within a Supabase project that has a vector column. It leverages OpenAI for generating embeddings, allowing for semantic search and retrieval capabilities on your Notion content within Supabase. The workflow includes steps for fetching content, filtering out non-textual blocks, summarizing, splitting content into manageable chunks, generating embeddings, and finally storing all this information, including associated metadata, into Supabase.
Key Features
- Monitors a Notion database for newly added pages.
- Fetches and processes block content from Notion pages.
- Filters out image and video blocks, focusing on textual content.
- Concatenates and summarizes block content for embedding.
- Generates embeddings for textual content using OpenAI.
- Splits content into chunks for efficient processing.
- Stores processed documents, embeddings, and metadata in Supabase.
How To Use
- Configure Supabase: Ensure you have a Supabase project with a table that includes a vector column. Refer to the Supabase Vector Columns Guide for setup instructions.
- Set up Notion Integration: Configure your Notion API credentials within n8n.
- Specify Notion Database: In the
Notion - Page Added Triggernode, provide the ID of the Notion database you want to monitor. - Configure Supabase Table: In the
Supabase Vector Storenode, specify the target Supabase table name. - Configure OpenAI Credentials: Set up your OpenAI API key in n8n.
- Run the Workflow: Trigger the workflow manually or set it up to run on a schedule.
Apps Used
Workflow JSON
{
"id": "c7df11b3-7c8f-43c0-8ba5-aadba4e04d36",
"name": "Store Notion's Pages as Vector Documents into Supabase with OpenAI",
"nodes": 0,
"category": "Data Management",
"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: c7df11b3-7c8f...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Automate Storing Notion Pages as Vector Documents in Supabase with OpenAI
This workflow automatically stores Notion pages as vector documents in Supabase using OpenAI for embeddings. It triggers on new Notion pages, fetches content, filters media, and then stores the processed text and metadata in Supabase.
Automated Daily Weather Data Fetcher and Storage
Fetches daily weather data and stores it in Airtable.
Currency Exchange Rate Updater
Automatically updates currency exchange rates from an API to a Google Sheet.
Google Sheets Data Management
Append, lookup, update, and read data from a Google Sheets spreadsheet.
Spotify Playlist Sync to Supabase
Synchronizes a Spotify playlist with a Supabase table, updating or adding new tracks.
Tech Radar Template (Unverified)
A template for generating and managing Tech Radar data.