Store Notion's Pages as Vector Documents into Supabase with OpenAI

# Notion Page to Supabase Vector Document Ingestion with OpenAI Embeddings

This n8n workflow automates the process of extracting content from Notion pages, splitting it into manageable chunks, generating embeddings using OpenAI, and storing these as vector documents in a Supabase Vector Store. This is particularly useful for building AI-powered search, Q&A, or recommendation systems based on your Notion content.

## What it does

This workflow performs the following key steps:

1.  **Triggers on Notion Page Updates**: Listens for new or updated pages within a specified Notion database.
2.  **Loads Notion Page Content**: Retrieves the full content of the triggered Notion page.
3.  **Filters for Relevant Content**: (Implicitly, as there's a filter node, but no explicit condition in the JSON. This would typically filter based on page properties, status, or content.)
4.  **Splits Text into Tokens**: Breaks down the Notion page content into smaller, token-based chunks suitable for embedding.
5.  **Generates OpenAI Embeddings**: Uses the OpenAI Embeddings service to convert each text chunk into a numerical vector representation.
6.  **Stores in Supabase Vector Store**: Inserts the text chunks along with their generated embeddings into a Supabase Vector Store, making them queryable for semantic search.

## Prerequisites/Requirements

To use this workflow, you will need:

*   **n8n Instance**: A running n8n instance.
*   **Notion Account**: With access to the database you wish to monitor.
    *   **Notion API Key**: Configured as a credential in n8n.
    *   **Notion Integration**: An integration set up in Notion with access to the relevant pages/databases.
*   **OpenAI Account**: With an active API key.
    *   **OpenAI API Key**: Configured as a credential in n8n.
*   **Supabase Project**: With a configured Vector Store.
    *   **Supabase Credentials**: API URL and Service Role Key configured as a credential in n8n.

## Setup/Usage

1.  **Import the Workflow**:
    *   Download the provided JSON file.
    *   In your n8n instance, go to "Workflows" and click "New".
    *   Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2.  **Configure Credentials**:
    *   Locate the "Notion Trigger" node and configure your Notion API credential.
    *   Locate the "Embeddings OpenAI" node and configure your OpenAI API credential.
    *   Locate the "Supabase Vector Store" node and configure your Supabase API credentials (URL and Service Role Key).
3.  **Configure Nodes**:
    *   **Notion Trigger**: Select the Notion database you want to monitor for page updates.
    *   **Filter**: (Optional but recommended) If you have specific criteria for which Notion pages should be processed, configure the "Filter" node with your desired conditions (e.g., a specific status, tag, or property value).
    *   **Token Splitter**: Adjust the chunk size and overlap as needed for your content and embedding model.
    *   **Supabase Vector Store**: Specify your Supabase table name and any other relevant configuration for your vector store.
4.  **Activate the Workflow**: Once all credentials and configurations are set, activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.

The workflow will now automatically process new or updated Notion pages, extract their content, generate embeddings, and store them in your Supabase Vector Store.