Build a PDF Q&A System with LlamaIndex, OpenAI Embeddings & Pinecone Vector DB

Parse, Normalize, Extract, and Store PDF Content for RAG in Pinecone

This workflow automates a full RAG pipeline for structured documents (like insurance policies).

What it does

• Watches a Google Drive folder for new PDFs
• Uploads to LlamaIndex Cloud for parsing → returns clean Markdown
• Normalizes text (removes headers, footers, page numbers, formatting artifacts)
• Splits text into chunks (~1200 chars with 150 overlap)
• Generates embeddings with OpenAI
• Stores vectors in Pinecone with metadata
• Connects a Chat Agent that retrieves answers from Pinecone

Who’s it for

• Developers building chatbots or Q&A systems for structured docs
• Teams working with insurance, compliance, or legal PDFs
• Anyone who needs to normalize & store documents for semantic search

Requirements

• Google Drive connected (for source PDFs)
• LlamaIndex Cloud account (parsing API key)
• Pinecone account (vector DB)
• OpenAI account (LLM and embeddings)

How to use and customize

• Update the folder name in google drive trigger node.
• Place a pdf file in the same folder in google drive.
• Customize the Normalized Content function node to adjust regex for headers/footers specific to your documents.
• Adjust chunk size or metadata namespace in the Pinecone node to fit your project needs.