AutomationMart
Home/Browse/Build a knowledge base chatbot with OpenAI, RAG and MongoDB vector embeddings
n8n

Build a knowledge base chatbot with OpenAI, RAG and MongoDB vector embeddings

n8nn8n12 modulesv1.0
OpenAI

Who is this for? This template is designed for internal support teams, product specialists, and knowledge managers in technology companies who want to automate ingestion of product documentation and enable AI-driven, retrieval-augmented question answering. What problem is this workflow solving? Support agents often spend too much time manually searching through lengthy documentation, leading to inconsistent or delayed answers. This solution automates importing, chunking, and indexing p

At a glance

Build a knowledge base chatbot with OpenAI, RAG and MongoDB vector embeddings is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI
Modules
12
Price
Free
Version
v1.0
Build a knowledge base chatbot with OpenAI, RAG and MongoDB vector embeddings workflow diagram

About this workflow

Who is this for? This template is designed for internal support teams, product specialists, and knowledge managers in technology companies who want to automate ingestion of product documentation and enable AI-driven, retrieval-augmented question answering. What problem is this workflow solving? Support agents often spend too much time manually searching through lengthy documentation, leading to inconsistent or delayed answers. This solution automates importing, chunking, and indexing product manuals, then uses retrieval-augmented generation (RAG) to answer user queries accurately and quickly with AI. What these workflows do Workflow 1: Document Ingestion & Indexing Manually triggered to import product documentation from Google Docs. Automatically splits large documents into chunks for efficient searching. Generates vector embeddings for each chunk using OpenAI embeddings. Inserts the embedded chunks and metadata into a MongoDB Atlas vector store, enabling fast semantic search. Workflow 2: AI-Powered Query & Response Listens for incoming user questions (can be extended to webhook). Converts questions to vector embeddings and performs similarity search on MongoDB vector store. Uses OpenAI’s GPT-4o-mini model with retrieval-augmented generation to produce direct, context-aware answers. Maintains short-term conversation context using a memory buffer node. Setup Setting up vector embeddings Authenticate Google Docs and connect your Google Docs URL containing the product documentation you want to index. Authenticate MongoDB Atlas and connect the collection where you want to store the vector embeddings. Create a search index on this collection to support vector similarity queries. Ensure the index name matches the one configured in n8n (dataindex). See the example MongoDB search index template below for reference. Setting up chat Configure the AI system prompt in the “Knowledge Base Agent” node to reflect your company’s tone, answering style, and any business rules. Update the workflow description and instructions to help users understand the chat’s purpose and capabilities. Connect the MongoDB collection used for vector search in the chat workflow and update the vector search index if needed to match your setup. Make sure Both MongoDB nodes (in ingestion and chat workflows) are connected to the same collection, with: An embedding field storing vector data, Relevant metadata fields (e.g., document ID, source), and The same vector index name configured (e.g., dataindex). Search Index Example: { "mappings": { "dynamic": false, "fields": { "id": { "type": "string" }, "text": { "type": "string" }, "embedding": { "type": "knnVector", "dimensions": 1536, "similarity": "cosine" }, "source": { "type": "string" }, "docid": { "type": "string" } } } }

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create Facebook ads copy with Google Sheets and ChatGPT: AIDA formula

Craft persuasive Facebook Ads copy using the Attention, Interest, Desire, Action (AIDA) formula with Google Sheets and ChatGPT. Enhance your marketing strategy and improve ad performance effortlessly.

Free

Send a Telegram message using a ChatGPT assistant

This automation sends a Telegram message using a ChatGPT assistant for personalized communication.

Free

Convert YouTube transcripts in Google Sheets to X (Twitter) threads with Apify, OpenAI and RapidAPI

This workflow lets you scrape and convert youtube video transcript to twitter thread using Google sheets, Apify and RapidAPI Workflow summary 1. Get unprocessed youtube video link from google sheet 2. Use youtube trascript scraper to extract transcript from youtube video 3. Feed the youtube transcript to OpenAI model with advanced prompt to convert the transcript to twitter friendly posts/thread 4. Post the thread to 𝕏 from your account using your cookies for authentication 5. Mark the video as

Free

AI blog generator for Shopify product listings: Using GPT-4o and Google Sheets

AI Blog Generator for Shopify Products using GPT-4o The AI Blog Generator is an advanced automation workflow powered by n8n, integrating GPT-4o and Google Sheets to generate SEO-rich blog articles for Shopify products. It automates the entire process — from pulling product data, analyzing images for nutritional information, to producing structured HTML content ready for publishing — with zero manual writing. --- 💡 Key Advantages - 🔗 Shopify Product Sync Autom

Free

Automate lead qualification with RetellAI Phone Agent, OpenAI GPT & Google Sheet

Build a Phone Agent to qualify outbound leads and schedule inbound calls Who is this for? This workflow is designed for sales teams, call centers, and businesses handling both outbound and inbound lead calls who want to automate their qualification, follow-up, and call documentation process without manual intervention. It’s ideal for teams using Google Sheets, RetellAI, OpenAI, and Gmail as part

Free

Create Facebook ads copy with Google Sheets and ChatGPT: Hero's Journey formula

Master Facebook Ads copy creation through Google Sheets and ChatGPT by applying the proven Hero's Journey copywriting formula. Boost engagement and ad performance by telling compelling stories that resonate with your audience.

Free

Automate customer support with Gmail, Google Sheets, ERP data & GPT-4o AI

AI Customer Support Assistant - Cloud Version What this workflow does: This AI-powered customer support automation processes incoming support requests via email or chat, analyzes them using AI, retrieves relevant context, and generates draft responses for support agents. Key Features: ✅ Multi-channel Input: Email & chat triggers ✅ AI-powered Analysis: Extracts sentiment, urgency, and key information ✅ Context Integration: Combines product manuals, ERP data, and support history ✅

Free

🔊 Browser recording audio transcribing and AI analysis with Deepgram and GPT-4o

Overview Transcript Evalu8r V2 is a robust browser-based transcript analysis tool powered by Deepgram’s speech-to-text API and built into an n8n workflow template. This release introduces full in-browser audio recording, device selection, and playback functionality, allowing users to capture and analyze conversations without leaving their browser. Designed for researchers, support teams, podcasters, legal professionals, and analysts, Transcript Evalu8r simplifies how you extract value from voice

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free