Templates / Document-based chatbot with memory using OpenAI, Pinecone and Google Drive

Document-based chatbot with memory using OpenAI, Pinecone and Google Drive

Ready for 3.0

by Sally · 4,318 views · created 2025-06-14 · Personal Productivity, AI RAG

Ready 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 20 nodes and runs when a chat message arrives (plus 1 other trigger). Along the way it connects Airtable, Google Drive, Pinecone Vector Store and Embeddings OpenAI and 3 more.

How it runs

Trigger: When a chat message arrives (plus 1 other trigger).

  1. Get Memories (Airtable): search
  2. Merge: merges the data from its input branches
  3. Google Drive: work with file folder
  4. Aggregate: combines items into one
  5. AI Agent: runs an AI agent, with model: OpenRouter Chat Model; 2 tools (Save Memory, Answer questions with a vector store); memory: Simple Memory
  6. Get Content (Google Drive): download
  7. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  8. Pinecone Vector Store: stores documents in the Pinecone vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader

Services it uses

AirtableGoogle DrivePinecone Vector StoreEmbeddings OpenAIVector Store Question AnswerOpenAI Chat ModelOpenRouter Chat Model

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 (17)

From the author

Who is This For? This is for normal people or people just starting off and wanting to have a AI chatbot that can process data to use when talking to the user. How to Use You will need to have your own OpenRouter (Free) and OpenAI APIs as well as Google Drive,…

Excerpt from Sally'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.