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

Workflow updated on 17/06/2024: Added 'Summarize' node to avoid creating a row for each Notion content block in the Supabase table.

Store Notion's Pages as Vector Documents into Supabase

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 Langchain Guide](https://supabase.com/docs/guides/ai/langchain?queryGroups=database-method&database-method=sql)

Workflow Description

This workflow automates the process of storing Notion pages as vector documents in a Supabase database with a vector column. The steps are as follows:

1. Notion Page Added Trigger: - 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. - Node: Page Added in Notion Database

2. Retrieve Page Content: - Fetches all block content from the newly added Notion page. - Node: Get Blocks Content

3. Filter Non-Text Content: - Excludes blocks of type "image" and "video" to focus on textual content. - Node: Filter - Exclude Media Content