Build a cost engineering RAG with Google Drive, OpenAI and Pinecone
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
At a glance
Build a cost engineering RAG with Google Drive, OpenAI and Pinecone is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- OpenAI, Google Drive
- Modules
- 17
- Price
- Free
- Version
- v1.0

About this workflow
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).
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Text-to-image generation with Flux AI, Google Drive storage & sheets logging
Generate comprehensive business analysis reports with Gemini AI & Firecrawl
Categorize SEO keywords & create content strategy with AI and Airtable
Generate and send email messages using ChatGPT and Microsoft Email
🐋DeepSeek V3 chat & R1 reasoning quick start
Generate and share professional PDFs with OpenAI, Google Docs, and Slack
Smartlead email campaign analytics dashboard with Google Sheets integration
Create and publish SEO blog posts using Google Sheets, Gemini/OpenAI, Ideogram, and WordPress
Reviews
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.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you