Knowledge Base Sync: Notion to Pinecone Vector Store Integration - n8n Workflow
Use this powerful n8n workflow to automatically sync Notion database pages to a Pinecone vector store using Gemini embeddings. Essential n8n templates for building real-time RAG systems.
Workflow Preview
Ready to automate?
Download this n8n workflow template and start using it instantly.
Who is this best for?
- AI/ML developers requiring a live synchronization pipeline for RAG knowledge bases.
- Content Managers who use Notion as their source of truth and need real-time vector indexing.
- n8n specialists looking for advanced n8n templates involving vector databases and large language models.
- Users seeking an automated process to keep Pinecone indexes fresh whenever a new page is created in Notion.
Overview
Maintaining a current and accurate knowledge base is critical for high-performance Retrieval-Augmented Generation (RAG) applications. This sophisticated n8n workflow provides a fully automated pipeline to ensure that any new page added to a specified Notion database is instantly processed, converted into vectors, and stored in a Pinecone index.
This n8n template utilizes powerful LangChain integrations for text splitting and embedding generation via Google Gemini, ensuring dimension 768 vector output suitable for modern RAG architectures. By leveraging the low-code power of n8n, developers can deploy a robust indexing service without needing complex custom middleware. This reliable n8n node configuration significantly reduces latency and manual effort associated with updating your vector store.
How it Works
This n8n workflow initiates its process using a dedicated n8n trigger.
- Trigger and Retrieval: The
Notion - Page Added Triggeracts as the starting point, listening for new pages created in a specified Notion database. Once triggered, the n8n workflow immediately fetches the full block content using theNotion - Retrieve Page Contentn8n node. - Data Cleaning: The flow proceeds to the
Filter Non-Text Contentn8n node, which ensures only relevant textual information is processed by explicitly removing blocks identified as 'image' or 'video'. - Concatenation and Preparation: The filtered content blocks are then consolidated into a single document string using the
Summarize - Concatenate Notion's blocks contentn8n node. - Document Loading and Metadata: The
Create metadata and load contentn8n node prepares the document. It attaches crucial metadata (Page ID, Created Time, Page Title) pulled from the original n8n trigger event, alongside the concatenated content. - Chunking: The document is prepared for optimal embedding via the
Token Splittern8n node. This essential RAG preparation step ensures chunks are manageable (256 tokens, 30 overlap) for vector creation. - Embedding Generation: The prepared chunks are passed to the
Embeddings Google Geminin8n node, which uses the specified embedding model (models/text-embedding-004) to generate dense, 768-dimensional vector representations. - Vector Insertion: Finally, the generated vectors, along with their associated metadata, are inserted into the designated 'notion-pages' index in the Pinecone Vector Store using the dedicated n8n node. This completes the automatic synchronization implemented by this complex n8n workflow.
Installation Guide
To install and utilize this n8n workflow, follow these steps:
- Import: Copy the provided JSON data and paste it into your n8n instance using the 'New' -> 'Import from JSON' feature.
- Credentials Setup:
Auto: Notion). Ensure the integration has access to the database specified in the n8n trigger n8n node.Google Gemini: Set up credentials for the
Google Gemini (PaLM) Api account to enable vector embedding generation.* Pinecone: Configure the
Auto: PineconeApi credentials, ensuring you specify the correct Pinecone environment and API key.- Configuration: Verify the
Notion - Page Added Triggern8n node points to the correct database ID (currently set to17b11930-c10f-8000-a545-ece7cade03f9). - Activation: Once credentials and configurations are verified, activate the n8n workflow by toggling the 'Active' switch.
Node Details
- Notion - Page Added Trigger (n8n trigger):
- Key Configuration: Polls every minute (
everyMinute).- Notion - Retrieve Page Content (n8n node):
- Key Configuration: Uses expression
={{ $json.url }} to dynamically fetch content based on the triggered page URL.- Filter Non-Text Content (n8n node):
- Key Configuration: Two conditions set to
notEquals operator for 'image' and 'video'.- Summarize - Concatenate Notion's blocks content (n8n node):
- Key Configuration: Aggregation is 'concatenate' on the
content field.- Token Splitter (n8n node):
- Key Configuration: Chunk Size 256, Chunk Overlap 30.
- Create metadata and load content (n8n node):
- Embeddings Google Gemini (n8n node):
- Key Configuration: Model set to
models/text-embedding-004.- Pinecone Vector Store (n8n node):
- Key Configuration: Mode is 'insert', targeting the index named 'notion-pages'.
Related n8n Workflows
Notion Database Entry to NextCloud OneNote Sync
Use this powerful n8n workflow to automatically create and synchronize new OneNote files in NextCloud/WebDAV whenever a new entry is added to a Notion database, complete with robust locking logic.
Notion Knowledge Base Retrieval Augmented Generation (RAG) Assistant
Build a Retrieval Augmented Generation (RAG) assistant using this n8n workflow. Connect OpenAI's GPT-4o to your Notion database for instant, accurate answers from internal company data.
Notion Status Change Alerts to Communication Channels (Slack, Email, etc.)
Automate instant alerts when Notion database items change status. Use this powerful n8n workflow to trigger notifications in Slack, Telegram, WhatsApp, Discord, or Email automatically.
AI Nutrition Tracker and Meal Logger via Telegram and Gemini
Use this powerful n8n workflow to create a private AI nutrition assistant in Telegram. Log meals instantly via text, voice, or image, analyze macros using Gemini, and store data in Google Sheets.
Secure OAuth Token Generation and Management with Airtable
Create a secure OAuth-like token generation system using this powerful n8n workflow template. Validate client credentials against Airtable and issue bearer tokens instantly.
Automated OAuth2 Configuration Finder Using AI
Use this n8n workflow to automatically find crucial OAuth2 settings, including Authorization URIs and Token URIs, for any service using advanced AI models via OpenRouter. This n8n templates solution guarantees structured, confidence-scored output.
Hi, I’m Udit, an Acquia-certified developer with a strong background in web development and creating enterprise solutions. Recently, I’ve transitioned into AI and ML, I hold DIAT Professional AI Certification. I specialize in building AI-driven automation to streamline workflows, improve efficiency, and solve complex problems. With expertise in AI/ML tools and years of experience in Acquia and Drupal, I’m passionate about leveraging tech to drive innovation and create smarter solutions.
Featured*
