Google Drive to Pinecone RAG Vector Storage Workflow

This workflow monitors Google Drive folders for new or updated files like PDFs, Excel, and Google Docs, processes them by chunking content and generating embeddings with OpenAI, then stores them in Pinecone for efficient retrieval. It enables a conversational chat interface where users query documents, leveraging RAG to fetch relevant sections and generate precise responses. Benefits include automating knowledge base creation, saving hours on manual data handling, ensuring up-to-date info from