AutomationMart
Home/Browse/RAG-powered document chat with Google Drive, OpenAI, and Pinecone Assistant
n8n

RAG-powered document chat with Google Drive, OpenAI, and Pinecone Assistant

n8nn8n10 modulesv1.0
DiscordOpenAIGoogle Drive

Try it out This n8n workflow template lets you chat with your Google Drive documents (.docx, .json, .md, .txt, .pdf) using OpenAI and Pinecone Assistant. It retrieves relevant context from your files in real time so you can get accurate, context-aware answers about your proprietary data—without the need to train your own LLM. What is Pinecone Assistant? Pinecone Assistant allows you to build production-grade chat and agent-based applications quickly. It abstracts the complexities of implementing

At a glance

RAG-powered document chat with Google Drive, OpenAI, and Pinecone Assistant is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Discord, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Discord, OpenAI, Google Drive
Modules
10
Price
Free
Version
v1.0
RAG-powered document chat with Google Drive, OpenAI, and Pinecone Assistant workflow diagram

About this workflow

Try it out This n8n workflow template lets you chat with your Google Drive documents (.docx, .json, .md, .txt, .pdf) using OpenAI and Pinecone Assistant. It retrieves relevant context from your files in real time so you can get accurate, context-aware answers about your proprietary data—without the need to train your own LLM. What is Pinecone Assistant? Pinecone Assistant allows you to build production-grade chat and agent-based applications quickly. It abstracts the complexities of implementing retrieval-augmented (RAG) systems by managing the chunking, embedding, storage, query planning, vector search, model orchestration, reranking for you. Prerequisites A Pinecone account A GCP project with Google Drive API enabled and configured An Open AI account and API key Setup 1. Create a Pinecone Assistant named n8n-assistant in the Pinecone Console here 2. Setup your Google Drive OAuth2 API credential in n8n 1. In the File added node -> Credential to connect with, select Create new credential 2. Set the Client ID and Client Secret from the values generated in the prerequisites 3. Set the OAuth Redirect URL from the n8n credential in the Google Cloud Console (instructions) 4. Name this credential Google Drive account so that other nodes reference it 3. Use the Connect to Pinecone button to authenticate to Pinecone or if you self-host n8n, create a Pinecone credential and add your Pinecone API key directly 4. Select your Assistant Name in each of the Pinecone Assistant nodes 5. Setup the Open AI credential in n8n 1. In the OpenAI Chat Model node -> Credential to connect with, select Create new credential 2. Set the API Key field to your OpenAI API key 6. Add your files to a Drive folder named n8n-pinecone-demo in the root of your My Drive 1. If you use a different folder name, you'll need to update the Google Drive triggers to reflect that change 7. Activate the workflow or test it with a manual execution to ingest the documents 8. Chat with your docs! Ideas for customizing this workflow - Customize the System Message on the AI Agent node to your use case to indicate what kind of knowledge is stored in Pinecone Assistant - Change the Top K and/or Snippet Size values to help manage token consumption by adding the Top K and/or Snippet Size parameters to Get context from Assistant node - Filter the context snippets even further by adding metadata filters to the Get context from Assistant node Need help? You can find help by asking in the Pinecone Discord community or filing an issue on this repo.

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

🎦🚀 YouTube video comment analysis agent

YouTube Video Comment Analysis Agent This n8n workflow is designed to help YouTube creators analyze video details and comments to generate a comprehensive and actionable report. The workflow provides insights into video performance, audience engagement, and viewer feedback, helping creators identify trends, interests, and opportunities for future content creation. --- ✨ Key Features 1. Video Performance Analysis: Extracts metrics like views, likes, and comments to evaluate the video's success. 2

Free

Generate SEO keywords with AI: topic to keyword list in seconds

Who is this template for? This AI Keyword Generator workflow template is designed for marketers, SEO specialists, and content creators who need to quickly generate high-quality keyword lists for their content strategy. Instead of spending hours researching keywords manually, this AI-powered tool delivers targeted keyword suggestions based on your specific criteria. What problem does this workflow solve? Keyword research is a time-consuming but essential part of SEO and content marketing. Many pr

Free

🐶 AI Petshop Assistant with GPT-4o, Google Calendar & WhatsApp/Instagram/FB

Hi! I’m Amanda 🐶💕 This is honestly one of the cutest, smartest workflows I’ve ever built. It was designed with a lot of love to help petshops give their customers fast, modern, and sweet service — without losing the personal touch. Imagine a client sending a message on WhatsApp, Instagram or Messenger, and in seconds, they’re greeted with a kind message, a helpful menu, and everything they need. No delays. No stress. Just smooth, intelligent automation. This AI agent chats, books, checks, confir

Free

Automate YouTube Shorts creation from Telegram prompts using Gemini and VEO

Who this workflow is for This workflow is designed for content creators, marketing teams, and automation builders who want to produce short-form video content at scale without manual editing. It is especially useful for teams posting consistently to YouTube Shorts, Instagram Reels, or TikTok who want a repeatable, automated content pipeline driven by AI. --- What this workflow does This n8n automation converts a single Telegram message into a fully generated short-form video using AI. When a mes

Free

Turn an image into a cinematic video with NanoBanana Ultra, Kling, Blotato

AI Image → Professional Video Workflow (NanoBanana Ultra + Kling AI + Blotato) --- 📄 Documentation: Notion Guide 👤 Who is this for? This workflow is designed for content creators, marketers, fashion brands, AI creators, and automation builders who want t

Free

Summarize and answer Re:amaze support emails with Gemini and SOP knowledge base

This template demonstrates an AI-powered email automation system for Re:amaze, summarizing and responding to customer inquiries using a structured knowledge base to ensure accurate and consistent replies. 🔹 Ideal for: - Customer support teams handling high volumes of email queries (e.g., e-commerce, SaaS) - Businesses looking to automate SOP-based responses with AI while integrating actions like order lookup or issue logging What this workflow does - Fetches incoming customer emails from R

Free

Monitor [PROD] workflows in real time with the n8n Public API dashboard

A real-time monitoring dashboard for your n8n production workflows, accessible directly from the browser via webhook. Tag any workflow with [PROD] and it will automatically appear on the dashboard showing: → Healthy vs error workflows → Success rate per workflow → Total errors and successes → Last error timestamp → 7-day error history chart The dashboard auto-refreshes every 30 seconds. No external tools required — it uses only the n8n Public API. How it works When the webhook is triggered, the

Free

Translate & repost Twitter threads in multiple languages with OpenAI

Twitter Thread (Flood) Translator & Poster What it does - Thread Extraction: Automatically detects and extracts all tweets from a provided Twitter thread (flood) link. - Translation: Translates each extracted tweet into your target language using OpenAI. - Rewriting: Rewrites each translated tweet to maintain the original meaning while improving clarity or style. - Automated Posting: Posts the rewritten tweets as a new thread on Twitter using twitterapi.io, preserving the

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