Skip to content
AI Agents

Extract Drive files, intelligently slice and store in Pinecone

13 nodes 577 170 Automatic trigger
Download

Loading workflow…

Workflow Description

Automation that retrieves documents from Google Drive, splits them into context-aware chunks using Gemini, converts them to vector embeddings, and stores them in Pinecone to enable semantic search and precise question-answering capabilities.

How it works

  1. 1.Trigger the workflow manually and extract files from Google Drive
  2. 2.Process documents and intelligently split them while preserving context using Gemini
  3. 3.Convert chunks into embeddings and store them in Pinecone vector database for immediate retrieval

Use cases

  • Build a searchable knowledge repository from multiple company files
  • Deploy an advanced RAG system to answer employee queries from internal documents
  • Archive and organize large digital content with efficient semantic indexing

Requirements

  • Active Google Drive account containing documents to process
  • Pinecone API key and active vector database instance
  • Google Gemini API access credentials for embeddings and processing

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Manual Trigger Split In Batches Lm Chat Open Router Vector Store Gemini Document Default Data Loader Text Splitter Google Drive Twitter/X Code Split Out AI Agent Set

Details

Trigger Automatic trigger
Nodes 13
Apps 13
Views 577
Downloads 170

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (13)

/

When clicking ‘Test workflow’

Manual Trigger

#1

Loop Over Items

Split In Batches

#2

OpenRouter Chat Model

Lm Chat Open Router

#3

Pinecone Vector Store

Vector Store Pinecone

#4

Embeddings Google Gemini

Gemini Model

#5

Default Data Loader

Document Default Data Loader

#6

Recursive Character Text Splitter

Text Splitter Recursive Character Text Splitter

#7

Get Document From Google Drive

Google Drive

#8

Extract Text Data From Google Document

Extract From File

#9

Split Document Text Into Sections

Code

#10

Prepare Sections For Looping

Split Out

#11

Sticky Note

Sticky Note

#12

Sticky Note1

Sticky Note

#13

AI Agent - Prepare Context

Agent

#14

Concatenate the context and section text

Set

#15

Sticky Note2

Sticky Note

#16

Sticky Note3

Sticky Note

#17
Stay in the loop

Fresh workflows, straight to your inbox

Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.

  • New workflows
  • Clear overviews
  • Setup guides

Be first to discover what is new

Your name, your email, and one confirmation.

Email confirmation · Unsubscribe anytime