Automate document ingestion & RAG system with Google Drive, Sheets & OpenAI
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 24 nodes and runs on Google Drive events (file created) (plus 2 other triggers). Along the way it connects Pinecone Vector Store, Embeddings OpenAI, Google Drive and Google Sheets and 1 more.
How it runs
Trigger: On Google Drive events (file created) (plus 2 other triggers).
- Search files and folders (Google Drive): work with file folder
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 1 tool (Pinecone Vector Store)
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Form (n8n Form): shows the next form page
- nonDownloadableFile (If): checks a condition and branches into true / false
- Download file (Google Drive): download
- createHash (Crypto): hashes or encrypts values
- searchRecordManger (Google Sheets): uses Google Sheets
- Switch: routes items into 3 branches
- Add to Record Manger (Google Sheets): append or update
…plus 5 more steps. See the full node list below.
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 (15)
- Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Google Drive
n8n-nodes-base.googleDrive - Crypto
n8n-nodes-base.crypto - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - n8n Form
n8n-nodes-base.form - n8n Form Trigger
n8n-nodes-base.formTrigger
From the author
1. Overview The IngestionDocs workflow is a fully automated document ingestion and knowledge management system built with n8n. Its purpose is to continuously ingest organizational documents from Google Drive, transform them into vector embeddings using…