Index Google Drive Docs to Pinecone with OpenAI Embeddings for RAG

This workflow automates the indexing of documents from a specific Google Drive folder into a Pinecone vector database using OpenAI embeddings. It triggers on new file uploads, searches and downloads files, loops over each one, loads and parses the content, splits text into chunks (e.g., 600 chars with 60 overlap), generates embeddings, and upserts them into Pinecone with custom metadata. Ideal for building dynamic knowledge bases, it keeps your vector store updated effortlessly, enabling retrie