AutomationMart
Home/Browse/Chat with Google Drive documents using Pinecone and OpenAI RAG
n8n

Chat with Google Drive documents using Pinecone and OpenAI RAG

n8nn8n30 modulesv1.0
OpenAIGoogle Drive

Google Drive → Pinecone RAG Chatbot (Auto-Sync & Query) This n8n workflow implements a fully automated Retrieval-Augmented Generation (RAG) pipeline powered by Google Drive, OpenAI embeddings, and Pinecone. It continuously keeps a vector database in sync with your company documents and exposes them through an AI chat interface. What this workflow does The workflow monitors a Google Drive folder and automatically reacts to document lifecycle events: - File created - File updated - File deleted Wh

At a glance

Chat with Google Drive documents using Pinecone and OpenAI RAG 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
30
Price
Free
Version
v1.0
Chat with Google Drive documents using Pinecone and OpenAI RAG workflow diagram

About this workflow

Google Drive → Pinecone RAG Chatbot (Auto-Sync & Query) This n8n workflow implements a fully automated Retrieval-Augmented Generation (RAG) pipeline powered by Google Drive, OpenAI embeddings, and Pinecone. It continuously keeps a vector database in sync with your company documents and exposes them through an AI chat interface. What this workflow does The workflow monitors a Google Drive folder and automatically reacts to document lifecycle events: - File created - File updated - File deleted When a document is added or updated: - The file is downloaded from Google Drive - Its content is chunked using a recursive text splitter - Embeddings are generated with OpenAI - Vectors are stored or updated in Pinecone When a document is deleted: The corresponding vectors are removed from Pinecone, keeping the index clean and consistent On the chat side: - A conversational AI agent retrieves relevant vectors from Pinecone - Context is injected into the prompt - The assistant answers questions grounded only on your documents Key features - End-to-end RAG pipeline (ingestion + retrieval + chat) - Automatic vector updates on file changes - Idempotent design (safe re-runs, no duplicated vectors) - Google Drive as a live knowledge source - Pinecone as scalable vector storage - OpenAI embeddings and chat models - Ready-to-use AI chat interface inside n8n Typical use cases - Internal company knowledge base - AI assistant for policies, manuals, and documentation - Team chat over shared Google Drive files - Lightweight alternative to full-blown document search platforms - Prototyping and production RAG systems Who this template is for - n8n users building AI-powered workflows - Teams working with Google Drive documents - Developers implementing RAG architectures - Anyone who wants a self-hosted, controllable, and transparent AI document chatbot This template is designed to be robust, maintainable, and production-ready, while remaining easy to extend with additional data sources, metadata filtering, or alternative LLM providers.

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

Send automated emails using ChatGPT completions and a custom webhook

This template automates your email marketing by sending personalized emails using ChatGPT completions and a custom webhook. Trigger emails with Google Email integration.

Free

Automate competitor research with Exa.ai, Notion and AI agents

This n8n workflow demonstrates a simple multi-agent setup to perform the task of competitor research. It showcases how using the HTTP request tool could reduce the number of nodes needed to achieve a workflow like this. How it works For this template, a source company is defined by the user which is sent to Exa.ai to find competitors. Each competitor is then funnelled through 3 AI agents that will go out onto the internet and retrieve specific datapoints about the competitor; company overview,

Free

Send webhook responses using ChatGPT for custom webhooks

This template sends responses to custom webhooks using Perplexity AI. Trigger interactions with a Custom WebHook, generate responses with Perplexity AI, and respond via Webhook Response.

Free

Escalate payment issues with Azure OpenAI, Google Sheets, Slack and Zendesk

Description This workflow automates payment-related customer support escalation by validating reported issues against transaction data and coordinating all downstream actions in a controlled, auditable way. It is designed for support teams that need to quickly separate valid payment failures from false or incomplete reports—while maintaining consistent customer communication and timely human intervention. The workflow is triggered via a webhook whenever an external system reports a customer issu

Free

Send replies on Telegram based on updates from Google Docs and ChatGPT completions

Automatically respond to Telegram updates using insights from Google Docs and ChatGPT. Enhance communication by integrating Telegram, Google Docs, and OpenAI.

Free

Generate blogs with GPT-4o prompt chaining: outline, evaluate & publish to Sheets

Description This n8n automation template delivers a full-stack AI content pipeline designed for marketing teams, content creators, SaaS founders, and growth hackers. It combines prompt chaining, GPT-4o agents, and Google Sheets to generate engaging, SEO-friendly blogs—end to end. What This Template Does: 📝 Generates blog topic ideas using a domain-specific AI agent (e.g., for Sparrow API testing) 📄 Creates a blog outline with key sections and headings ✅ Evaluates & refines the outline to ensure

Free

Create lyric posters from Spotify tracks with Musixmatch and OpenAI

Turn a song into a ready-to-hang poster, by using Musixmatch and AI This n8n workflow turns a song title and artist name into a gallery-ready poster by combining Musixmatch lyric intelligence with a tightly controlled AI art direction pipeline. At its core, Musixmatch is used to identify the correct song and retrieve official lyrics, which then drive a highly curated image-generation prompt and final poster artwork. --- What this workflow does 1. Trigger via chat - The workflow starts when a ch

Free

Bridge iMessage and Slack threads with Blooio for two-way messaging

Turn any Slack channel into your team's iMessage inbox. How it works 📱 → Customer texts your business number 🔵 → Blooio pushes the webhook into n8n 💬 → n8n posts a new thread in Slack 🧵 → Your team replies in the thread 🔵 → n8n sends the reply through Blooio 📱 → Customer gets a blue-bubble iMessage Why this matters | What you get | Why it matters | |--------------|----------------| | 💙 Blue bubbles, not green | iMessage open rates blow past SMS. People read texts from friends — not fr

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