Notion to Pinecone Vector Store Integration

This n8n workflow triggers on new pages added to a Notion database, retrieves full page content including blocks, filters out non-text elements like images and videos, and concatenates the text into a single processable block. It then splits the text into tokens/chunks, enriches with metadata (page ID, title, creation time), generates semantic embeddings using Google Gemini, and upserts them into a Pinecone vector store.

Benefits include real-time data ingestion (runs every minute), enabling instant availability of Notion knowledge in vector search systems. It saves hours of manual data processing, reduces errors in content handling, and scales effortlessly for growing databases.

Ideal use cases: Building RAG pipelines for sales CRMs to query Notion docs semantically, powering AI chatbots with company knowledge bases, or enhancing search in sales tools. Perfect for sales teams maintaining Notion as a single source of truth for proposals, client info, and strategies.