{"id":"7cXvgkl9170QXzT2","meta":{"instanceId":"workflow-e4449a0d","versionId":"1.0.0","createdAt":"2025-09-29T07:07:54.896100","updatedAt":"2025-09-29T07:07:54.896109","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"name":"RAG Workflow For Company Documents stored in Google Drive","nodes":[{"id":"753455a3-ddc8-4a74-b043-70a0af38ff9e","name":"Pinecone Vector Store","type":"n8n-nodes-base.noOp","position":[680,0],"parameters":{"mode":"insert","options":{},"pineconeIndex":{"__rl":true,"mode":"list","value":"company-files","cachedResultName":"company-files"}},"credentials":{"pineconeApi":{"id":"bQTNry52ypGLqt47","name":"PineconeApi account"}},"typeVersion":1,"notes":"This vectorStorePinecone node performs automated tasks as part of the workflow."},{"id":"a7c8fa7f-cad2-4497-a295-30aa2e98cacc","name":"Embeddings Google Gemini","type":"n8n-nodes-base.noOp","position":[640,280],"parameters":{"modelName":"models/text-embedding-004"},"credentials":{"googlePalmApi":{"id":"jLOqyTR4yTT1nYKi","name":"Google Gemini(PaLM) Api account"}},"typeVersion":1,"notes":"This embeddingsGoogleGemini node performs automated tasks as part of the workflow."},{"id":"215f0519-4359-4e4b-a90c-7e54b1cc52b5","name":"Default Data Loader","type":"n8n-nodes-base.noOp","position":[840,220],"parameters":{"options":{},"dataType":"binary","binaryMode":"specificField"},"typeVersion":1,"notes":"This documentDefaultDataLoader node performs automated tasks as part of the workflow."},{"id":"863d3d1d-1621-406e-8320-688f64b07b09","name":"Recursive Character Text Splitter","type":"n8n-nodes-base.noOp","position":[820,420],"parameters":{"options":{},"chunkOverlap":100},"typeVersion":1,"notes":"This textSplitterRecursiveCharacterTextSplitter node performs automated tasks as part of the workflow."},{"id":"5af1efb1-ea69-466e-bb3b-2b7e6b1ceef7","name":"AI Agent","type":"n8n-nodes-base.noOp","position":[420,840],"parameters":{"options":{"systemMessage":"You are a helpful HR assistant designed to answer employee questions based on company policies.\n\nRetrieve relevant information from the provided internal documents and provide a concise, accurate, and informative answer to the employee's question.\n\nUse the tool called \"company_documents_tool\" to retrieve any information from the company's documents.\n\nIf the answer cannot be found in the provided documents, respond with \"I cannot find the answer in the available resources.\""}},"typeVersion":1,"notes":"This agent node performs automated tasks as part of the workflow."},{"id":"825632ac-1edf-4e63-948d-b1a498b2b962","name":"Vector Store Tool","type":"n8n-nodes-base.noOp","position":[820,1060],"parameters":{"name":"company_documents_tool","description":"Retrieve information from any company documents"},"typeVersion":1,"notes":"This toolVectorStore node performs automated tasks as part of the workflow."},{"id":"72d2f685-bcc3-4e62-a5e3-72c0fe65f8e8","name":"Pinecone Vector Store (Retrieval)","type":"n8n-nodes-base.noOp","position":[720,1240],"parameters":{"options":{},"pineconeIndex":{"__rl":true,"mode":"list","value":"company-files","cachedResultName":"company-files"}},"credentials":{"pineconeApi":{"id":"bQTNry52ypGLqt47","name":"PineconeApi account"}},"typeVersion":1,"notes":"This vectorStorePinecone node performs automated tasks as part of the workflow."},{"id":"eeff81cb-6aec-4e7f-afe0-432d87085fb2","name":"Embeddings Google Gemini (retrieval)","type":"n8n-nodes-base.noOp","position":[700,1400],"parameters":{"modelName":"models/text-embedding-004"},"credentials":{"googlePalmApi":{"id":"jLOqyTR4yTT1nYKi","name":"Google Gemini(PaLM) Api account"}},"typeVersion":1,"notes":"This embeddingsGoogleGemini node performs automated tasks as part of the workflow."},{"id":"8bb6ebb1-1deb-498b-8da4-b809a736e097","name":"Download File From Google Drive","type":"n8n-nodes-base.googleDrive","position":[460,0],"parameters":{"fileId":{"__rl":true,"mode":"id","value":"={{ $json.id }}"},"options":{"fileName":"={{ $json.name }}"},"operation":"download"},"credentials":{"googleDriveOAuth2Api":{"id":"uixLsi5TmrfwXPeB","name":"Google Drive account"}},"typeVersion":3,"notes":"This googleDrive node performs automated tasks as part of the workflow."},{"id":"bd83bacf-dff1-4b7c-af5c-b249fb16c113","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[420,660],"parameters":{"content":"## Chat with company documents"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"7b90daab-0fb2-4c8a-93e6-b138bb04f282","name":"Google Drive File Updated","type":"n8n-nodes-base.googleDriveTrigger","position":[140,140],"parameters":{"event":"fileUpdated","options":{},"pollTimes":{"item":[{"mode":"everyMinute"}]},"triggerOn":"specificFolder","folderToWatch":{"__rl":true,"mode":"list","value":"1evDIoHePhjw_LgVFZXSZyK1sZm2GHp9W","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"INNOVI PRO"}},"credentials":{"googleDriveOAuth2Api":{"id":"uixLsi5TmrfwXPeB","name":"Google Drive account"}},"typeVersion":1,"notes":"This googleDriveTrigger node performs automated tasks as part of the workflow."},{"id":"3a6c6cef-7a19-42ef-8092-eaf57dae4cdd","name":"Google Drive File Created","type":"n8n-nodes-base.googleDriveTrigger","position":[140,-120],"parameters":{"event":"fileCreated","options":{"fileType":"all"},"pollTimes":{"item":[{"mode":"everyMinute"}]},"triggerOn":"specificFolder","folderToWatch":{"__rl":true,"mode":"list","value":"1evDIoHePhjw_LgVFZXSZyK1sZm2GHp9W","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"INNOVI PRO"}},"credentials":{"googleDriveOAuth2Api":{"id":"uixLsi5TmrfwXPeB","name":"Google Drive account"}},"typeVersion":1,"notes":"This googleDriveTrigger node performs automated tasks as part of the workflow."},{"id":"1e38f1c8-7bd0-4eeb-addc-62339582d350","name":"Window Buffer Memory","type":"n8n-nodes-base.noOp","position":[500,1140],"parameters":{},"typeVersion":1,"notes":"This memoryBufferWindow node performs automated tasks as part of the workflow."},{"id":"4b0ab858-99b1-4337-8c5c-a223519e3662","name":"When chat message received","type":"n8n-nodes-base.noOp","position":[80,840],"webhookId":"5f1c0c82-0ff9-40c7-9e2e-b1a96ffe24cd","parameters":{"options":{}},"typeVersion":1,"notes":"This chatTrigger node performs automated tasks as part of the workflow."},{"id":"bfb684d1-e5c1-41da-8305-b2606a2eade6","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[440,-240],"parameters":{"width":320,"content":"## Add docuemnts to vector store when updating or creating new documents in Google Drive"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"8f627ec6-4b3f-43ad-a4a3-e2b199a7fe58","name":"Google Gemini Chat Model","type":"n8n-nodes-base.noOp","position":[320,1140],"parameters":{"options":{},"modelName":"models/gemini-2.0-flash-exp"},"credentials":{"googlePalmApi":{"id":"jLOqyTR4yTT1nYKi","name":"Google Gemini(PaLM) Api account"}},"typeVersion":1,"notes":"This lmChatGoogleGemini node performs automated tasks as part of the workflow."},{"id":"f2133a06-0088-46de-9f74-a3f9fe478f98","name":"Google Gemini Chat Model (retrieval)","type":"n8n-nodes-base.noOp","position":[1080,1240],"parameters":{"options":{},"modelName":"models/gemini-2.0-flash-exp"},"credentials":{"googlePalmApi":{"id":"jLOqyTR4yTT1nYKi","name":"Google Gemini(PaLM) Api account"}},"typeVersion":1,"notes":"This lmChatGoogleGemini node performs automated tasks as part of the workflow."},{"id":"578deb96-8393-4850-9757-fa97b2bc9992","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[-540,220],"parameters":{"width":420,"height":720,"content":"## Set up steps\n\n1. Google Cloud Project and Vertex AI API:\n* Create a Google Cloud project.\n* Enable the Vertex AI API for your project.\n2. Google AI API Key:\n* Obtain a Google AI API key from Google AI Studio.\n3. Pinecone Account:\n* Create a free account on the Pinecone website.\nObtain your API key from your Pinecone dashboard.\n* Create an index named company-files in your Pinecone project.\n4. Google Drive:\n* Create a dedicated folder in your Google Drive where company documents will be stored.\n5. Credentials in n8n: Configure credentials in your n8n environment for:\n* Google Drive OAuth2\n* Google Gemini(PaLM) Api (using your Google AI API key)\n* Pinecone API (using your Pinecone API key)\n5. Import the Workflow:\n* Import this workflow into your n8n instance.\n6. Configure the Workflow:\n* Update both Google Drive Trigger nodes to watch the specific folder you created in your Google Drive.\n* Configure the Pinecone Vector Store nodes to use your company-files index."},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"error-6f270e81","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"versionId":"33b252fb-5d87-4a29-a0a7-97308140699c","connections":{"Embeddings Google Gemini":{"main":[[]]},"Embeddings Google Gemini (retrieval)":{"main":[[]]},"Download File From Google Drive":{"main":[[]]},"Google Drive File Updated":{"main":[[]]},"Google Drive File Created":{"main":[[]]},"Google Gemini Chat Model":{"main":[[]]},"Google Gemini Chat Model (retrieval)":{"main":[[]]}},"description":"Automated workflow: RAG Workflow For Company Documents stored in Google Drive. This workflow integrates 13 different services: stickyNote, vectorStorePinecone, embeddingsGoogleGemini, googleDriveTrigger, textSplitterRecursiveCharacterTextSplitter. It contains 25 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: RAG Workflow For Company Documents stored in Google Drive. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}