AutomationMart
Home/Browse/RAG chatbot for company documents using Google Drive and Gemini
n8n

RAG chatbot for company documents using Google Drive and Gemini

n8nn8n15 modulesv1.0
Google DriveGemini

This workflow implements a Retrieval Augmented Generation (RAG) chatbot that answers employee questions based on company documents stored in Google Drive. It automatically indexes new or updated documents in a Pinecone vector database, allowing the chatbot to provide accurate and up-to-date information. The workflow uses Google's Gemini AI for both embeddings and response generation. How it works The workflow uses two Google Drive Trigger nodes: one for detecting new files added to a speci

At a glance

RAG chatbot for company documents using Google Drive and Gemini is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Drive, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Drive, Gemini
Modules
15
Price
Free
Version
v1.0
RAG chatbot for company documents using Google Drive and Gemini workflow diagram

About this workflow

This workflow implements a Retrieval Augmented Generation (RAG) chatbot that answers employee questions based on company documents stored in Google Drive. It automatically indexes new or updated documents in a Pinecone vector database, allowing the chatbot to provide accurate and up-to-date information. The workflow uses Google's Gemini AI for both embeddings and response generation. How it works The workflow uses two Google Drive Trigger nodes: one for detecting new files added to a specified Google Drive folder, and another for detecting file updates in that same folder. 1. Automated Indexing: When a new or updated document is detected 2. The Google Drive node downloads the file. 3. The Default Data Loader node loads the document content. 4. The Recursive Character Text Splitter node breaks the document into smaller text chunks. 5. The Embeddings Google Gemini node generates embeddings for each text chunk using the text-embedding-004 model. 6. The Pinecone Vector Store node indexes the text chunks and their embeddings in a specified Pinecone index. 7.The Chat Trigger node receives user questions through a chat interface. The user's question is passed to an AI Agent node. 8. The AI Agent node uses a Vector Store Tool node, linked to a Pinecone Vector Store node in query mode, to retrieve relevant text chunks from Pinecone based on the user's question. 9. The AI Agent sends the retrieved information and the user's question to the Google Gemini Chat Model (gemini-pro). 10. The Google Gemini Chat Model generates a comprehensive and informative answer based on the retrieved documents. 11. A Window Buffer Memory node connected to the AI Agent provides short-term memory, allowing for more natural and context-aware conversations. Set up steps 1. Google Cloud Project and Vertex AI API: Create a Google Cloud project. Enable the Vertex AI API for your project. 2. Google AI API Key: Obtain a Google AI API key from Google AI Studio. 3. Pinecone Account: Create a free account on the Pinecone website. Obtain your API key from your Pinecone dashboard. Create an index named company-files in your Pinecone project. 4. Google Drive: Create a dedicated folder in your Google Drive where company documents will be stored. 5. Credentials in n8n: Configure credentials in your n8n environment for: Google Drive OAuth2 Google Gemini(PaLM) Api (using your Google AI API key) Pinecone API (using your Pinecone API key) 5. Import the Workflow: Import this workflow into your n8n instance. 6. Configure the Workflow: Update both Google Drive Trigger nodes to watch the specific folder you created in your Google Drive. Configure the Pinecone Vector Store nodes to use your company-files index.

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

Adaptive RAG with Google Gemini & Qdrant: context-aware query answering

Description This workflow automatically classifies user queries and retrieves the most relevant information based on the query type. 🌟 It uses adaptive strategies like; Factual, Analytical, Opinion, and Contextual to deliver more precise and meaningful responses by leveraging n8n's flexibility. Integrated with Qdrant vector store and Google Gemini, it processes each query faster and more effectively. 🚀 How It Works? Query Reception: A user query is triggered (e.g., through a chatbot interface).

Free

Generate and publish AI short videos using Gemini, Sora-2, Apify, and Google Sheets

1. Overview This workflow automates the process of collecting viral content ideas, generating videos using AI services, and publishing posts to social media platforms. It uses scheduled triggers and external APIs to run the entire content pipeline with minimal manual input. Google Sheets is used as the central data layer to store ideas, track processing status, and prevent duplicate content. The workflow is designed to support continuous content production by connecting idea discovery, content g

Free

BrowserAct Powers Telegram Bot AI Music Recommendations for Spotify Blueprint

Automate AI-powered data processing and Telegram delivery. Stop manual tasks—get intelligent, routed results in Telegram. WHAT IT DOES: Triggers via Telegram Bot for user requests/file inputs Uses Google Gemini AI for content analysis/generation Leverages BrowserAct + Iterator for multi-item web scraping Processes data with Make AI Toolkit/Tools for customization Delivers results to multiple Telegram Bot channels Runs automatically on Telegram triggers HOW IT WORKS: Telegram Bot initiates workfl

Free

Automatic media download from WhatsApp Business messages with HTTP storage

This workflow listens for incoming WhatsApp messages that contain media (e.g., images) and automatically downloads the media file using WhatsApp's private media URL. - The trigger node activates when a WhatsApp message with media is received. - The media ID is extracted from the message payload. - A private media URL is retrieved using the media ID. - The media file is downloaded using an authenticated HTTP request. Ideal for: - Archiving WhatsApp media to external systems. - Triggering further

Free

Extract and process information directly from PDF using Claude and Gemini

Overview - This workflow helps you compare Claude 3.5 Sonnet and Gemini 2.0 Flash when extracting data from a PDF - This workflow extracts and processes the data within a PDF in one single step, instead of calling an OCR and then an LLM” How it works - The initial 2 steps download the PDF and convert it to base64. - This base64 string is then sent to both Claude 3.5 Sonnet and Gemini 2.0 Flash to extract information. - This workflow is made to let you compare results, latency, and cost (in their

Free

Enhance Chat Responses with Real-Time Search via Bright Data MCP & Gemini AI

Disclaimer This template is only available on n8n self-hosted as it's making use of the community node for MCP Client. Who this is for? The Chat Conversations with Bright Data MCP Search Engines & Google Gemini workflow is designed for users who need real-time, AI-enhanced conversations powered by live search engine results. This workflow is tailored for:​ 1. Data Analysts - Who want live, search-based data fused with AI reasoning. 2. Marketing Researchers - Seeking up-to-the-minute market or c

Free

VEO3 video generator with AI optimization and Google Drive storage

Welcome to my VEO3 Video Generator Workflow! This automated workflow transforms simple text descriptions into professional 8-second videos using Google's cutting-edge VEO3 AI model. Users submit video ideas through a web form, and the system automatically generates optimized prompts, creates high-quality videos with native audio, and delivers them via Google Drive - all powered by Claude 4 Sonnet for intelligent prompt optimization. This workflow has the followi

Free

Company knowledge base agent (RAG)

Overview Turn your docs into an AI-powered internal or public-facing assistant. This chatbot workflow uses RAG (Retrieval-Augmented Generation) with Supabase vector search to answer employee or customer questions based on your company documents—automatically updated via Google Drive. Whether it’s deployed in Telegram or embedded on your website, this agent supports voice and text input, transcribes voice messages, pulls relevant context from your internal files, and responds with a helpful,

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