Workflow: Insert and retrieve documents
Integrations: code, html, httpRequest, limit, manualTrigger, noOp, set, splitOut, stickyNote

{"id": "Hjyv9FkH5Oh6Yxw4", "meta": {"instanceId": "workflow-65c5e3ea", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:54.110866", "updatedAt": "2025-09-29T07:07:54.110878", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "Insert and retrieve documents", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "52044ccd-4e0d-4353-b612-cf8db1b55331", "name": "When clicking \"Execute Workflow\"", "type": "n8n-nodes-base.manualTrigger", "position": [-500, -100], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow."}, {"id": "b6993775-d21b-4ae8-a59c-43aef2b7002b", "name": "Fetch Essay List", "type": "n8n-nodes-base.httpRequest", "position": [-220, -100], "parameters": {"url": "{{ $env.WEBHOOK_URL }}", "options": {}}, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "cbaeb236-5c93-4b34-a06b-ff0e5de8525f", "name": "Extract essay names", "type": "n8n-nodes-base.html", "position": [-20, -100], "parameters": {"options": {}, "operation": "extractHtmlContent", "extractionValues": {"values": [{"key": "YOUR_CREDENTIAL_HERE", "attribute": "href", "cssSelector": "table table a", "returnArray": true, "returnValue": "attribute"}]}}, "typeVersion": 1.2, "notes": "This html node performs automated tasks as part of the workflow."}, {"id": "d92b6692-4a02-4519-b113-8a9172c71de9", "name": "Split out into items", "type": "n8n-nodes-base.splitOut", "position": [180, -100], "parameters": {"options": {}, "fieldToSplitOut": "essay"}, "typeVersion": 1, "notes": "This splitOut node performs automated tasks as part of the workflow."}, {"id": "d16ba71b-10fc-454f-8bfc-a6826280a4e7", "name": "Fetch essay texts", "type": "n8n-nodes-base.httpRequest", "position": [580, -100], "parameters": {"url": "{{ $env.BASE_URL }}", "options": {}}, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "c4fa74ea-6af5-410c-bf5c-9d8d3decf31b", "name": "Limit to first 3", "type": "n8n-nodes-base.limit", "position": [380, -100], "parameters": {"maxItems": 3}, "typeVersion": 1, "notes": "This limit node performs automated tasks as part of the workflow."}, {"id": "3da8495b-62df-475d-b99d-e0f3c64266e3", "name": "Extract Text Only", "type": "n8n-nodes-base.html", "position": [900, -100], "parameters": {"options": {}, "operation": "extractHtmlContent", "extractionValues": {"values": [{"key": "YOUR_CREDENTIAL_HERE", "cssSelector": "body", "skipSelectors": "img,nav"}]}}, "typeVersion": 1.2, "notes": "This html node performs automated tasks as part of the workflow."}, {"id": "4a9b5d5d-fc94-40b7-af0c-13d992bc1eb9", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [-300, -220], "parameters": {"width": 1071.752021563343, "height": 285.66037735849045, "content": "## Scrape latest Paul Graham essays"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "b8a7a288-186f-4444-b0de-33ed90009c0a", "name": "Sticky Note5", "type": "n8n-nodes-base.stickyNote", "position": [820, -220], "parameters": {"width": 625, "height": 607, "content": "## Load into Milvus vector store"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "c9e7b166-cc65-47e2-a437-9c00017b492a", "name": "Recursive Character Text Splitter1", "type": "n8n-nodes-base.noOp", "position": [1240, 240], "parameters": {"options": {}, "chunkSize": 6000}, "typeVersion": 1, "notes": "This textSplitterRecursiveCharacterTextSplitter node performs automated tasks as part of the workflow."}, {"id": "e1a75f27-7c8c-4d0d-9b0f-33fe9ec96fc6", "name": "Generate response", "type": "n8n-nodes-base.set", "position": [1240, 560], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "11396286-0378-4c3a-86e1-c9ef51afbfc7", "name": "text", "type": "string", "value": "={{ $json.answer }} {{ $if(!$json.citations.isEmpty(), \"\\n\" + $json.citations.join(\"\"), '') }}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "8b3497ad-5bc8-44b3-bdf4-3a028fe265ce", "name": "Compose citations", "type": "n8n-nodes-base.set", "position": [1040, 560], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "ace6185e-8b3d-4f89-ae36-dfe0c391a0a9", "name": "citations", "type": "array", "value": "={{ $json.citations.map(i => '[' + $('Get top chunks matching query').all()[$json.citations].json.document.metadata.file_name + ', lines ' + $('Get top chunks matching query').all()[$json.citations].json.document.metadata['loc.lines.from'] + '-' + $('Get top chunks matching query').all()[$json.citations].json.document.metadata['loc.lines.to'] + ']') }}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "0452cf15-145c-49dd-8803-4c8b8a7adbea", "name": "Answer the query based on chunks", "type": "n8n-nodes-base.noOp", "position": [680, 560], "parameters": {"text": "={{ $json.context }}\n\nQuestion: {{ $('When chat message received').first().json.chatInput }}\nHelpful Answer:", "options": {"systemPromptTemplate": "=Use the following pieces of context to answer the question at the end. If you don't know the answer, just say that you don't know, don't try to make up an answer. Important: In your response, also include the the indexes of the chunks you used to generate the answer."}, "schemaType": "manual", "inputSchema": "{\n  \"type\": \"object\",\n  \"required\": [\"answer\", \"citations\"],\n  \"properties\": {\n    \"answer\": {\n      \"type\": \"string\"\n    },\n    \"citations\": {\n      \"type\": \"array\",\n      \"items\": {\n        \"type\": \"number\"\n      }\n    }\n  }\n}"}, "typeVersion": 1, "notes": "This informationExtractor node performs automated tasks as part of the workflow."}, {"id": "d385ac35-6f94-4101-99de-5ce1991f40c4", "name": "Prepare chunks", "type": "n8n-nodes-base.code", "position": [480, 560], "parameters": {"jsCode": "let out = \"\"\nfor (const i in $input.all()) {\n  let itemText = \"--- CHUNK \" + i + \" ---\\n\"\n  itemText += $input.all()[i].json.document.pageContent + \"\\n\"\n  itemText += \"\\n\"\n  out += itemText\n}\n\nreturn {\n  'context': out\n};"}, "typeVersion": 2, "notes": "This code node performs automated tasks as part of the workflow."}, {"id": "379837f2-4f96-43ff-8e87-722cbe6d652f", "name": "Set max chunks to send to model", "type": "n8n-nodes-base.set", "position": [-300, 560], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "33f4addf-72f3-4618-a6ba-5b762257d723", "name": "chunks", "type": "number", "value": 4}]}, "includeOtherFields": true}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "9bc391bb-df47-41df-b170-9df47a6b5e87", "name": "Embeddings OpenAI2", "type": "n8n-nodes-base.noOp", "position": [-100, 780], "parameters": {"model": "text-embedding-ada-002", "options": {}}, "credentials": {"openAiApi": {"id": "hH2PTDH4fbS7fdPv", "name": "OpenAi account"}}, "typeVersion": 1.2, "notes": "This embeddingsOpenAi node performs automated tasks as part of the workflow."}, {"id": "efb030f4-445b-4ba0-b5c9-95e4e5893664", "name": "When chat message received", "type": "n8n-nodes-base.noOp", "position": [-540, 560], "webhookId": "cd2703a7-f912-46fe-8787-3fb83ea116ab", "parameters": {"options": {}}, "typeVersion": 1.1, "notes": "This chatTrigger node performs automated tasks as part of the workflow."}, {"id": "c74943be-0008-4d4c-9dea-598a648a97a2", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [-380, 440], "parameters": {"color": 7, "width": 1594, "height": 529, "content": ""}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "2e27f3d8-e8a2-4647-80dd-f2643b224cb5", "name": "Milvus Vector Store in retrieval", "type": "n8n-nodes-base.noOp", "position": [0, 560], "parameters": {"mode": "load", "topK": 2, "prompt": "answer the question", "milvusCollection": {"__rl": true, "mode": "list", "value": "my_collection", "cachedResultName": "my_collection"}}, "credentials": {"milvusApi": {"id": "8tMHHoLiWXIAXa7S", "name": "Milvus account"}}, "typeVersion": 1.1, "notes": "This vectorStoreMilvus node performs automated tasks as part of the workflow."}, {"id": "a3cf7e0e-f681-4880-9ccf-5c42d5457c0f", "name": "Milvus Vector Store", "type": "n8n-nodes-base.noOp", "position": [1120, -100], "parameters": {"mode": "insert", "options": {"clearCollection": true}, "milvusCollection": {"__rl": true, "mode": "list", "value": "my_collection", "cachedResultName": "my_collection"}}, "credentials": {"milvusApi": {"id": "8tMHHoLiWXIAXa7S", "name": "Milvus account"}}, "typeVersion": 1.1, "notes": "This vectorStoreMilvus node performs automated tasks as part of the workflow."}, {"id": "4c4cc5a5-e880-466f-a298-4af53a2acbec", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-700, -260], "parameters": {"width": 280, "height": 180, "content": "## Step 1\n1. Set up a Milvus server based on [this guide]({{ $env.WEBHOOK_URL }} And then create a collection named `my_collection`.\n2. Click this workflow to load scrape and load Paul Graham essays to Milvus collection.\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "18f42da4-42ea-4eb0-9c43-ef8bd31ab7ff", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [-680, 460], "parameters": {"height": 120, "content": "## Step 2\nChat and get citations in response"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "0af427ed-d901-4192-9fdc-986a63fd585b", "name": "Embeddings OpenAI", "type": "n8n-nodes-base.noOp", "position": [1020, 140], "parameters": {"options": {}}, "credentials": {"openAiApi": {"id": "hH2PTDH4fbS7fdPv", "name": "OpenAi account"}}, "typeVersion": 1.2, "notes": "This embeddingsOpenAi node performs automated tasks as part of the workflow."}, {"id": "3603852a-bf12-4289-9733-dcd29d12a4f6", "name": "Default Data Loader", "type": "n8n-nodes-base.noOp", "position": [1160, 120], "parameters": {"options": {}, "jsonData": "={{ $('Extract Text Only').item.json.data }}", "jsonMode": "expressionData"}, "typeVersion": 1, "notes": "This documentDefaultDataLoader node performs automated tasks as part of the workflow."}, {"id": "b49eb3ae-82cb-4d87-8f22-0789b3a14d83", "name": "OpenAI Chat Model", "type": "n8n-nodes-base.noOp", "position": [680, 780], "parameters": {"model": {"__rl": true, "mode": "list", "value": "gpt-4o-mini"}, "options": {}}, "credentials": {"openAiApi": {"id": "hH2PTDH4fbS7fdPv", "name": "OpenAi account"}}, "typeVersion": 1.2, "notes": "This lmChatOpenAi node performs automated tasks as part of the workflow."}], "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": "5dc48a1d-aaf0-4052-9666-28f9e76d198c", "connections": {"b6993775-d21b-4ae8-a59c-43aef2b7002b": {"main": [[{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b", "type": "main", "index": 0}], [{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b-999d4f1e", "type": "main", "index": 0}], [{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b-0d916fcb", "type": "main", "index": 0}], [{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b-a6853d0c", "type": "main", "index": 0}], [{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b-e63ecf07", "type": "main", "index": 0}], [{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b-decb1bc6", "type": "main", "index": 0}], [{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b-9518e8b6", "type": "main", "index": 0}], [{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b-dacd47f9", "type": "main", "index": 0}], [{"node": "error-handler-b6993775-d21b-4ae8-a59c-43aef2b7002b-78df8439", "type": "main", "index": 0}]]}, "d16ba71b-10fc-454f-8bfc-a6826280a4e7": {"main": [[{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7", "type": "main", "index": 0}], [{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7-89f1d093", "type": "main", "index": 0}], [{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7-f50c8044", "type": "main", "index": 0}], [{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7-dc0db029", "type": "main", "index": 0}], [{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7-efa78e03", "type": "main", "index": 0}], [{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7-d5c700fb", "type": "main", "index": 0}], [{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7-1d9d32c1", "type": "main", "index": 0}], [{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7-4556dd44", "type": "main", "index": 0}], [{"node": "error-handler-d16ba71b-10fc-454f-8bfc-a6826280a4e7-2dbd93d0", "type": "main", "index": 0}]]}, "9bc391bb-df47-41df-b170-9df47a6b5e87": {"main": [[{"node": "error-handler-9bc391bb-df47-41df-b170-9df47a6b5e87-71d6864c", "type": "main", "index": 0}]]}, "0af427ed-d901-4192-9fdc-986a63fd585b": {"main": [[{"node": "error-handler-0af427ed-d901-4192-9fdc-986a63fd585b-026edf74", "type": "main", "index": 0}]]}, "b49eb3ae-82cb-4d87-8f22-0789b3a14d83": {"main": [[{"node": "error-handler-b49eb3ae-82cb-4d87-8f22-0789b3a14d83-e8400305", "type": "main", "index": 0}]]}}, "description": "Automated workflow: Insert and retrieve documents. This workflow integrates 16 different services: stickyNote, httpRequest, textSplitterRecursiveCharacterTextSplitter, code, splitOut. It contains 32 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Insert and retrieve documents. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}