AutomationMart
Home/Browse/Build a RAG-powered AI assistant with OpenAI, Google Drive & Supabase Vector DB
n8n

Build a RAG-powered AI assistant with OpenAI, Google Drive & Supabase Vector DB

n8nn8n12 modulesv1.0
OpenAIGoogle DriveGitHub

Target Audience This guide is designed for developers, data scientists, and AI enthusiasts who want to create intelligent chatbots capable of understanding and using custom data. Whether you are building a research assistant, a customer support bot, or an internal knowledge base tool, this workflow helps you integrate your own documents into an AI chat system. What Is RAG and Why Use It? Retrieval-Augmented Generation (RAG) is an AI architecture that combines information retrieval with

At a glance

Build a RAG-powered AI assistant with OpenAI, Google Drive & Supabase Vector DB is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI, Google Drive, GitHub. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI, Google Drive, GitHub
Modules
12
Price
Free
Version
v1.0
Build a RAG-powered AI assistant with OpenAI, Google Drive & Supabase Vector DB workflow diagram

About this workflow

Target Audience This guide is designed for developers, data scientists, and AI enthusiasts who want to create intelligent chatbots capable of understanding and using custom data. Whether you are building a research assistant, a customer support bot, or an internal knowledge base tool, this workflow helps you integrate your own documents into an AI chat system. What Is RAG and Why Use It? Retrieval-Augmented Generation (RAG) is an AI architecture that combines information retrieval with text generation. Instead of relying solely on a model’s built-in knowledge, RAG retrieves relevant data from external sources—such as your uploaded documents—and feeds it into the AI’s reasoning process. This approach solves a major limitation of traditional language models: their inability to access or recall up-to-date or proprietary information. By using RAG, your chatbot can deliver accurate, context-aware answers drawn directly from your specific data. Use Case Example Consider a scenario where your organization has a collection of internal reports, manuals, or research documents. With RAG, your AI chatbot can answer detailed questions about these materials without exposing sensitive data externally. This setup is ideal for teams working in customer support, technical documentation, education, or data analysis. Workflow Overview Step 1: Upload Your Document Add your document to the Supabase Vector Store using the "Add Document" feature after downloading or linking it via Google Drive. Step 2: Data Retrieval The workflow retrieves and embeds your document’s content into the vector database for efficient search and retrieval. Step 3: AI Query Processing When you ask a question, the AI retrieves the most relevant context from the Supabase Vector Store based on semantic similarity. Step 4: Response Generation The AI combines the retrieved context with its generative capabilities to produce accurate, data-driven responses tailored to your input. Prerequisites Before setting up the workflow, ensure you have the following: A GitHub account A Supabase account A Google Drive document containing your data Basic understanding of APIs and environment configuration Setup Instructions Step 1: Create Accounts Create a GitHub account and clone the repository containing the workflow. Then, create a Supabase account and a new project to generate your API keys. Step 2: Prepare Your Data Upload your data to Google Drive and make it downloadable. Add the document to the Supabase Vector Store using the “Add Document” feature. Step 3: Configure the Environment Set your Supabase keys as environment variables in your workflow configuration. Step 4: Run the Workflow Execute the workflow to connect your document with the AI agent. Once configured, you can start chatting with the AI agent—your responses will now be powered by your own data.

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

Upload webcam pictures from Windy into a folder on Google Drive

This template regularly downloads webcam pictures from Windy and uploads the pictures into a folder on Google Drive. The template is scheduled to run every 15 minutes. You can change the schedule after you set up the template by clicking on the clock icon on the first module.

Free

Create an Archive in CloudConvert with files imported from URLs stored in Google Sheets

Get URLs of files in Google Sheets and create an archive with the files in CloudConvert. Upload the output archive to Google Drive.

Free

Automate patient journey with GPT-4, Twilio & Slack notifications

How It Works ⚙️ This workflow is a comprehensive, AI-powered system that acts as a virtual patient assistant for clinics. It automates the entire patient journey from appointment confirmation to post-procedure follow-up. 1. Appointment Trigger: The workflow starts when a new event is created in your Google Calendar for a patient appointment. 2. AI-Powered Education: The new appointment is sent to an OpenAI (GPT-4) node, which acts as a virtual clinic assistant. It instantly generates a personali

Free

Automate lead capture with AI personalized WhatsApp messages via Unipile & Google Sheets CRM

Inquiry Form to Personalised WhatsApp Message Overview This workflow creates a smart, automated system for capturing leads from an inquiry form, initiating personalized WhatsApp message via Unipile API, and updating your Google Sheet CRM. It uses AI to craft initial outreach messages and logs the success or failure of each message sent, ensuring you track every lead effectively. This automation helps you engage leads quickly and efficiently, without manual effort. Use Case This work

Free

Automate video uploads to YouTube and generate content with ChatGPT

Automate video uploads to YouTube by generating engaging content with ChatGPT. Retrieve files from Dropbox and repeat tasks effortlessly.

Free

Create custom invoice from Shopify orders in Eledo and send it attached to an e-mail in Gmail

Create a custom Invoice from Shopify order using Eledo PDF generator. Then, send the file to the customer by Gmail and in the same time upload it to Google Drive.

Free

Automate email discovery for companies with Anymail Finder, Google Sheets & Telegram alerts

This automation retrieves company information from a Google Sheet, uses the Anymail Finder API to discover email addresses associated with each company, and then writes the results (including the email status) back into the same Google Sheet and send alert on Telegram. --- Key Advantages ✅ Automated Email Discovery: No need for manual lookups—emails are found via the Anymail Finder API in bulk. 🔁 Seamless Google Sheets Integration: Works directly with Google Sh

Free

Course recommendation system for surveys with data tables and GPT-4.1-Mini

Use the n8n Data Tables feature to store, retrieve, and analyze survey results — then let OpenAI automatically recommend the most relevant course for each respondent. --- 🧠 What this workflow does This workflow demonstrates how to use n8n’s built-in Data Tables to create an internal recommendation system powered by AI. It: - Collects survey responses through a Form Trigger - Saves responses to a Data Table called Survey Responses - Fetches a list of available courses

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