{
"name": "Organized PDF to Sheets Workflow",
"nodes": [
{
"parameters": {},
"id": "sticky-tools",
"name": "Sticky Note - Tools",
"type": "n8n-nodes-base.stickyNote",
"position": [220, 20],
"typeVersion": 1,
"notes": "🔧 TOOLS & MODELS\nConfigured AI and integration tools"
},
{
"parameters": {},
"id": "sticky-setup",
"name": "Sticky Note - Setup",
"type": "n8n-nodes-base.stickyNote",
"position": [480, 320],
"typeVersion": 1,
"notes": "🏗️ SHEET SETUP WORKFLOW\nCreates spreadsheet structure (runs once)"
},
{
"parameters": {},
"id": "sticky-extract",
"name": "Sticky Note - Extract",
"type": "n8n-nodes-base.stickyNote",
"position": [480, 520],
"typeVersion": 1,
"notes": "🤖 DATA EXTRACTION WORKFLOW\nProcesses PDF pages and extracts data"
},
{
"parameters": {},
"id": "sticky-error",
"name": "Sticky Note - Error",
"type": "n8n-nodes-base.stickyNote",
"position": [1120, 140],
"typeVersion": 1,
"notes": "⚠️ ERROR HANDLING & LOGGING\nRetry logic and result tracking"
},
{
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o"
}
},
"id": "openai-model",
"name": "OpenAI Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [260, 80],
"typeVersion": 1
},
{
"parameters": {},
"id": "browser-tool",
"name": "Browser Tool",
"type": "@n8n/n8n-nodes-langchain.toolWebScraper",
"position": [460, 80],
"typeVersion": 1
},
{
"parameters": {
"authentication": "oAuth2",
"operation": "append"
},
"id": "sheets-tool",
"name": "Sheets Tool",
"type": "@n8n/n8n-nodes-langchain.toolGoogleSheets",
"position": [660, 80],
"typeVersion": 1
},
{
"parameters": {},
"id": "start-system",
"name": "Start System",
"type": "n8n-nodes-base.manualTrigger",
"position": [120, 260],
"typeVersion": 1
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "mode-assignment",
"name": "mode",
"type": "string",
"value": "extract"
}
]
},
"options": {}
},
"id": "mode-selector",
"name": "Mode Selector",
"type": "n8n-nodes-base.set",
"position": [340, 260],
"typeVersion": 3.4,
"notes": "Change mode: 'setup' or 'extract'"
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.mode }}",
"value2": "setup"
}
]
}
},
"id": "setup-mode-check",
"name": "Setup Mode?",
"type": "n8n-nodes-base.if",
"position": [560, 260],
"typeVersion": 1
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "sheet-name",
"name": "sheetName",
"type": "string",
"value": "Product Data"
},
{
"id": "columns",
"name": "columns",
"type": "array",
"value": "=['Product Name', 'Price', 'Description', 'Availability']"
}
]
},
"options": {}
},
"id": "setup-config",
"name": "Setup Config",
"type": "n8n-nodes-base.set",
"position": [760, 360],
"typeVersion": 3.4
},
{
"parameters": {
"agent": "conversationalAgent",
"promptType": "define",
"text": "=Create a Google Sheet named '{{ $json.sheetName }}' with columns: {{ $json.columns.join(', ') }}. Return the sheet ID.",
"hasOutputParser": true,
"options": {
"systemMessage": "You are a spreadsheet setup assistant."
}
},
"id": "sheet-setup-agent",
"name": "Sheet Setup Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [980, 360],
"typeVersion": 1.7,
"credentials": {
"openAiApi": {
"id": "your-openai-cred-id",
"name": "OpenAI account"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "pdf-url",
"name": "pdfUrl",
"type": "string",
"value": "https://example.com/product-catalog.pdf"
},
{
"id": "sheet-id",
"name": "sheetId",
"type": "string",
"value": "YOUR_SHEET_ID"
},
{
"id": "retry-count",
"name": "retryCount",
"type": "number",
"value": 0
},
{
"id": "max-retries",
"name": "maxRetries",
"type": "number",
"value": 3
}
]
},
"options": {}
},
"id": "extract-config",
"name": "Extract Config",
"type": "n8n-nodes-base.set",
"position": [760, 620],
"typeVersion": 3.4
},
{
"parameters": {
"mode": "combine",
"combineBy": "combineAll",
"options": {}
},
"id": "split-pages",
"name": "Split Pages",
"type": "n8n-nodes-base.merge",
"position": [980, 620],
"typeVersion": 2.1,
"notes": "Simulates page splitting - replace with actual PDF splitter"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "page-num",
"name": "currentPage",
"type": "number",
"value": "={{ $itemIndex + 1 }}"
},
{
"id": "page-context",
"name": "pageContext",
"type": "string",
"value": "=Page {{ $itemIndex + 1 }} of PDF"
}
]
},
"options": {}
},
"id": "set-page-context",
"name": "Set Page Context",
"type": "n8n-nodes-base.set",
"position": [1200, 620],
"typeVersion": 3.4
},
{
"parameters": {
"agent": "conversationalAgent",
"promptType": "define",
"text": "=Extract product data from {{ $json.pageContext }}. For each product found, add a row to sheet {{ $json.sheetId }} with: Product Name, Price, Description, Availability.",
"hasOutputParser": true,
"options": {
"systemMessage": "You are a data extraction assistant. Extract structured product information and save to Google Sheets."
}
},
"id": "data-extraction-agent",
"name": "Data Extraction Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [1420, 620],
"typeVersion": 1.7,
"credentials": {
"openAiApi": {
"id": "your-openai-cred-id",
"name": "OpenAI account"
}
}
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.error }}",
"operation": "isEmpty"
}
]
}
},
"id": "error-check",
"name": "Error Check",
"type": "n8n-nodes-base.if",
"position": [1640, 620],
"typeVersion": 1
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.retryCount }}",
"operation": "smaller",
"value2": "={{ $json.maxRetries }}"
}
]
}
},
"id": "retry-check",
"name": "Retry Check",
"type": "n8n-nodes-base.if",
"position": [1640, 800],
"typeVersion": 1
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "increment",
"name": "retryCount",
"type": "number",
"value": "={{ $json.retryCount + 1 }}"
}
]
},
"options": {}
},
"id": "increment-retry",
"name": "Increment Retry",
"type": "n8n-nodes-base.set",
"position": [1860, 720],
"typeVersion": 3.4
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_LOG_SHEET_ID"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Timestamp": "={{ $now }}",
"Status": "Retry",
"Page": "={{ $json.currentPage }}",
"Attempt": "={{ $json.retryCount }}",
"Error": "={{ $json.error }}"
}
},
"options": {}
},
"id": "log-retry",
"name": "Log Retry",
"type": "n8n-nodes-base.googleSheets",
"position": [2080, 800],
"typeVersion": 4.5
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_LOG_SHEET_ID"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Timestamp": "={{ $now }}",
"Status": "Max Retries Reached",
"Page": "={{ $json.currentPage }}",
"Attempt": "={{ $json.retryCount }}",
"Error": "={{ $json.error }}"
}
},
"options": {}
},
"id": "log-max-retries",
"name": "Log Max Retries",
"type": "n8n-nodes-base.googleSheets",
"position": [1860, 880],
"typeVersion": 4.5
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_LOG_SHEET_ID"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Timestamp": "={{ $now }}",
"Status": "Success",
"Page": "={{ $json.currentPage }}",
"Rows_Added": "={{ $json.output }}"
}
},
"options": {}
},
"id": "log-success",
"name": "Log Success",
"type": "n8n-nodes-base.googleSheets",
"position": [1860, 540],
"typeVersion": 4.5
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "result",
"name": "finalResult",
"type": "string",
"value": "={{ $json.output }}"
}
]
},
"options": {}
},
"id": "parse-output",
"name": "Parse Output",
"type": "n8n-nodes-base.set",
"position": [2080, 540],
"typeVersion": 3.4
}
],
"connections": {
"Start System": {
"main": [[{"node": "Mode Selector", "type": "main", "index": 0}]]
},
"Mode Selector": {
"main": [[{"node": "Setup Mode?", "type": "main", "index": 0}]]
},
"Setup Mode?": {
"main": [
[{"node": "Setup Config", "type": "main", "index": 0}],
[{"node": "Extract Config", "type": "main", "index": 0}]
]
},
"Setup Config": {
"main": [[{"node": "Sheet Setup Agent", "type": "main", "index": 0}]]
},
"Sheet Setup Agent": {
"ai_tool": [[{"node": "Sheets Tool", "type": "ai_tool", "index": 0}]],
"ai_languageModel": [[{"node": "OpenAI Model", "type": "ai_languageModel", "index": 0}]]
},
"Extract Config": {
"main": [[{"node": "Split Pages", "type": "main", "index": 0}]]
},
"Split Pages": {
"main": [[{"node": "Set Page Context", "type": "main", "index": 0}]]
},
"Set Page Context": {
"main": [[{"node": "Data Extraction Agent", "type": "main", "index": 0}]]
},
"Data Extraction Agent": {
"main": [[{"node": "Error Check", "type": "main", "index": 0}]],
"ai_tool": [
[
{"node": "Sheets Tool", "type": "ai_tool", "index": 0},
{"node": "Browser Tool", "type": "ai_tool", "index": 0}
]
],
"ai_languageModel": [[{"node": "OpenAI Model", "type": "ai_languageModel", "index": 0}]]
},
"Error Check": {
"main": [
[{"node": "Log Success", "type": "main", "index": 0}],
[{"node": "Retry Check", "type": "main", "index": 0}]
]
},
"Retry Check": {
"main": [
[{"node": "Increment Retry", "type": "main", "index": 0}],
[{"node": "Log Max Retries", "type": "main", "index": 0}]
]
},
"Increment Retry": {
"main": [[{"node": "Log Retry", "type": "main", "index": 0}]]
},
"Log Retry": {
"main": [[{"node": "Set Page Context", "type": "main", "index": 0}]]
},
"Log Success": {
"main": [[{"node": "Parse Output", "type": "main", "index": 0}]]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"tags": [],
"triggerCount": 1,
"updatedAt": "2025-11-07T00:00:00.000Z",
"versionId": "1"
}
