{"product_id":"slack-q-a-bot-notion-google-drive-to-pinecone-openai","title":"Slack Q\u0026A Bot: Notion \u0026 Google Drive to Pinecone + OpenAI","description":"\u003ch3\u003eTurn your Notion and Google Drive knowledge into instant Slack Q\u0026amp;A—powered by Pinecone + OpenAI\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow nightly syncs your \u003cstrong\u003eNotion\u003c\/strong\u003e pages and \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e files into a \u003cstrong\u003ePinecone\u003c\/strong\u003e vector index, then answers \u003cstrong\u003eSlack @mentions\u003c\/strong\u003e using an \u003cstrong\u003eOpenAI\u003c\/strong\u003e chat model with retrieval. Responses are posted back to the same Slack thread with a source URL—and errors can be sent to an ops Slack channel.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNightly ingestion (2am):\u003c\/strong\u003e Runs every night at \u003cstrong\u003e2am\u003c\/strong\u003e, searches for content across \u003cstrong\u003eNotion\u003c\/strong\u003e and \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and combines results into a single normalized document list (IDs, titles, URLs, and source labels).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eText extraction:\u003c\/strong\u003e Iterates through each document and extracts plain text from \u003cstrong\u003eNotion page blocks\u003c\/strong\u003e or by downloading and text-extracting the \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e file.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVector indexing:\u003c\/strong\u003e Creates \u003cstrong\u003eOpenAI embeddings\u003c\/strong\u003e for each document and upserts the content plus metadata into a \u003cstrong\u003ePinecone\u003c\/strong\u003e index.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack Q\u0026amp;A trigger:\u003c\/strong\u003e Listens for bot \u003cstrong\u003e@mentions\u003c\/strong\u003e in a specified Slack channel, cleans the message into a plain question while keeping thread context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRAG answering:\u003c\/strong\u003e Uses an OpenAI chat model with a \u003cstrong\u003ePinecone retrieval tool\u003c\/strong\u003e to answer based on your indexed knowledge, then posts the response back to the originating Slack thread (including a source URL).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError reporting:\u003c\/strong\u003e Sends workflow errors to an \u003cstrong\u003eops Slack channel\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProvide internal support in Slack using your documented SOPs from Notion and attachments stored in Google Drive.\u003c\/li\u003e\n  \u003cli\u003eEnable SaaS operators to answer recurring questions with up-to-date, searchable content via Pinecone-backed retrieval.\u003c\/li\u003e\n  \u003cli\u003eReduce time spent hunting for answers by responding directly in the same Slack thread.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eNotion\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e, \u003cstrong\u003ePinecone\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic:\u003c\/strong\u003e if, code, no op, merge, slack, notion\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup steps:\u003c\/strong\u003e Add credentials, configure the Pinecone index name for both ingestion and retrieval nodes, and set Slack channel IDs for Q\u0026amp;A mentions and ops-alerts. Install\/configure the Slack app to receive \u003cstrong\u003eapp_mention\u003c\/strong\u003e events.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45755361525939,"sku":"N8N-17722","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/3ZnaRcigDsoe61b37wP3S_99FS5l9W.png?v=1785661608","url":"https:\/\/buyflowscripts.com\/products\/slack-q-a-bot-notion-google-drive-to-pinecone-openai","provider":"N8N Commerce","version":"1.0","type":"link"}