PICKED FROM N8N.IO · REPORTING & OPERATIONS

Staff can ask questions in a chat and get answers drawn from documents in a Google Drive folder. When a file is added or updated, it is downloaded, split into chunks and stored in a Pinecone vector database. The chat agent searches that store and answers using Google Gemini.

Template by Mihai Farcas · 352k views on n8n.io · listed there as “RAG chatbot for company documents using Google Drive and Gemini”

THE WORKFLOW15 NODES
VPinecone VectorStoreEEmbeddings GoogleGeminiDDefault DataLoaderTRecursiveCharacter Text S…✦AI AgentTVector Store ToolVPinecone VectorStore (Retrieval)EEmbeddings GoogleGemini (retrieva…▲Download FileFrom Google Drive▲Google Drive FileUpdated▲Google Drive FileCreated◐Window BufferMemory◌When chat messagereceivedLGoogle GeminiChat ModelLGoogle GeminiChat Model (retr…
DIFFICULTY
Advanced
NODES
15
USES AI
Yes
PUBLISHED
January 2025

001 / WHAT HAPPENS

  1. 01

    Two Google Drive triggers watch one folder for new and updated files.

  2. 02

    The file is downloaded, loaded and split into smaller text chunks.

  3. 03

    Gemini creates embeddings for each chunk and Pinecone stores them.

  4. 04

    A staff member asks a question in the chat window.

  5. 05

    An AI agent searches Pinecone, then Gemini writes the answer using the retrieved text.

WHO IT SUITS

Suits a business that keeps procedures, price lists or policies in Drive and wants staff to find answers without asking the owner.

CONNECTS

  • Google Drive
  • Google Gemini
  • Pinecone

002 / BEFORE YOU USE IT HERE

  • !Document text is sent to Google Gemini and stored in Pinecone, both overseas services, which is a cross-border disclosure under APP 8 if it contains personal information. Say so in your privacy policy.
  • !Do not point it at a folder holding HR files, medical or client records unless you have checked who can ask the chatbot.
  • !It needs a Pinecone account and a Google AI API key. Documents must be re-indexed when you restructure folders.

WORTH KNOWING

Templates on n8n.io are written for a global audience. Set the workflow timezone to your city, and test with a handful of real items before switching it on.

Need n8n and the AI hosted in Australia? →

004 / QUESTIONS

Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.

Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.

We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.

Book a free call→