đź“Ą Transform Google Drive documents into vector embeddings
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Postgres PGVector Store, Google Drive and Embeddings OpenAI.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Search Folder (Google Drive): work with file folder
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Download File (Google Drive): download
- Switch: routes items into 3 branches
- Extract from PDF (Extract from File): extracts data from a file (pdf)
- Extract from Text (Extract from File): extracts data from a file (text)
- Extract from JSON (Extract from File): extracts data from a file (from json)
- Postgres PGVector Store: stores documents in the Postgres PGVector Store vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
- Move File (Google Drive): move
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Postgres PGVector Store
@n8n/n8n-nodes-langchain.vectorStorePGVector - Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Drive
n8n-nodes-base.googleDrive - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Switch
n8n-nodes-base.switch - Extract from File
n8n-nodes-base.extractFromFile - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi
From the author
Automatically convert documents from Google Drive into vector embeddings using OpenAI, LangChain, and PGVector — fully automated through n8n. --- ⚙️ What It Does This workflow monitors a Google Drive folder for new files, supports multiple file types (PDF,…