Process OCR Documents from Google Drive into Searchable Knowledge Base with OpenAI & Pinecone

About

How it works This workflow automates a full RAG ingestion pipeline. When a new OCR JSON file is added to a Google Drive folder, the workflow extracts lesson metadata, parses and cleans the Arabic text, generates semantic chunks, creates AI embeddings, and stores them in a Pinecone vector index. After processing, the file is automatically moved to an archive folder to prevent duplicates. Set up steps Follow the sticky notes inside the workflow for detailed instructions. Connect your Google Driv