n8n Document Q&A Webhook: Pinecone + OpenAI + Cohere + Drive

Turn your documents into a Pinecone-powered Q&A chatbot—complete with page-quoted answers and Google Drive links

This n8n workflow exposes a webhook that answers questions over your own document knowledge base. It searches Pinecone using OpenAI embeddings, reranks results with Cohere, generates an answer with exact quoted sources, then pulls the referenced files from Google Drive with both view and direct download URLs.

What this workflow does

• Receives a POST webhook request with the user’s question in the message field.
• Searches your Pinecone knowledge base using OpenAI embeddings.
• Reranks top matches with Cohere to improve relevance.
• Generates an answer using an OpenAI chat model, including the document name, page number, and an exact supporting quote (with Google Gemini as fallback).
• Runs a second OpenAI-based agent to extract only referenced source file names into structured JSON.
• Splits the file-name list and searches Google Drive to retrieve each file’s ID.
• Builds Drive view + download links for the matched files and responds to the webhook with the AI answer plus the assembled source links.

Use cases

• Provide support teams with a document Q&A webhook for internal policies, SOPs, or manuals.
• Give SaaS operators instant answers with quoted evidence and clickable Google Drive sources.
• Build a custom “ask our docs” interface that leverages n8n + Pinecone + OpenAI without manual citations.

Technical details

• Integrations / nodes: webhook, code, split out, sticky note, Google Drive, and n8n-nodes-langchainagent.
• AI components: OpenAI embeddings + OpenAI chat (Gemini fallback) and Cohere reranking.
• Configuration: add credentials for OpenAI, Pinecone, Cohere, Google Gemini, and Google Drive; set your Pinecone index name (replace YOUR_PINECONE_INDEX_NAME).