{"product_id":"n8n-google-drive-qdrant-chatbot-openai-answers-w-sources","title":"n8n Google Drive Qdrant Chatbot: OpenAI Answers w\/ Sources","description":"\u003ch3\u003eAsk questions from your Google Drive—powered by Qdrant and OpenAI with source citations\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically syncs your Google Drive documents into a \u003cstrong\u003eQdrant\u003c\/strong\u003e vector knowledge base and answers user questions through \u003cstrong\u003en8n Chat\u003c\/strong\u003e or \u003cstrong\u003eSlack\u003c\/strong\u003e using \u003cstrong\u003eOpenAI\u003c\/strong\u003e. Every response is drafted from retrieved document content and includes formatted \u003cstrong\u003esource citations\u003c\/strong\u003e back to your files.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSyncs Drive → Qdrant (every minute):\u003c\/strong\u003e It triggers when a file is created or updated in a specific Google Drive folder, then downloads the file.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts text from common formats:\u003c\/strong\u003e It detects whether the file is a \u003cstrong\u003ePDF\u003c\/strong\u003e, \u003cstrong\u003eGoogle Doc\u003c\/strong\u003e, \u003cstrong\u003eDOCX\u003c\/strong\u003e, or \u003cstrong\u003eTXT\u003c\/strong\u003e and extracts plain text. For \u003cstrong\u003eDOCX\u003c\/strong\u003e, it copies to a temporary Google Doc, exports as text, then deletes the temporary doc.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeeps vectors fresh:\u003c\/strong\u003e Before inserting new vectors, it deletes any existing Qdrant entries in the collection that match the same Google Drive \u003cem\u003efile ID\u003c\/em\u003e, preventing outdated duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a searchable knowledge base:\u003c\/strong\u003e It chunks extracted text, adds metadata (file ID, name, Drive URL, last modified time), creates \u003cstrong\u003eOpenAI embeddings\u003c\/strong\u003e, and inserts vectors into the Qdrant collection (e.g., \u003ccode\u003ecompany_knowledge_base\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnswers with retrieval + citations:\u003c\/strong\u003e When a message arrives via the public \u003cstrong\u003en8n Chat endpoint\u003c\/strong\u003e or when the Slack app is mentioned\/receives a message, it normalizes inputs, ignores bot-generated Slack events, retrieves relevant chunks from Qdrant, and uses an \u003cstrong\u003eOpenAI chat model\u003c\/strong\u003e to answer using only retrieved content—adding formatted source citations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack replies:\u003c\/strong\u003e If the question came from Slack, it posts the formatted response back to the same channel\/thread.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAnswer support questions using internal docs stored in a Google Drive folder.\u003c\/li\u003e\n  \u003cli\u003eEnable SaaS teams to query product policies, FAQs, and guides with traceable citations.\u003c\/li\u003e\n  \u003cli\u003eKeep knowledge retrieval current by re-embedding documents whenever Drive files change.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Credentials:\u003c\/strong\u003e Google Drive OAuth2, OpenAI, and Qdrant (REST API delete-by-filter; Qdrant API for vector insertion).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e Uses nodes including \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, and \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChat triggers:\u003c\/strong\u003e Public n8n Chat endpoint and Slack mention\/message handling.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetrieval:\u003c\/strong\u003e Qdrant “company_knowledge_base” retrieval tool with conversation memory for grounded OpenAI answers.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46047273451699,"sku":"N8N-19671","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lJTGpN_ePfcJ0n0o2uDHc_Qz0JfpmR.png?v=1789635920","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-drive-qdrant-chatbot-openai-answers-w-sources","provider":"N8N Commerce","version":"1.0","type":"link"}