Skip to content
AI Agents

Extract Google Drive Documents and Intelligently Slice into Pinecone

13 nodes 603 246 Automatic trigger
Download

Loading workflow…

Workflow Description

Advanced automation that retrieves documents from Google Drive, intelligently chunks them using Gemini embeddings, and stores semantic vectors in Pinecone for context-aware retrieval and precise question-answering capabilities.

How it works

  1. 1.Automatically fetch documents from Google Drive folders
  2. 2.Intelligently partition content using recursive text splitting
  3. 3.Generate semantic embeddings via Gemini model
  4. 4.Store processed chunks with embeddings in Pinecone
  5. 5.Execute contextual search and retrieve relevant information instantly

Use cases

  • Build a question-answering system from your company's document repository
  • Extract relevant information from stored reports and contracts efficiently

Requirements

  • Active Google Drive account with documents ready for processing
  • Pinecone API key and credentials with an operational vector database
  • Access credentials to Gemini model via OpenRouter or Google Cloud API

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 603
Downloads 246

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