RAG:Context-Aware Chunking | Google Drive to Pinecone via OpenRouter & Gemini

Automated workflow: RAG:Context-Aware Chunking | Google Drive to Pinecone via OpenRouter & Gemini. This workflow integrates 15 different services: stickyNote, vectorStorePinecone, embeddingsGoogleGemini, textSplitterRecursiveCharacterTextSplitter, code. It contains 20 nodes and follows best practices for error handling and security.

Integrations Used (1)

Workflow Structure (14 nodes)
100%
Manual Trigger
When clicking ‘Test workflow’
No Op
AI Agent - Prepare Context
Google Drive
Get Document From Google Drive
Set
Concatenate the context and section text
Extract From File
Extract Text Data From Google Document
Code
Split Document Text Into Sections
Split Out
Prepare Sections For Looping
Split In Batches
Loop Over Items
No Op
OpenRouter Chat Model
No Op
Embeddings Google Gemini
No Op
Pinecone Vector Store
No Op
Recursive Character Text Splitter
No Op
Default Data Loader
Stop And Error
Error Handler
Node Types:
trigger
logic
default
action
code
transform
Requires credentials

Prerequisites

Required Credentials (4)

Google Drive

Used by: Get Document From Google Drive

Docs

Google Palm

Used by: Embeddings Google Gemini

Docs

Open Router

Used by: OpenRouter Chat Model

Docs

Pinecone

Used by: Pinecone Vector Store

Docs

Multiple services required

This workflow needs 4 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~55 min
Score: 77/100
Custom Code
Loops
5 Integrations

When to Use This Workflow

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Time Savings

Replace repetitive manual tasks with reliable automation.

Reclaim hours every week for higher-value work.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json
{
  "id": "VY4WBXuNDPxmOO5e",
  "meta": {
    "instanceId": "workflow-534592fc",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:54.242830",
    "updatedAt": "2025-09-29T07:07:54.242851",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "RAG:Context-Aware Chunking | Google Drive to Pinecone via OpenRouter & Gemini",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...

Workflow Details

Nodes
18
Trigger
Manual
Source
community
Added
Sep 29, 2025

Need Help?

Check out the official n8n documentation for detailed guides.

Related Workflows

Googledrive Workflow

Automated workflow: Googledrive Workflow. This workflow integrates 9 different services: stickyNote, code, merge, google...

Google-drive
10 nodesManual

Manualtrigger Workflow

Automated workflow: Manualtrigger Workflow. This workflow integrates 13 different services: stickyNote, httpRequest, cod...

Google-drive
Http-request
Compression
Editimage
20 nodesManual

Amazon Ads AI Optimization

Automated workflow: Amazon Ads AI Optimization. This workflow integrates 12 different services: stickyNote, code, chainL...

Google-drive
Gmail
23 nodesManual

Convert image from jpg/png to webp

Automated workflow: Convert image from jpg/png to webp. This workflow integrates 9 different services: stickyNote, httpR...

Google-sheets
Http-request
Google-drive
12 nodesManual

Manualtrigger Workflow

Automated workflow: Manualtrigger Workflow. This workflow integrates 13 different services: stickyNote, httpRequest, cod...

Google-drive
Http-request
Compression
Editimage
20 nodesManual

Tiktok Downloader

Automated workflow: Tiktok Downloader. This workflow integrates 6 different services: stickyNote, httpRequest, code, goo...

Http-request
Google-drive
10 nodesManual