Slack Q&A Bot: Notion & Google Drive to Pinecone + OpenAI

Turn your Notion and Google Drive knowledge into instant Slack Q&A—powered by Pinecone + OpenAI

This n8n workflow nightly syncs your Notion pages and Google Drive files into a Pinecone vector index, then answers Slack @mentions using an OpenAI 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.

What this workflow does

• Nightly ingestion (2am): Runs every night at 2am, searches for content across Notion and Google Drive, and combines results into a single normalized document list (IDs, titles, URLs, and source labels).
• Text extraction: Iterates through each document and extracts plain text from Notion page blocks or by downloading and text-extracting the Google Drive file.
• Vector indexing: Creates OpenAI embeddings for each document and upserts the content plus metadata into a Pinecone index.
• Slack Q&A trigger: Listens for bot @mentions in a specified Slack channel, cleans the message into a plain question while keeping thread context.
• RAG answering: Uses an OpenAI chat model with a Pinecone retrieval tool to answer based on your indexed knowledge, then posts the response back to the originating Slack thread (including a source URL).
• Error reporting: Sends workflow errors to an ops Slack channel.

Use cases

• Provide internal support in Slack using your documented SOPs from Notion and attachments stored in Google Drive.
• Enable SaaS operators to answer recurring questions with up-to-date, searchable content via Pinecone-backed retrieval.
• Reduce time spent hunting for answers by responding directly in the same Slack thread.

Technical details

• Integrations: Slack, Notion, Google Drive, OpenAI, Pinecone
• n8n nodes/logic: if, code, no op, merge, slack, notion
• Setup steps: Add credentials, configure the Pinecone index name for both ingestion and retrieval nodes, and set Slack channel IDs for Q&A mentions and ops-alerts. Install/configure the Slack app to receive app_mention events.