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

Chat with Google Drive documents using GPT, Pinecone, and RAG

n8nn8n16 modulesv1.0
OpenAIGoogle Drive

Short Overview Automatically sync files from Google Drive into a searchable AI knowledge base with Pinecone, and answer user queries using GPT-4o with conversational memory. ⸻ 🛠️ Workflow Usage Steps 1. Watch Google Drive for file changes Trigger the workflow when a new file is uploaded or an existing file is updated in a specific Google Drive folder. 2. Download and process the file Retrieve the file, split it into smaller text chunks with a Recursive Character Text Splitter

At a glance

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

About this workflow

Short Overview Automatically sync files from Google Drive into a searchable AI knowledge base with Pinecone, and answer user queries using GPT-4o with conversational memory. ⸻ 🛠️ Workflow Usage Steps 1. Watch Google Drive for file changes Trigger the workflow when a new file is uploaded or an existing file is updated in a specific Google Drive folder. 2. Download and process the file Retrieve the file, split it into smaller text chunks with a Recursive Character Text Splitter, and generate vector embeddings using OpenAI. 3. Store embeddings in Pinecone Save the embeddings in a Pinecone vector database to keep your knowledge base continuously updated and searchable. 4. Search context for chat queries When a user asks a question, query Pinecone for relevant context, combine results with conversational memory, and process them with GPT-4o. 5. Respond with AI-powered answers Provide a concise response (100–200 words) that blends knowledge from your documents with the conversation history. ⸻ ✅ Use Cases • Keep a live, AI-ready knowledge base from your Google Drive files. • Enable team members to query company documents instantly. • Build a personal assistant that stays up to date with your latest uploads. ⚙️ Setup Steps 1. Google Drive • Create a Google Cloud project. • Enable the Google Drive API. • Generate OAuth credentials and connect them in n8n. 2. OpenAI • Sign up at OpenAI. • Copy your API key from the dashboard. • Add it to n8n under Credentials → OpenAI API. 3. Pinecone • Create an account at Pinecone. • Create a new index (e.g., docs-embeddings). • Copy your API key and environment, then add them to n8n under Credentials → Pinecone API. 4. Workflow Configuration • Import this workflow into your n8n instance. • Select the Google Drive folder you want to monitor. • Set the Pinecone index name in the workflow. • Adjust chunk size / overlap in the text splitter if needed. 5. Test the Workflow • Upload a new document to your Google Drive folder. • Run the workflow to confirm embeddings are created and stored in Pinecone. • Ask a sample query and verify the AI returns a context-aware answer.

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

Generate blog posts in WordPress using Perplexity and ChatGPT from Google Sheets rows

This automation generates engaging WordPress blog posts by analyzing every new Google Sheets row employing insights from Perplexity AI and ChatGPT, then publish them directly to your site then update the sheet.

Free

Generate personalized cold email icebreakers from sites with GPT-4 & G-Sheets

Icebreaker Generator powered with ChatGPT This n8n template crawls a company website, distills the content with AI, and produces a short, personalized icebreaker you can drop straight into your cold emails or CRM. Perfect for SDRs, founders, and agencies who want “real research” at scale. Good to know Works from a Google Sheet of leads (domain + LinkedIn, etc.). Handles common scrape failures gracefully and marks the lead’s Status as Error. Uses ChatGPT to summarize pages and craft one con

Free

Add a Mailchimp subcriber & send an Email or create an Asana task & save a file to a Google Drive folder from Airtable

The template works with the following [Airtable base](https://airtable.com/shruEPIPJZVXf2tAY). The scenario is triggered when the 'Preliminary status' field is updated. To achieve that, we created the 'Last modified' field of type 'Last modified time' and chose to watch updates in the 'Preliminary status' field only. Use this template to automatically add a new Mailchimp subscriber and send an Email if the job applicant (see the Airtable base) is not suitable, and create an Asana task and uploa

Free

Update Google Sheets rows with responses from ChatGPT based on new data inputs

This template updates Google Sheets rows with AI-generated responses and parsed JSON from every new row of data on your sheet.

Free

Generate job descriptions from briefing notes with OpenAI and Google Docs

Auto-generate job descriptions from briefing notes with OpenAI and Google Docs Who is this for Recruiters, HR teams, and hiring managers who conduct role briefing conversations and want to convert their meeting notes into polished, structured job descriptions automatically -- without manual copywriting. What this workflow does This workflow watches a Google Drive folder for new briefing documents, extracts structured job data using AI, generates a professional HTML job description, sends it to M

Free

Ingest Excel data into Oracle and chat with it using Select AI and Azure OpenAI

Overview This n8n workflow template enables querying Excel data stored in an Oracle Database using natural language powered by Oracle Select AI. The solution consists of two workflows: - Workflow A uploads an Excel file, creates a table in Oracle Database, inserts the data, and registers the table with Oracle Select AI. - Workflow B provides a chat interface that allows users to query the uploaded data using natural language. User questions are translated into SQL by Oracle Select AI, executed d

Free

Custom Discord notifications for Radarr, Sonarr, Bazarr etc.

This is a simple temlate that will allow you to customise the notifications in Radarr, Sonarr, Bazarr and similar. By default the notifications are configured to be sent to discord and look similar to the default ones but are just minimalistic. All you need to configure is in your Radarr etc. instances to have Webhook notification type and here point to your Discord channel webhook.

Free

Summarize PDFs with Groq AI and convert to audio using Qwen TTS

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. How it works - User Uploads PDF : The workflow accepts a PDF via webhook. - Extract Text : n8n extracts the text content from the PDF. - Summarize with AI : The extracted text is passed to an AI model (Groq) with OpenAI model for summarization. - Generate Audio : The summary text is sent to a TTS (Text-to-Speech) API (Qwen-TTS-Demo), you can use other free alternatives. -

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