Self-Hosted AI Knowledge Bot in n8n — Answer from your docs (RAG) and Save It to Notion

Every time a new document is added to your drive, this workflow hands it to OpenAI, which retrieves the right passage from your knowledge base and answers with sources. You get an AI assistant that answers from your own docs without lifting a finger.

difficulty Advancedsetup 25 minresult An AI assistant that answers from your own docs
  1. 1

    Trigger when a new document is added to your drive

    A Google Drive Trigger starts the workflow the moment a new document is added to your drive.

  2. 2

    Retrieve the right context

    A Vector Store node (Pinecone) fetches the most relevant passages from your indexed content so the answer is grounded in your own material.

  3. 3

    Hand it to the AI agent

    An AI Agent node running OpenAI retrieves the right passage from your knowledge base and answers with sources. The prompt is pre-written and scoped to this one job so results stay consistent.

  4. 4

    Deliver the answer

    The result is saved to Notion — with the original for context.

  5. 5

    Add a safety net (optional)

    Insert an IF/human-approval step before anything is published or emailed, so you stay in control until you trust the output.

Frequently asked questions

Can I trust the AI to get the answer right?

The prompt is tightly scoped to one job and you can add a human-approval step in n8n before anything is sent or published. Start with review-mode for a week, and once you trust the output, switch it to fully automatic.

Does this need n8n Cloud or can I self-host?

Either works. The workflow is a standard n8n export, so you can run it on n8n Cloud or on your own self-hosted instance — you only connect your own app credentials.

How do I import the workflow into n8n?

Download the JSON, then in n8n open a new workflow, choose ⋯ → Import from file, and select it. Every trigger, node and connection appears on the canvas; you just add your credentials and activate it.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.