Build a Google Drive internal knowledge base with OpenAI and Pinecone
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 34 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Google Sheets, Gmail, Google Drive and Pinecone Vector Store and 2 more.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- List Knowledge Base Docs (Google Drive): work with file folder
- Extract Question & User (Code): runs custom JavaScript code
- List Knowledge Base Docs (Google Drive): work with file folder
- Download Doc as Text (Google Drive): download
- Search Knowledge Base (Pinecone Vector Store): searches the Pinecone vector store, with embeddings: Generate Query Embedding
- Read Document Registry (Google Sheets): uses Google Sheets
- Store Embeddings in Pinecone (Pinecone Vector Store): stores documents in the Pinecone vector store, with embeddings: Generate Embeddings; document loader: Load Document Data
- Build RAG Prompt (Code): runs custom JavaScript code
- Detect New or Updated Docs (Code): runs custom JavaScript code
- Log to Document Registry (Google Sheets): append
…plus 14 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Manual Trigger
n8n-nodes-base.manualTrigger - Google Drive
n8n-nodes-base.googleDrive - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Respond to Webhook
n8n-nodes-base.respondToWebhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if
From the author
📊 Description Every company has documents sitting in Google Drive that nobody reads. HR policies, sales playbooks, product FAQs, financial guidelines — all written once, never found again. This workflow turns all of those documents into a live, searchable AI…