{"product_id":"n8n-dual-stage-rag-chatbot-google-drive-pinecone-gemini","title":"n8n Dual-Stage RAG Chatbot: Google Drive + Pinecone + Gemini","description":"\u003ch3\u003eTurn your Google Drive PDFs into a smarter RAG chatbot—with a fast semantic cache\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow template builds a \u003cstrong\u003edual-stage RAG chatbot\u003c\/strong\u003e that ingests documents from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e into a \u003cstrong\u003ePinecone\u003c\/strong\u003e knowledge-base index, then answers questions using \u003cstrong\u003eGemini\u003c\/strong\u003e—while first checking a \u003cstrong\u003ePinecone semantic cache\u003c\/strong\u003e to return repeat answers instantly.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests documents from Google Drive\u003c\/strong\u003e: triggers on a Google Drive folder update (or can run manually), lists and downloads files from a specified folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts text by file type\u003c\/strong\u003e: detects whether each file is a \u003cstrong\u003ePDF\u003c\/strong\u003e or plain text and extracts the document text accordingly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a Pinecone knowledge base\u003c\/strong\u003e: splits content into overlapping chunks, embeds them using \u003cstrong\u003eOllama\u003c\/strong\u003e (\u003cem\u003enomic-embed-text\u003c\/em\u003e), and inserts vectors into a Pinecone index.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResponds to chat queries with caching\u003c\/strong\u003e: when a chat message arrives, the workflow embeds the user query with Ollama and searches the Pinecone \u003cstrong\u003esemantic-cache index\u003c\/strong\u003e for the closest prior answer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFast cache hit behavior\u003c\/strong\u003e: if the best match score is \u003cstrong\u003eat least 0.88\u003c\/strong\u003e, it returns the cached answer immediately.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCache miss fallback to Gemini Agent\u003c\/strong\u003e: on a cache miss, it uses a \u003cstrong\u003eGoogle Gemini AI Agent\u003c\/strong\u003e with conversation memory and a \u003cstrong\u003ePinecone vector-store retrieval\u003c\/strong\u003e tool to generate a grounded answer from the knowledge base.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eImproves future responses\u003c\/strong\u003e: stores the new query-and-answer pair back into Pinecone semantic cache.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams answering support questions from internal PDFs stored in Google Drive.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a retrieval-augmented assistant for policy\/knowledge documents.\u003c\/li\u003e\n  \u003cli\u003eOperators reducing AI compute cost by leveraging Pinecone semantic caching for repeat inquiries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePinecone\u003c\/strong\u003e indexes: two separate indexes (cosine similarity, \u003cstrong\u003e768 dimensions\u003c\/strong\u003e): one for the knowledge base (e.g., \u003cem\u003enomic-embed-text\u003c\/em\u003e) and one for the semantic cache (e.g., \u003cem\u003erag-semantic-cache\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmbeddings\u003c\/strong\u003e: Ollama embeddings using \u003cstrong\u003enomic-embed-text\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI\u003c\/strong\u003e: Google Gemini AI Agent with conversation memory + Pinecone retrieval tool.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n logic \u0026amp; nodes\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003eGoogle Drive\u003c\/em\u003e, plus supporting workflow nodes.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45878611902643,"sku":"N8N-18563","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9mXML2PYJTcAaCYd0llop_DZVCeUw2.png?v=1787389576","url":"https:\/\/buyflowscripts.com\/products\/n8n-dual-stage-rag-chatbot-google-drive-pinecone-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}