AutomationMart
Home/Browse/Build & query RAG system with Google Drive, OpenAI GPT-4o-mini, and Pinecone
n8n

Build & query RAG system with Google Drive, OpenAI GPT-4o-mini, and Pinecone

n8nn8n11 modulesv1.0
OpenAIGoogle Drive

What This Workflow Does This RAG Pipeline in n8n automates document ingestion from Google Drive, vectorizes it using OpenAI embeddings, stores it in Pinecone, and enables chat-based retrieval using LangChain agents. Main Functions: πŸ“‚ Auto-detects new files uploaded to a specific Google Drive folder. 🧠 Converts the file into embeddings using OpenAI. πŸ“¦ Stores them in a Pinecone vector database. πŸ’¬ Allows a user to query the knowledge base through a chat interface. πŸ€– Uses a GPT-4o-mini model wi

At a glance

Build & query RAG system with Google Drive, OpenAI GPT-4o-mini, and Pinecone is a ready-made n8n workflow you import as a workflow JSON file β€” no build required. It connects OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI, Google Drive
Modules
11
Price
Free
Version
v1.0
Build & query RAG system with Google Drive, OpenAI GPT-4o-mini, and Pinecone workflow diagram

About this workflow

What This Workflow Does This RAG Pipeline in n8n automates document ingestion from Google Drive, vectorizes it using OpenAI embeddings, stores it in Pinecone, and enables chat-based retrieval using LangChain agents. Main Functions: πŸ“‚ Auto-detects new files uploaded to a specific Google Drive folder. 🧠 Converts the file into embeddings using OpenAI. πŸ“¦ Stores them in a Pinecone vector database. πŸ’¬ Allows a user to query the knowledge base through a chat interface. πŸ€– Uses a GPT-4o-mini model with LangChain to generate intelligent responses using retrieved context. βš™οΈ Setup Instructions 1. Connect Accounts Ensure these services are connected in n8n: βœ… Google Drive (OAuth2) βœ… OpenAI βœ… Pinecone You can do this in n8n > Credentials > New and use the matching names from the file: Google Drive: "Google Drive account 2" OpenAI: "OpenAi success" Pinecone: "PineconeApi account 2" 2. Folder Setup Upload your documents to this folder in Google Drive: πŸ“ Power Folder The workflow is triggered every minute when a new file is uploaded. 3. Workflow Overview A. File Ingestion Path Google Drive Trigger β€” detects new file. Google Drive (Download) β€” downloads the new file. Recursive Text Splitter β€” splits text into chunks. Default Data Loader β€” loads content as LangChain documents. OpenAI Embeddings β€” converts text chunks into embeddings. Pinecone Vector Store β€” stores them in "ragfile" index. B. Chat Retrieval Path When chat message received β€” AI Agent β€” LangChain agent managing tools. OpenAI Chat Model (GPT-4o-mini) β€” generates replies. Pinecone Vector Store (retrieval) β€” retrieves matching content. Embeddings OpenAI1 β€” helps match queries to document chunks.

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

Create a draft email in Google Mail using ChatGPT for new incoming emails

This automation drafts email responses in Google Mail for new incoming emails using ChatGPT, enhancing your email management and response efficiency.

Free

PT clinic AI cold email sequence generator with GPT4

PT Clinic AI Email Sequence Generator 🧠 What it does This automation generates personalized cold email sequences for uncontacted physical therapy clinics, pulling lead info from Google Sheets and using GPT-4 to create 4 highly-targeted outreach emails β€” all tailored for the PT industry. βœ… Key Benefits Saves 25–40 hours/week of manual email writing Delivers niche, pain-point-driven messages to PT clinic directors Auto-updates your campaign sheet with verified, ready-to-send sequences Scales cold

Free

Generate and Edit Images with OpenAI's GPT-Image-1 Model

This template integrates OpenAI's image generation and editing endpoints via the GPT-Image-1 model to visually create and manipulate images based on prompts. It features base64 conversion, binary handling, and prompt chaining. Perfect for marketing, design, product visuals and creative workflows. πŸ› οΈ Requirements OpenAI account with access to gpt-image-1(probably you need organizations verifications for access to that model) OpenAI API credentials configured in n8n A self-hosted or cloud n8n inst

Free

Extract Data from Zipped Files in Google Drive using Mindee V2

Automatically process archived documents by downloading an archive file from Google Drive, extracting its contents, and sending each file to MindeeV2 for data extraction. This template is meant for bulk-processing without having to schedule triggers for specific files.

Free

Generate and manage short links with GPT-4.1 and data storage

This AI Agent helps you create short links from your original URLs. Each generated short link is automatically stored in a database table for easy management and tracking. --- How It Works 1. Provide a long URL to the Agent. 2. The Agent saves your original link in the database. 3. It generates a short link in the following format: When users open the short link, they are automatically redirected to your o

Free

Monitor Google Drive folder for new files and upload them automatically

Automatically monitor a Google Drive folder for new files and upload them instantly. Streamline file management with Google Drive's watch and upload features.

Free

Look up English vocabulary via Telegram and save results to Notion

Build a personal Telegram bot that looks up English vocabulary and saves every entry to Notion β€” supporting text, voice, and photo input. Send a word by typing, voice message, or photo. The bot auto-detects the input type: voice is transcribed via Whisper, photos are scanned via GPT-4o-mini Vision OCR. A GPT-4.1-mini agent spell-checks and returns the word's definition, translation, part of speech, and an example sentence. The translation language is fully configurable β€” just set TARGETLANGUAG

Free

Automated invoice management with Nextcloud, email and Telegram notifications

This workflow automatically fetches PDF invoices from a Nextcloud folder (/Invoice/Incoming), sends them via email to a fixed recipient (invoice@example.com), sends a Telegram notification, and archives the file to /Invoice/2025/archive. Key Steps: 1. Triggered daily at 8 AM 2. Lists files in /Invoice/Incoming 3. Filters for existing entries 4. Downloads the file 5. Sends the invoice via email 6. Sends a Telegram message with filename 7. Moves the file to archive πŸ“¦ Technologies used: - Nextcloud

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