AutomationMart
Home/Browse/AI-Powered RAG Document Processing & Chatbot with Google Drive, Supabase, OpenAI
n8n

AI-Powered RAG Document Processing & Chatbot with Google Drive, Supabase, OpenAI

n8nn8n27 modulesv1.0
GmailOpenAIGoogle DriveGemini

Who is this for? This workflow is perfect for: Businesses and teams who need an automated solution to organize, analyze, and retrieve insights from their internal documents. Researchers who want to quickly analyze and query large collections of research papers, reports, or datasets. Customer support teams looking to streamline access to product documentation and support resources. Legal and compliance professionals needing to reference and query legal documents with confidence.

At a glance

AI-Powered RAG Document Processing & Chatbot with Google Drive, Supabase, OpenAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, OpenAI, Google Drive, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, OpenAI, Google Drive, Gemini
Modules
27
Price
Free
Version
v1.0
AI-Powered RAG Document Processing & Chatbot with Google Drive, Supabase, OpenAI workflow diagram

About this workflow

Who is this for? This workflow is perfect for: Businesses and teams who need an automated solution to organize, analyze, and retrieve insights from their internal documents. Researchers who want to quickly analyze and query large collections of research papers, reports, or datasets. Customer support teams looking to streamline access to product documentation and support resources. Legal and compliance professionals needing to reference and query legal documents with confidence. AI enthusiasts and developers wanting to implement Retrieval-Augmented Generation (RAG) systems without starting from scratch. What problem is this workflow solving? Manually organizing, processing, and searching through documents can be time-consuming, error-prone, and inefficient. This workflow solves that by: Automating document processing from Google Drive, supporting multiple formats like PDFs, CSVs, and Google Docs. Extracting, chunking, and enhancing document text, preserving context and improving AI comprehension. Storing vector embeddings in a secure, scalable Supabase vector database, enabling semantic search and retrieval. Providing an interactive AI chat interface that allows users to ask natural language questions and get precise, document-based answers. This means teams can quickly access relevant insights from their document repositories—boosting productivity and ensuring accurate information retrieval. Key Features 🚀 End-to-End Document Processing: From Google Drive upload detection to vector embedding and storage. 🔍 Semantic Search & Retrieval: Users can ask complex, natural-language questions and receive contextually relevant answers. 🤖 AI-Powered Summaries & Metadata: Automatically generates document titles and summaries using Google Gemini AI. 📝 Smart Chunking & Contextual Enhancement: Breaks documents into smart chunks with overlap, preserving context and table integrity. 🔐 Secure & Scalable Vector Database: Stores and retrieves embeddings in a Supabase vector store for fast, reliable searches. 💬 Conversational AI Interface: Uses OpenAI to power natural, accurate, and cost-effective AI chat interactions. How does this workflow work? Monitors Google Drive for new files Extracts text from PDFs and CSVs (or Google Docs auto-converted) Splits text into context-preserving chunks Enhances chunk quality and stores embeddings in Supabase Enables natural language search and AI-powered chat interactions with the stored documents Typical Use Cases 📚 Corporate Knowledge Base 🔬 Research Paper Analysis 📞 Customer Support Document Query ⚖️ Legal Document Review and Analysis 🔍 Internal Team Documentation Search Why You’ll Love It This workflow lets you build a scalable, searchable, and AI-powered document system—without needing to write complex code or manage multiple systems. With this, you can: Stay organized with automated document processing. Deliver faster, more accurate answers to user queries. Reduce manual work and improve productivity. Gain a competitive edge with cutting-edge AI search capabilities. Setup Requirements An n8n instance with Google Drive, Supabase, OpenAI, and Gemini credentials configured. Access to a Supabase vector store for storing document embeddings. Configurable chunk size, overlap, and processing limits (default: 1000 characters per chunk, 20 chunks max). Contact me for consulting and support: 📧 billychartanto@gmail.com

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

Summarize YouTube videos with transcription, DeepSeek AI and Google Sheets

Tired of manually watching long YouTube videos just to extract the main points? With our YouTube Transcript & Summary Automation, you can instantly turn any video into an actionable, AI-generated summary — all from a simple Google Sheet. What this automation does: Reads video URLs from Google Sheets (just add your links!) Generates accurate transcripts using Supadata.ai — with 100 free uses/month Creates a smart summary using DeepSeek AI: 🔹 Short summary of the video 🔹 Key points 🔹 Main topics Y

Free

Automating SAP B1 journal entries using JSON, Google Sheets, and GPT-4o

HOW IT WORKS: This workflow automates the creation of Journal Entries in SAP Business One (SAP B1). Depending on the source of the input data, it dynamically transforms and sends accounting records in the appropriate format using the Service Layer API. It supports three input types: - 📦 JSON payloads - 📊 Google Sheets data - 🧑‍💻 Manual structured entries (via prompt + LLM) Each transaction is logged to Google Sheets for traceability. 🔹 1. Webhook Input Reception A Webhook node waits for a POST r

Free

Create Excel and PDF documents with Plumsail and send them in Gmail

Run this scenario manually to create Excel and PDF files with Plumsail Documents. It uses a template stored in Google Drive and sends an email with the documents through Gmail.

Free

Evaluate AI workflows using Google Sheets, Gemini, Claude, GPT, and Perplexity

This template and YouTube video goes over 5 different implementations of evaluations within n8n. - Categorization - Correctness - Tools used - String similarity - Helpfulness You’ll learn when to use each type, how to set up test datasets in Google Sheets or data tables, and how to track your results over time. I also explain best practices like only changing one variable at a time, documenting your prompts and model settings, and building proper training datasets with enough examples to confi

Free

Create Facebook ads copy with Notion and ChatGPT: BAB formula

Craft compelling Facebook Ads copy using Notion and ChatGPT with the Before After Bridge (BAB) framework. Elevate your marketing strategy by creating persuasive, targeted ad content that bridges the gap between your audience's current state and their desired outcome.

Free

Filter breaking geopolitical news with AI scoring & Telegram alerts

Geopolitics Breaking News Alert System Workflow Name: Geopolitics Breaking News Alert System Author: Devjothi Dutta Category: Productivity, News & Media, AI/Machine Learning Complexity: Medium Setup Time: 45-60 minutes --- --- 📖 Description An intelligent geopolitical monitoring system that filters 200+ daily news articles down to only the critical breaking news that matters to you. This workflow uses smart keyword filtering and

Free

Automate social media content with AI for Instagram, Facebook, LinkedIn & X

AI Social Media Content Automation – n8n Workflow This workflow is built for creators, solopreneurs, SaaS founders, and agencies looking to automate their social media content process from idea to publication. It combines the power of OpenAI, Google Sheets, and official APIs for Instagram, Facebook, X (Twitter), and LinkedIn to deliver fully automated, brand-consistent social media posts — including text, images, hashtags, CTAs, and scheduling. No more switching tools, rewriting content, or forg

Free

BeyondPresence sales intelligence → real-time lead scoring

Monitor BeyondPresence video agent conversations in real-time to automatically score leads (0-100+) based on buying signals and send instant Slack alerts when hot opportunities or competitors are mentioned. This template helps sales teams prioritize leads immediately, never miss competitor mentions, and respond to high-intent prospects while they're still engaged. How it works - Real-time webhook processes each user message as it happens during calls - Scoring engine analyzes for buying signals

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