Chat with Google Drive documents using OpenAI and Pinecone RAG search

Try it out

This n8n workflow template lets you chat with your Google Drive documents (.docx, .json, .md, .txt, .pdf) using OpenAI and Pinecone vector database. 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. Not interested in chunking and embedding your own data or figuring out which search method to use?

Try our n8n quickstart for Pinecone Assistant [here](https://docs.pinecone.io/guides/assistant/quickstart/n8n-quickstart) or check out the full workflow to chat with your Google Drive documents [here](https://n8n.io/workflows/9942-rag-powered-document-chat-with-google-drive-openai-and-pinecone-assistant/).

Prerequisites

A [Pinecone account](https://app.pinecone.io/) A GCP project with [Google Drive API enabled and configured](https://docs.n8n.io/integrations/builtin/credentials/google/oauth-single-service/) An [Open AI account](https://auth.openai.com/create-account) and [API key](https://platform.openai.com/settings/organization/api-keys) A [Cohere account](https://dashboard.cohere.com/welcome/register) and [API key](https://dashboard.cohere.com/api-keys)

Setup

1. Create a Pinecone index in the Pinecone Console [here](https://app.pinecone.io/organizations/-/projects/-/indexes) 1. Name your index n8n-dense-index 2. Select OpenAI's text-embedding-3-small 3. Set the Dimension to 1536 4. Leave everything else as default 5. If you use a different index name, update the related nodes to reflect this change 2. 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](https://app.pinecone.io/organizations/-/projects/-/keys) directly 3. Setup your Google Drive OAuth2 API, Open AI, and Cohere credentials in n8n 4. Download these files and add them to a Drive folder named n8n-pinecone-demo in the root of your My Drive 1. [https://docs.pinecone.io/release-notes/2022.md](https://docs.pinecone.io/release-notes/2022.md) 2. [https://docs.pinecone.io/release-notes/2023.md](https://docs.pinecone.io/release-notes/2023.md) 3. [https://docs.pinecone.io/release-notes/2024.md](https://docs.pinecone.io/release-notes/2024.md) 4. [https://docs.pinecone.io/release-notes/2025.md](https://docs.pinecone.io/release-notes/2025.md) 5. [https://docs.pinecone.io/release-notes/2026.md](https://docs.pinecone.io/release-notes/2026.md) 5. Activate the workflow or test it with a manual execution to ingest the documents 6. Enter the chat prompts to chat with the Pinecone release notes 1. What support does Pinecone have for MCP? 2. When was fetch by metadata released?

Ideas for customizing this workflow