Alok Kumar This workflow corresponds to n8n.io template #7717 — we link there as the canonical source.
This workflow follows the Documentdefaultdataloader → OpenAI Embeddings recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "xDiuqZUZnShKpPzX",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Parse, Normalize, Extract, and Store PDF Content for RAG in Pinecone",
"tags": [],
"nodes": [
{
"id": "19b009db-a418-458c-a216-bdcc9af6fd2f",
"name": "Google Drive Trigger",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-1504,
2080
],
"parameters": {
"event": "fileCreated",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "ff933f76-d719-40b5-b193-8a29e5fa2197",
"name": "Download file",
"type": "n8n-nodes-base.googleDrive",
"position": [
-1248,
2096
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 3
},
{
"id": "127b41ed-ad45-4234-b87f-4f3c2b6ea531",
"name": "Default Data Loader",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
528,
2192
],
"parameters": {
"options": {},
"textSplittingMode": "custom"
},
"typeVersion": 1.1
},
{
"id": "0316c7d4-449f-4275-a9b1-8848545beba8",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
1712
],
"parameters": {
"width": 736,
"height": 832,
"content": "## Save to Vector DB"
},
"typeVersion": 1
},
{
"id": "b06702b5-c322-4a5a-949a-855c8b97dadc",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1088,
1720
],
"parameters": {
"color": 4,
"width": 1392,
"height": 656,
"content": "## Prepare data - Parse and Normalize\n"
},
"typeVersion": 1
},
{
"id": "05034e35-f6bf-45a6-860e-94f4da566daf",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
-720,
2088
],
"parameters": {
"amount": 30
},
"typeVersion": 1.1
},
{
"id": "9bb49bf6-a02e-4cf7-a1d1-ca4addff2bc6",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
-272,
2016
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7a07aec1-fc5f-4b76-94d9-6fa8f509ac8e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "SUCCESS"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "28654aff-e603-4080-9e7a-e706aaee47c4",
"name": "Wait2",
"type": "n8n-nodes-base.wait",
"position": [
-48,
2184
],
"parameters": {
"amount": 60
},
"typeVersion": 1.1
},
{
"id": "ba935542-d2c0-4781-b6f9-5e1e007a9740",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
1584
],
"parameters": {
"width": 288,
"height": 352,
"content": "## Normalized Content\n\n* Removes noise\n* Reduces duplication\n* Improves retrieval quality \n* Preserves context \n* Consistent format \n* Prevents wasted tokens \n\n**Note : Update the code based in your requirement**"
},
"typeVersion": 1
},
{
"id": "45efcdf9-89a9-4638-a9ed-cac39506270f",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2080,
1472
],
"parameters": {
"width": 464,
"height": 1200,
"content": "## Try It Out! \n### This n8n template demonstrates how to normalize, index, and query insurance PDFs using AI and Pinecone for a full **RAG (Retrieval-Augmented Generation)** workflow. \n\n### Use cases include: creating **chatbots or Q&A systems** for structured documents, extracting insights from insurance policies, or managing compliance/legal PDFs efficiently. \n\n---\n\n## How it works\n* New PDFs are automatically detected from a **Google Drive** folder. \n* PDFs are sent to **LlamaIndex Cloud** for parsing \u2192 returns clean Markdown text. \n* Text is normalized to remove headers, footers, page numbers, and formatting artifacts. \n* The normalized text is split into chunks (~1200 characters with 150-character overlap) for better embedding. \n* **OpenAI embeddings** are generated for each chunk. \n* Chunks and metadata are stored in **Pinecone** for semantic search. \n* A **Chat Agent** queries Pinecone to retrieve answers from your document vector database. \n\n---\n\n### How to use\n* Update the folder name in google drive trigger node. \n* Place a pdf file in the same folder in google drive.\n* Customize the `Normalized Content` function node to adjust regex for headers/footers specific to your documents. \n* Adjust chunk size or metadata namespace in the Pinecone node to fit your project needs. \n\n---\n\n### Requirements\n* Google Drive account for PDF source files. \n* **LlamaIndex Cloud** account (parsing API key). \n* **Pinecone** account for vector storage. \n* **OpenAI** account for model and embeddings. \n\n---\n\n### Need Help? \nask in the [n8n Forum](https://community.n8n.io/)! \n\nHappy Automating! \ud83d\ude80\n"
},
"typeVersion": 1
},
{
"id": "34f5ba5e-7f4e-4c94-a4e8-41bfbaf163a1",
"name": "Upload to Llama Cloud",
"type": "n8n-nodes-base.httpRequest",
"position": [
-944,
2088
],
"parameters": {
"url": "https://api.cloud.llamaindex.ai/api/v1/parsing/upload",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "file",
"parameterType": "formBinaryData",
"inputDataFieldName": "data"
}
]
},
"genericAuthType": "httpBearerAuth",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
},
{
"name": "Content-Type",
"value": "multipart/form-data"
}
]
}
},
"credentials": {
"httpBearerAuth": {
"name": "<your credential>"
}
},
"executeOnce": false,
"retryOnFail": true,
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "1199e4ff-1952-4225-b655-1f63875f8903",
"name": "Check Parsing Status",
"type": "n8n-nodes-base.httpRequest",
"position": [
-496,
2088
],
"parameters": {
"url": "=https://api.cloud.llamaindex.ai/api/parsing/job/{{ $('Upload to Llama Cloud').item.json.id }}",
"options": {},
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpBearerAuth",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpBearerAuth": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "cfaf9e10-0297-423a-b3f4-c25561c92078",
"name": "Extract Markdown from Llama Cloud",
"type": "n8n-nodes-base.httpRequest",
"position": [
-48,
1968
],
"parameters": {
"url": "=https://api.cloud.llamaindex.ai/api/v1/parsing/job/{{ $json.id }}/result/markdown",
"options": {},
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpBearerAuth",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpBearerAuth": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "564a0930-e80b-4db6-a62a-5224248e5cd9",
"name": "Normalize Text",
"type": "n8n-nodes-base.code",
"position": [
176,
1968
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Get the input text from the previous node\nconst input = $json.markdown || $json.text || \"\";\n\nlet text = input.replace(/Car Insurance Policy\\s*\\d+/gi, \"\");\n\n// Remove \"Page X\" markers\ntext = text.replace(/Page\\s*\\d+/gi, \"\");\n\n// Replace --- dividers with a single newline\ntext = text.replace(/-{3,}/g, \"\\n\");\n\n// Decode & cleanup artifacts\ntext = text.replace(/&/g, \"&\"); // fix HTML entities\ntext = text.replace(/[\u24e4]/g, \"-\"); // replace bullet symbols with dashes\n\n// Collapse whitespace\ntext = text.replace(/\\n{2,}/g, \"\\n\\n\"); // keep paragraph breaks\ntext = text.replace(/[ \\t]+/g, \" \"); // collapse spaces\n\n// Step 5: Trim\ntext = text.trim();\n\n// Output for next node\nreturn { json: { normalizedText: text } };\n"
},
"typeVersion": 2
},
{
"id": "fe32694a-2cbc-4ad4-88aa-4eb3dba0256c",
"name": "Chunk Text",
"type": "@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter",
"position": [
608,
2400
],
"parameters": {
"options": {
"splitCode": "markdown"
},
"chunkSize": 1200,
"chunkOverlap": 150
},
"typeVersion": 1
},
{
"id": "b399c9fa-03d7-4126-9026-674d091b9ddf",
"name": "Generate Embeddings",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
400,
2192
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
},
{
"id": "1da27207-b77e-41d0-a249-5096ec8ac259",
"name": "Store in Pinecone",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
432,
1968
],
"parameters": {
"mode": "insert",
"options": {
"pineconeNamespace": "rag"
},
"pineconeIndex": {
"__rl": true,
"mode": "id",
"value": "demo"
}
},
"credentials": {
"pineconeApi": {
"name": "<your credential>"
}
},
"notesInFlow": false,
"typeVersion": 1.3
},
{
"id": "4f65ec8b-f936-41cb-b05c-0cc710df1c9e",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1568,
1728
],
"parameters": {
"color": 6,
"width": 464,
"height": 640,
"content": "## Extract Data"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "5ec0ee83-34cd-423d-8bd5-41400bde4a4a",
"connections": {
"If": {
"main": [
[
{
"node": "Extract Markdown from Llama Cloud",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Check Parsing Status",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Check Parsing Status",
"type": "main",
"index": 0
}
]
]
},
"Chunk Text": {
"ai_textSplitter": [
[
{
"node": "Default Data Loader",
"type": "ai_textSplitter",
"index": 0
}
]
]
},
"Download file": {
"main": [
[
{
"node": "Upload to Llama Cloud",
"type": "main",
"index": 0
}
]
]
},
"Normalize Text": {
"main": [
[
{
"node": "Store in Pinecone",
"type": "main",
"index": 0
}
]
]
},
"Store in Pinecone": {
"main": [
[]
]
},
"Default Data Loader": {
"ai_document": [
[
{
"node": "Store in Pinecone",
"type": "ai_document",
"index": 0
}
]
]
},
"Generate Embeddings": {
"ai_embedding": [
[
{
"node": "Store in Pinecone",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Check Parsing Status": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Trigger": {
"main": [
[
{
"node": "Download file",
"type": "main",
"index": 0
}
]
]
},
"Upload to Llama Cloud": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Extract Markdown from Llama Cloud": {
"main": [
[
{
"node": "Normalize Text",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleDriveOAuth2ApihttpBearerAuthopenAiApipineconeApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow automates a full RAG pipeline for structured documents (like insurance policies). Watches a Google Drive folder for new PDFs Uploads to LlamaIndex Cloud for parsing → returns clean Markdown Normalizes text (removes headers, footers, page numbers, formatting…
Source: https://n8n.io/workflows/7717/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
RAG_Ingest. Uses httpRequest, vectorStoreSupabase, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter. Event-driven trigger; 73 nodes.
HTTP Request, Supabase Vector Store, Document Default Data Loader +4
This n8n template automatically classifies incoming emails (Sales, Support, Internal, Finance, Promotions) and routes them to a dedicated OpenAI LLM Agent for processing. Depending on the category, th
OpenAI, Gmail, Text Classifier +16
Automate Outreach Prospect automates finding, enriching, and messaging potential partners (like restaurants, malls, and bars) using Apify Google Maps scraping, Perplexity enrichment, OpenAI LLMs, Goog
@Devlikeapro/N8N Nodes Waha, Google Drive Trigger, @Apify/N8N Nodes Apify +14
Chat with docs - 5minAI New version. Uses httpRequest, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, embeddingsOpenAi. Event-driven trigger; 62 nodes.
HTTP Request, Document Default Data Loader, Text Splitter Recursive Character Text Splitter +10
I prepared a detailed guide that illustrates the entire process of building an AI agent using Supabase and Google Drive within N8N workflows.
HTTP Request, Document Default Data Loader, Text Splitter Recursive Character Text Splitter +10