Quick Overview This workflow ingests PDF cost-engineering manuals from Google Drive into a Pinecone vector index using OpenAI embeddings, then answers user questions via an n8n chat webhook using a retrieval-augmented OpenAI agent that responds only with evidence from the indexed documents. How it works 1. Runs every 2 minutes on a schedule. 2. Lists files in a configured Google Drive “incoming” folder and downloads each document. 3. Extracts text from each PDF, splits it into overlapping chunks

Quick Overview This workflow ingests PDF cost-engineering manuals from Google Drive into a Pinecone vector index using OpenAI embeddings, then answers user questions via an n8n chat webhook using a retrieval-augmented OpenAI agent that responds only with evidence from the indexed documents. How it works 1. Runs every 2 minutes on a schedule. 2. Lists files in a configured Google Drive “incoming” folder and downloads each document. 3. Extracts text from each PDF, splits it into overlapping chunks, and attaches document metadata. 4. Generates OpenAI embeddings for the chunks and inserts them into the Pinecone rag index. 5. Moves each successfully processed Google Drive file into a configured “ingested/archive” folder. 6. Receives user questions through an n8n Chat webhook and uses a LangChain agent with a Pinecone retrieval tool plus an OpenAI chat model to answer strictly from retrieved passages (or returns the defined fallback message when evidence is missing). Setup 1. Connect Google Drive credentials and replace RAGINCOMINGFOLDERID and RAGINGESTEDFOLDERID with your actual folder IDs. 2. Add an OpenAI API key for both embedding generation and chat responses, and confirm the chat model selection (e.g., gpt-4.1-mini). 3. Connect Pinecone credentials, ensure an index named rag exists, and match its embedding dimension to the OpenAI embeddings model you use. 4. Upload your Technical Composition Manuals as PDFs to the Google Drive incoming folder. 5. Enable the Chat trigger and copy its webhook URL into the client/app you use to send questions (or use n8n’s chat UI).
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.