Description
Turn your Google Drive documents into vector embeddings with OpenAI and PGVector — fully automated via n8n
📌 Stop manual embedding workflows — this automation detects, extracts, embeds, and stores documents with no code and no hassle
🧠 What Problem Does It Solve?
Embedding private documents manually for semantic search or RAG pipelines is tedious and error-prone. This AI-powered workflow solves that by:
🔹 Monitoring a folder for new files
🔹 Extracting content from PDFs, TXT, and JSON
🔹 Converting content into embeddings via OpenAI
🔹 Storing embeddings in PGVector (PostgreSQL)
🔹 Archiving processed files to prevent duplication
⚙️ How it Works
📁 Watches a Google Drive folder for new files
📄 Supports PDF, TXT, and JSON formats
🔍 Uses Switch logic to handle file types correctly
🧼 Extracts and cleans text via LangChain
🧠 Sends content to OpenAI’s text-embedding-3-small model
💾 Stores vectors in PGVector-enabled PostgreSQL
📦 Moves processed files to a “vectorized” folder
✨ Key Features
📌 Fully automated ingestion and vectorization
🧠 OpenAI Embeddings + LangChain integration
📄 Handles structured and unstructured documents
📂 Automatically avoids reprocessing duplicates
📊 Ideal for RAG pipelines, document Q&A, internal search
📅 Optional: run daily via Schedule Trigger
🧰 What You Need
✅ Google Drive account with OAuth2 setup
✅ OpenAI API key (for Embedding API access)
✅ PostgreSQL database with PGVector extension
✅ Table and collection pre-created in your DB
🛠️ Setup Instructions
🔗 Connect all Google Drive nodes with OAuth2 credentials
📁 Set upload folder in the Search Folder node
📦 Set target “vectorized” folder in Move File node
🧠 Configure the OpenAI node with your API key
💾 Connect the PGVector node with your DB details
⏰ Optionally enable daily run via Schedule Trigger
🧪 Use Manual Trigger for on-demand execution
🔧 Advanced Customizations
📂 Add DOCX, HTML, or Markdown support via Extract node
🖼️ Add OCR layer for scanned PDFs or images
🚫 Use filters to ignore unwanted files or extensions
🧩 Integrations
Google Drive
OpenAI
LangChain
PostgreSQL + PGVector
n8n
Project Link:-[https://preview--drive-vector-flow.lovable.app/]
