Templates / Google Drive to Pinecone vector storage workflow

Google Drive to Pinecone vector storage workflow

Needs changes

by Muhammad Asadullah ✓ · 369 views · created 2025-03-17 · AI, Personal Productivity

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 32 nodes and runs when a chat message arrives (plus 3 other triggers). Along the way it connects OpenAI Chat Model, Embeddings OpenAI, Google Drive and Supabase and 1 more.

How it runs

Trigger: When a chat message arrives (plus 3 other triggers).

  1. Edit Fields (Edit Fields (Set)): sets 2 fields: chatInput, sessionId
  2. Set File ID (Edit Fields (Set)): sets 3 fields: file_id, file_type, file_name
  3. RAG AI Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 2 tools (Calculator, Cars Data Vector Store); memory: Simple Memory
  4. Split Out: splits a list into separate items
  5. Respond to Webhook: sends the response back to the webhook caller
  6. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  7. FinishNode (Edit Fields (Set)): sets 1 field: response
  8. Delete Old Doc Rows (Supabase): delete
  9. Download File (Google Drive): download
  10. Switch: routes items into 3 branches

…plus 10 more steps. See the full node list below.

Services it uses

OpenAI Chat ModelEmbeddings OpenAIGoogle DriveSupabaseSupabase Vector Store

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in RAG AI Agent (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
AI Agent v1 (old agent modes)
RAG AI Agent (v1.6)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (22)

From the author

Document Chat Bot with Automated RAG System This workflow creates a conversational assistant that can answer questions based on your Google Drive documents. It automatically processes various file types and uses Retrieval-Augmented Generation (RAG) to provide…

Excerpt from Muhammad Asadullah's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.