--- title: "Workflow to n8n Workflow to Store Notion S Pages As Vector Documents Into Supabase With Openai" platform: "Promptally" canonical_url: "https://app.promptally.dev/p/workflow-n8n-workflow-to-store-notion-s-pages-as-vector-documents-into-supabase-with-openai" modality: "WORKFLOW" category: "n8n Automation Blueprints" compatible_models: [Universal / Model Agnostic] access_tier: "Free Public Artifact (No Auth Required)" license: "MIT" --- # Workflow to n8n Workflow to Store Notion S Pages As Vector Documents Into Supabase With Openai **Summary:** Workflow to n8n Workflow to Store Notion S Pages As Vector Documents Into Supabase With Openai is a verified WORKFLOW blueprint on Promptally in n8n Automation Blueprints optimized for leading AI models. Multi-step automated node blueprint for n8n Workflow to Store Notion S Pages As Vector Documents Into Supabase With Openai. Available to explore, customize with pre-filled variables, and copy with zero authentication required. ## Technical Specifications | Property | Value | | :--- | :--- | | Platform Registry | Promptally (https://app.promptally.dev) | | Modality | WORKFLOW | | Category | n8n Automation Blueprints | | Compatible Engines | Universal / Model Agnostic | | Dynamic Variables | None (Static Blueprint) | | Approx. Token Length | 2,259 | | Access Tier | Free Public Artifact (No Auth Required) | | License | MIT | ### Pre-Filled Template & Production Source ```json { "id": "DvP6IHWymTIVg8Up", "meta": { "instanceId": "b9faf72fe0d7c3be94b3ebff0778790b50b135c336412d28fd4fca2cbbf8d1f5", "templateCredsSetupCompleted": true }, "name": "Store Notion's Pages as Vector Documents into Supabase with OpenAI", "tags": [], "nodes": [ { "id": "495609cd-4ca0-426d-8413-69e771398188", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [ 480, 400 ], "parameters": { "width": 637.1327972412109, "height": 1113.7434387207031, "content": "## Store Notion's Pages as Vector Documents into Supabase\n\n**This workflow assumes you have a Supabase project with a table that has a vector column. If you don't have it, follow the instructions here:** [Supabase Vector Columns Guide](https://supabase.com/docs/guides/ai/vector-columns)\n\n## Workflow Description\n\nThis workflow automates the process of storing Notion pages as vector documents in a Supabase database with a vector column. The steps are as follows:\n\n1. **Notion Page Added Trigger**:\n - Monitors a specified Notion database for newly added pages. You can create a specific Notion database where you copy the pages you want to store in Supabase.\n - Node: `Page Added in Notion Database`\n\n2. **Retrieve Page Content**:\n - Fetches all block content from the newly added Notion page.\n - Node: `Get Blocks Content`\n\n3. **Filter Non-Text Content**:\n - Excludes blocks of type \"image\" and \"video\" to focus on textual content.\n - Node: `Filter - Exclude Media Content`\n\n4. **Summarize Content**:\n - Concatenates the Notion blocks content to create a single text for embedding.\n - Node: `Summarize - Concatenate Notion's blocks content`\n\n5. **Store in Supabase**:\n - Stores the processed documents and their embeddings into a Supabase table with a vector column.\n - Node: `Store Documents in Supabase`\n\n6. **Generate Embeddings**:\n - Utilizes OpenAI's API to generate embeddings for the textual content.\n - Node: `Generate Text Embeddings`\n\n\n7. **Create Metadata and Load Content**:\n - Loads the block content and creates associated metadata, such as page ID and block ID.\n - Node: `Load Block Content & Create Metadata`\n\n8. **Split Content into Chunks**:\n - Divides the text into smaller chunks for easier processing and embedding generation.\n - Node: `Token Splitter`\n\n\n\n" }, "typeVersion": 1 }, { "id": "3f3e65dc-2b26-407c-87e5-52ba3b315fed", "name": "Embeddings OpenAI", "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi", "position": [ 2200, 760 ], "parameters": { "options": {} }, "typeVersion": 1 }, { "id": "6d2579b8-376f-44c3-82e8-9dc608efd98b", "name": "Token Splitter", "type": "@n8n/n8n-nodes-langchain.textSplitterTokenSplitter", "position": [ 2340, 960 ], "parameters": { "chunkSize": 256, "chunkOverlap": 30 }, "typeVersion": 1 }, { "id": "79b3c147-08ca-4db4-9116-958a868cbfd9", "name": "Notion - Page Added Trigger", "type": "n8n-nodes-base.notionTrigger", "position": [ 1180, 520 ], "parameters": { "simple": false, "pollTimes": { "item": [ { "mode": "everyMinute" } ] }, "databaseId": { "__rl": true, "mode": "list", "value": "", "cachedResultUrl": "", "cachedResultName": "" } }, "typeVersion": 1 }, { "id": "e4a6f524-e3f5-4d02-949a-8523f2d21965", "name": "Notion - Retrieve Page Content", "type": "n8n-nodes-base.notion", "position": [ 1400, 520 ], "parameters": { "blockId": { "__rl": true, "mode": "url", "value": "={{ $json.url }}" }, "resource": "block", "operation": "getAll", "returnAll": true }, "typeVersion": 2.2 }, { "id": "bfebc173-8d4b-4f8f-a625-4622949dd545", "name": "Filter Non-Text Content", "type": "n8n-nodes-base.filter", "position": [ 1620, 520 ], "parameters": { "options": {}, "conditions": { "options": { "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "e5b605e5-6d05-4bca-8f19-a859e474620f", "operator": { "type": "string", "operation": "notEquals" }, "leftValue": "={{ $json.type }}", "rightValue": "image" }, { "id": "c7415859-5ffd-4c78-b497-91a3d6303b6f", "operator": { "type": "string", "operation": "notEquals" }, "leftValue": "={{ $json.type }}", "rightValue": "video" } ] } }, "typeVersion": 2 }, { "id": "b04939f9-355a-430b-a069-b11800066313", "name": "Summarize - Concatenate Notion's blocks content", "type": "n8n-nodes-base.summarize", "position": [ 1920, 520 ], "parameters": { "options": { "outputFormat": "separateItems" }, "fieldsToSummarize": { "values": [ { "field": "content", "separateBy": "\n", "aggregation": "concatenate" } ] } }, "typeVersion": 1 }, { "id": "0e64dbb5-20c1-4b90-b818-a1726aaf5112", "name": "Create metadata and load content", "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader", "position": [ 2320, 760 ], "parameters": { "options": { "metadata": { "metadataValues": [ { "name": "pageId", "value": "={{ $('Notion - Page Added Trigger').item.json.id }}" }, { "name": "createdTime", "value": "={{ $('Notion - Page Added Trigger').item.json.created_time }}" }, { "name": "pageTitle", "value": "={{ $('Notion - Page Added Trigger').item.json.properties.Page.title[0].text.content }}" } ] } }, "jsonData": "={{ $('Summarize - Concatenate Notion's blocks content').item.json.concatenated_content }}", "jsonMode": "expressionData" }, "typeVersion": 1 }, { "id": "187aba6f-eaed-4427-8d40-b9da025fb37d", "name": "Supabase Vector Store", "type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase", "position": [ 2200, 520 ], "parameters": { "mode": "insert", "options": {}, "tableName": { "__rl": true, "mode": "list", "value": "", "cachedResultName": "" } }, "typeVersion": 1 } ], "active": false, "pinData": {}, "settings": { "executionOrder": "v1" }, "versionId": "77f6b6f7-d699-4a7e-b3e7-fe8a60bde7ba", "connections": { "Token Splitter": { "ai_textSplitter": [ [ { "node": "Create metadata and load content", "type": "ai_textSplitter", "index": 0 } ] ] }, "Embeddings OpenAI": { "ai_embedding": [ [ { "node": "Supabase Vector Store", "type": "ai_embedding", "index": 0 } ] ] }, "Filter Non-Text Content": { "main": [ [ { "node": "Summarize - Concatenate Notion's blocks content", "type": "main", "index": 0 } ] ] }, "Notion - Page Added Trigger": { "main": [ [ { "node": "Notion - Retrieve Page Content", "type": "main", "index": 0 } ] ] }, "Notion - Retrieve Page Content": { "main": [ [ { "node": "Filter Non-Text Content", "type": "main", "index": 0 } ] ] }, "Create metadata and load content": { "ai_document": [ [ { "node": "Supabase Vector Store", "type": "ai_document", "index": 0 } ] ] }, "Summarize - Concatenate Notion's blocks content": { "main": [ [ { "node": "Supabase Vector Store", "type": "main", "index": 0 } ] ] } } } ``` ## Verified Execution Output / Benchmark ```text Verified execution output available on the canonical page. ``` ## Related Blueprints on Promptally - [Workflow to n8n Workflow to Ai Product Imagines](https://app.promptally.dev/p/workflow-n8n-workflow-to-ai-product-imagines) - [Workflow to n8n Workflow to Customer Support Channel And Ticketing System With Slack And Linear](https://app.promptally.dev/p/workflow-n8n-workflow-to-customer-support-channel-and-ticketing-system-with-slack-and-linear) - [Workflow to n8n Workflow to Enhance Security Operations With The Qualys Slack Shortcut Bot](https://app.promptally.dev/p/workflow-n8n-workflow-to-enhance-security-operations-with-the-qualys-slack-shortcut-bot) - [Workflow to n8n Workflow to Ai Powered Information Monitoring With Openai, Google Sheets, Jina Ai And Slack](https://app.promptally.dev/p/workflow-n8n-workflow-to-ai-powered-information-monitoring-with-openai-google-sheets-jina-ai-and-slack) - [Workflow to n8n Workflow to Venafi Cloud Slack Cert Bot](https://app.promptally.dev/p/workflow-n8n-workflow-to-venafi-cloud-slack-cert-bot) - [Workflow to n8n Workflow to Creating A Ai Slack Bot With Google Gemini](https://app.promptally.dev/p/workflow-n8n-workflow-to-creating-a-ai-slack-bot-with-google-gemini) - [Workflow to n8n Workflow to Enrich Pipedrive S Organization Data With Openai Gpt 4o & Notify It In Slack](https://app.promptally.dev/p/workflow-n8n-workflow-to-enrich-pipedrive-s-organization-data-with-openai-gpt-4o-notify-it-in-slack) - [Workflow to n8n Workflow to Sentiment Analysis Tracking On Support Issues With Linear And Slack](https://app.promptally.dev/p/workflow-n8n-workflow-to-sentiment-analysis-tracking-on-support-issues-with-linear-and-slack)