Workflow: RAG:Context-Aware Chunking | Google Drive to Pinecone via OpenRouter & Gemini
Integrations: code, extractFromFile, googleDrive, manualTrigger, noOp, set, splitInBatches, splitOut, stickyNote, stopAndError

{"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", "optimized"], "nodes": [{"id": "7abbfa6e-4b17-4656-9b82-377b1bacf539", "name": "When clicking \u2018Test workflow\u2019", "type": "n8n-nodes-base.manualTrigger", "position": [0, 0], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow."}, {"id": "448ec137-bf64-46b4-bf15-c7a040faa306", "name": "Loop Over Items", "type": "n8n-nodes-base.splitInBatches", "position": [1100, 0], "parameters": {"options": {}}, "typeVersion": 3, "notes": "This splitInBatches node performs automated tasks as part of the workflow."}, {"id": "f22557ee-7f37-40cd-9063-a9a759274663", "name": "OpenRouter Chat Model", "type": "n8n-nodes-base.noOp", "position": [20, 440], "parameters": {"options": {}}, "credentials": {"openRouterApi": {"id": "ddH6iNlm09UxrXvu", "name": "Auto: OpenRouter"}}, "typeVersion": 1, "notes": "This lmChatOpenRouter node performs automated tasks as part of the workflow."}, {"id": "57e8792e-25ae-43d5-b4e9-e87642365ee9", "name": "Pinecone Vector Store", "type": "n8n-nodes-base.noOp", "position": [780, 360], "parameters": {"mode": "insert", "options": {}, "pineconeIndex": {"__rl": true, "mode": "list", "value": "context-rag-test", "cachedResultName": "context-rag-test"}}, "credentials": {"pineconeApi": {"id": "R3QGXSEIRTEAZttK", "name": "Auto: PineconeApi"}}, "typeVersion": 1, "notes": "This vectorStorePinecone node performs automated tasks as part of the workflow."}, {"id": "0a8c2426-0aaf-424a-b246-336a9034aba8", "name": "Embeddings Google Gemini", "type": "n8n-nodes-base.noOp", "position": [720, 540], "parameters": {"modelName": "models/text-embedding-004"}, "credentials": {"googlePalmApi": {"id": "9idxGZRZ3BAKDoxq", "name": "Google Gemini(PaLM) Api account"}}, "typeVersion": 1, "notes": "This embeddingsGoogleGemini node performs automated tasks as part of the workflow."}, {"id": "edc587bd-494d-43e8-b6d6-26adab7af3dc", "name": "Default Data Loader", "type": "n8n-nodes-base.noOp", "position": [920, 540], "parameters": {"options": {}}, "typeVersion": 1, "notes": "This documentDefaultDataLoader node performs automated tasks as part of the workflow."}, {"id": "a82d4e0b-248e-426d-9ef3-f25e7078ceb3", "name": "Recursive Character Text Splitter", "type": "n8n-nodes-base.noOp", "position": [840, 680], "parameters": {"options": {}, "chunkSize": 100000}, "typeVersion": 1, "notes": "This textSplitterRecursiveCharacterTextSplitter node performs automated tasks as part of the workflow."}, {"id": "8571b92f-5587-454f-9700-ea04ca35311b", "name": "Get Document From Google Drive", "type": "n8n-nodes-base.googleDrive", "position": [220, 0], "parameters": {"fileId": {"__rl": true, "mode": "list", "value": "1gm0jxFTLuiWB5u4esEjzoCPImrVqu0AEMIKBIesTf9M", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Udit Rawat - Details"}, "options": {"googleFileConversion": {"conversion": {"docsToFormat": "text/plain"}}}, "operation": "download"}, "credentials": {"googleDriveOAuth2Api": {"id": "SsiQguNA8w3Wwv4w", "name": "Auto: Google Drive"}}, "typeVersion": 3, "notes": "This googleDrive node performs automated tasks as part of the workflow."}, {"id": "2bed3d0f-3d65-4394-87f1-e73320a43a4a", "name": "Extract Text Data From Google Document", "type": "n8n-nodes-base.extractFromFile", "position": [440, 0], "parameters": {"options": {}, "operation": "text"}, "typeVersion": 1, "notes": "This extractFromFile node performs automated tasks as part of the workflow."}, {"id": "837fa691-6c66-434b-ba82-d1cad9aecdf7", "name": "Split Document Text Into Sections", "type": "n8n-nodes-base.code", "position": [660, 0], "parameters": {"jsCode": "let split_text = \"\u2014---------------------------\u2014-------------[SECTIONEND]\u2014---------------------------\u2014-------------\";\nfor (const item of $input.all()) {\n item.json.section = item.json.data.split(split_text);\n item.json.document = JSON.stringify(item.json.section)\n}\nreturn $input.all();"}, "typeVersion": 2, "notes": "This code node performs automated tasks as part of the workflow."}, {"id": "cc801e7e-e01b-421a-9211-08322ef8a0b2", "name": "Prepare Sections For Looping", "type": "n8n-nodes-base.splitOut", "position": [880, 0], "parameters": {"options": {}, "fieldToSplitOut": "section"}, "typeVersion": 1, "notes": "This splitOut node performs automated tasks as part of the workflow."}, {"id": "658cb8df-92e3-4b25-8f37-e5f959d913dc", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-40, -100], "parameters": {"width": 1300, "height": 280, "content": "## Prepare Document. \nThis section is responsible for downloading the file from Google Drive, splitting the text into sections by detecting separators, and preparing them for looping."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "82ee9194-484a-46db-b75c-bec34201c7e2", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [-220, 220], "parameters": {"width": 780, "height": 360, "content": "## Prepare context\nIn this section, the \nagent node will prepare \ncontext for a section \n(chunk of text), which \nwill then be passed for \nconversion into a vectors \nalong with the section itself."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "2f6950df-ead1-479a-aa51-7768121a4eb2", "name": "AI Agent - Prepare Context", "type": "n8n-nodes-base.noOp", "position": [40, 260], "parameters": {"text": "=<document> \n{{ $('Split Document Text Into Sections').item.json.document }}\n</document> \nHere is the chunk we want to situate within the whole document \n<chunk> \n{{ $json.section }}\n</chunk> \nPlease give a short succinct context to situate this chunk within the overall document for the purposes of improving search retrieval of the chunk. Answer only with the succinct context and nothing else. ", "agent": "conversationalAgent", "options": {}, "promptType": "define"}, "typeVersion": 1.7, "notes": "This agent node performs automated tasks as part of the workflow."}, {"id": "34a465fc-a505-445a-9211-bcd830381354", "name": "Concatenate the context and section text", "type": "n8n-nodes-base.set", "position": [400, 260], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "e5fb0381-5d23-46e2-a0d1-438240b80a3e", "name": "=section_chunk", "type": "string", "value": "={{ $json.output }}. {{ $('Loop Over Items').item.json.section }}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "4a7a788c-8e5b-453c-ae52-a4522048992d", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [640, 220], "parameters": {"width": 580, "height": 600, "content": "## Convert Text To Vectors\nIn this step, the Pinecone node converts the provided text into vectors using Google Gemini and stores them in the Pinecone vector database."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "45798b49-fc78-417c-a752-4dd1a8882cd7", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [-460, -120], "parameters": {"width": 400, "height": 300, "content": "## Video Demo\n[![Video Thumbnail]({{ $env.WEBHOOK_URL }}]({{ $env.WEBHOOK_URL }}"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "error-6aa0b799", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "active": false, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "4f0e2203-5850-4a32-b1dd-5adc57fa43ff", "connections": {"0a8c2426-0aaf-424a-b246-336a9034aba8": {"main": [[{"node": "error-handler-0a8c2426-0aaf-424a-b246-336a9034aba8-df2ff514", "type": "main", "index": 0}]]}, "8571b92f-5587-454f-9700-ea04ca35311b": {"main": [[{"node": "error-handler-8571b92f-5587-454f-9700-ea04ca35311b-0a16572c", "type": "main", "index": 0}]]}, "2bed3d0f-3d65-4394-87f1-e73320a43a4a": {"main": [[{"node": "error-handler-2bed3d0f-3d65-4394-87f1-e73320a43a4a-807573ea", "type": "main", "index": 0}]]}}, "description": "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.", "notes": "Excellent quality workflow: RAG:Context-Aware Chunking | Google Drive to Pinecone via OpenRouter & Gemini. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}