AutomationMart
Home/Browse/Website chatbot with Google Drive knowledge base using GPT-4 and Mistral AI
n8n

Website chatbot with Google Drive knowledge base using GPT-4 and Mistral AI

n8nn8n23 modulesv1.0
OpenAIGoogle DriveLinkedIn

AI-Powered Website Chatbot with Google Drive Knowledge Base Overview This workflow combines website chatbot intelligence with automated document ingestion and vectorization — enabling live Q&A from both chat input and processed Google Drive files. It uses Mistral AI for OCR + embeddings, and Qdrant for vector search. --- Chatbot Flow - Trigger: When chat message received or webhook based upon deployed chatbot - Model: OpenAI gpt-4.1-mini -

At a glance

Website chatbot with Google Drive knowledge base using GPT-4 and Mistral AI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI, Google Drive, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI, Google Drive, LinkedIn
Modules
23
Price
Free
Version
v1.0
Website chatbot with Google Drive knowledge base using GPT-4 and Mistral AI workflow diagram

About this workflow

AI-Powered Website Chatbot with Google Drive Knowledge Base Overview This workflow combines website chatbot intelligence with automated document ingestion and vectorization — enabling live Q&A from both chat input and processed Google Drive files. It uses Mistral AI for OCR + embeddings, and Qdrant for vector search. --- Chatbot Flow - Trigger: When chat message received or webhook based upon deployed chatbot - Model: OpenAI gpt-4.1-mini - Memory: Simple Memory (Buffer Window) - Vector Search Tool: Qdrant Vector Store - Embeddings: Mistral Cloud - Agent: website chat agent - Responds based on chatdbtai Supabase content - Enforces brand tone and informative documents. - Integratration with both: - Embedded chat UI - Webhook --- Document → Knowledge Base Pipeline Triggered manually to keep vector store up-to-date. Steps 1. Google Drive (brand folder) → Fetch files from folder Website kb (ID: 1o3DK9Ceka5Lqb8irvFSfEeB8SVGGOL7) 2. Loop Over Items → For each file: - Set metadata - Download file - Upload to Mistral for OCR - Get Signed URL - Run OCR extraction (mistral-ocr-latest) 3. If OCR success → Pass to chunking pipeline Else → skip and continue 4. Chunking Logic (Code node) - Splits document into 1,000-character JSON chunks - Adds metadata (source, char positions, file ID) 5. Default Data Loader + Text Splitter → Prepares chunks for embedding 6. Embeddings (Mistral Cloud) → Generates embeddings for text chunks 7. Qdrant Vector Store (Insert mode) → Saves embeddings into docragtestkb collection 8. Wait → Optional delay between batches --- Integrations Used | Service | Purpose | Credential | |----------|----------|------------| | Google Drive | File source | Google Drive account 6 rn dbt | | Mistral Cloud | OCR + embeddings | Mistral Cloud account 2 dbt rn | | Qdrant | Vector storage | QdrantApi account | | OpenAI | Chat model | OpenAi account 8 dbt digi | --- Agent System Prompt Summary > “You are the official AI assistant for this website. Use chatdbtai only as your knowledge source. Respond conversationally, list offerings clearly, link blogs, and say ‘I couldn’t find that on this site’ if no match.” --- Key Features - ✅ Automated OCR + chunking → vectorization - ✅ Persistent memory for chat sessions - ✅ Multi-channel (Webhook + Embedded Chat) - ✅ Fully brand-guided, structured responses - ✅ Live data retrieval from Qdrant vector store --- Summary > A unified workflow that turns brand files + web content into a knowledge base that powers a intelligent chatbot — capable of responding to visitors in real time, powered by Mistral, OpenAI, and Qdrant. --- Need Help or More Workflows? Want to customize this workflow for your business or integrate it with your existing tools? Our team at Digital Biz Tech can tailor it precisely to your use case from automation logic to AI-powered enhancements. 💡 We can help you set it up for free — from connecting credentials to deploying it live. Contact: rajeet.nair@digitalbiz.tech Website: LinkedIn: You can also DM us on LinkedIn for any help. ---

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

Detect explicit content in images from Google Drive

Every time a new file is uploaded to your Google Drive folder, Make will automatically upload that file to Eden AI to detect explicit content in images. Created by tech@edenai.co

Free

Voice to podcast script generator with OpenAI & Notion via Telegram

Automated Podcast Note-Taker for Notion 🎙️⚡ Transform voice notes into polished podcast scripts—automatically! ✨ What It Does This n8n workflow instantly converts Telegram voice messages into structured podcast content in Notion, including: ✅ AI-generated transcripts (via OpenAI Whisper) ✅ Smart content analysis (extracts titles, hooks, CTAs, and summaries) ✅ Ready-to-use script outlines (with sections for hooks, key points, transitions & more) ✅ Dual Notion integration (saves metadata to a dat

Free

Automated freelance gig finder with Bright Data & n8n

Description This workflow automatically searches multiple freelance platforms for new gigs matching your skills and requirements. It saves you time by eliminating the need to manually check multiple job boards and sends you alerts for relevant opportunities. Overview This workflow automatically scrapes freelance job boards and platforms for new gigs matching your skills and requirements. It uses Bright Data to access job listings and can notify you of new opportunities or save them to a database

Free

Upload a new user into LinkedIn Matched Audiences from a new lead in Zoho CRM

This template regularly checks for new leads in Zoho CRM and uses the retrieved information to upload new users to LinkedIn Matched Audiences. For the best performance, your contacts should have these fields filled out: 1) First name 2) Last name 3) Email

Free

Auto-respond to Gmail enquiries using GPT-4o, Dumpling AI & LangChain agent

Who is this for? This workflow is perfect for customer support teams, sales departments, or solopreneurs who receive frequent email enquiries and want to automate the initial response process using AI. If you spend too much time answering similar questions, this system helps respond faster and more intelligently—without writing a single line of code. --- What problem is this workflow solving? Manually responding to repeated customer enquiries slows productivity and increases delay.

Free

Create new completions with OpenAI ChatGPT from worksheet rows in Microsoft Excel

Save time by automatically generating completions to any topic, for example, SEO keywords from your content topics. Learn more

Free

Auto-post LinkedIn updates from spreadsheet topics using GPT-4o

How it works: ## This workflow automates the entire LinkedIn content distribution process — from AI-powered post creation to auto-posting on both personal LinkedIn profiles and LinkedIn groups, using GPT-4o and Google Sheets as the content source and control panel. 1. Auto-generates professional LinkedIn posts from spreadsheet topics using GPT-4o. 2. Posts to your LinkedIn profile and multiple groups. 3. Updates status to avoid duplicate posting. 4. Fully customizable and reusable with your spre

Free

Create AI news avatar videos with Dumpling AI, GPT-4o and HeyGen

What this workflow does This workflow automatically generates avatar-style videos from the latest AI-related news using Dumpling AI and HeyGen. It runs every hour, scrapes trending articles, turns them into 30–60 second spoken scripts with GPT-4o, and produces short avatar videos with HeyGen. Finally, it logs the final video URL in a Google Sheet. --- 👤 Who is this for - Newsletters and creators who want to automate AI trend updates - Content marketers generating short-form video c

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