This workflow follows the Google Drive → Google Drive Trigger 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 →
{
"name": "Warranty Document & Claim Tracker",
"nodes": [
{
"parameters": {
"content": "## \ud83d\udee1\ufe0f Warranty Document Tracker\n\n### How it works\n1. Watches Google Drive folder for warranty documents\n2. Downloads and extracts product info, purchase details, warranty terms\n3. Calculates expiration date and days remaining\n4. Determines status: Active, Expiring Soon, or Expired\n5. Logs all warranty data to Google Sheets tracker\n6. Sends Slack alert when warranty expires within 30 days\n\n### Setup steps\n1. Create Google Drive folder for warranty documents\n2. Get PDF Vector API key from pdfvector.com/api-keys\n3. Create Google Sheet with columns: Product, Brand, Model, Serial Number, Purchase Date, Purchase Price, Retailer, Warranty Type, Expires, Days Remaining, Status, Coverage, Document Link, Added Date\n4. Connect Google Drive, Sheets, and Slack credentials\n5. Update folder ID and spreadsheet ID in nodes\n\n### Perfect for\n- Consumers tracking product warranties\n- Customer service teams managing claims\n- Retail businesses with inventory warranties\n- Electronics companies tracking coverage",
"height": 560,
"width": 380,
"color": 5
},
"id": "ced06c26-b8a4-49ed-8854-31d0b88c6631",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-336,
16
]
},
{
"parameters": {
"content": "## \ud83d\udcc5 Extracted Data\n\n- Product name, brand, model\n- Serial number\n- Purchase date and price\n- Retailer information\n- Warranty type and duration\n- Coverage details\n- Exclusions list\n- Claim process\n- Contact information",
"height": 280,
"width": 220
},
"id": "d8414874-442d-4ce8-9414-6e755250c728",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
464,
-96
]
},
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"value": "YOUR_FOLDER_ID",
"mode": "list",
"cachedResultName": "Warranty Documents"
},
"event": "fileCreated",
"options": {}
},
"id": "dba3c47c-76df-49ea-893d-1055eae74433",
"name": "Google Drive Trigger",
"type": "n8n-nodes-base.googleDriveTrigger",
"typeVersion": 1,
"position": [
112,
176
],
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
},
"notes": "Watch for warranty documents"
},
{
"parameters": {
"operation": "download",
"fileId": "={{ $json.id }}",
"options": {}
},
"id": "49c993e7-7e54-4e8c-ab32-8cad52d8211c",
"name": "Download Document",
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
320,
176
],
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "extract",
"inputType": "file",
"prompt": "Extract warranty document data as flat fields. productName, brandName, modelNumber, serialNumber, purchaseDate (YYYY-MM-DD), purchasePrice (number), retailerName, retailerAddress, warrantyType (one of: Manufacturer, Extended, Limited, Full, Parts Only, Other), warrantyStartDate (YYYY-MM-DD), warrantyEndDate (YYYY-MM-DD), warrantyDurationMonths (number), coverageList (semicolon-separated what is covered), exclusionsList (semicolon-separated what is NOT covered), claimContactPhone, claimContactEmail, claimWebsite, registrationRequired (true/false), registrationDeadlineDays (number), proofOfPurchaseRequired (true/false), transferable (true/false).",
"schema": "{\"type\": \"object\", \"properties\": {\"productName\": {\"type\": \"string\"}, \"brandName\": {\"type\": \"string\"}, \"modelNumber\": {\"type\": \"string\"}, \"serialNumber\": {\"type\": \"string\"}, \"purchaseDate\": {\"type\": \"string\"}, \"purchasePrice\": {\"type\": \"number\"}, \"retailerName\": {\"type\": \"string\"}, \"retailerAddress\": {\"type\": \"string\"}, \"warrantyType\": {\"type\": \"string\"}, \"warrantyStartDate\": {\"type\": \"string\"}, \"warrantyEndDate\": {\"type\": \"string\"}, \"warrantyDurationMonths\": {\"type\": \"number\"}, \"coverageList\": {\"type\": \"string\"}, \"exclusionsList\": {\"type\": \"string\"}, \"claimContactPhone\": {\"type\": \"string\"}, \"claimContactEmail\": {\"type\": \"string\"}, \"claimWebsite\": {\"type\": \"string\"}, \"registrationRequired\": {\"type\": \"boolean\"}, \"registrationDeadlineDays\": {\"type\": \"number\"}, \"proofOfPurchaseRequired\": {\"type\": \"boolean\"}, \"transferable\": {\"type\": \"boolean\"}}, \"additionalProperties\": false}"
},
"id": "6fd80a0e-7700-40cd-a511-00934c12ce48",
"name": "PDF Vector - Extract Warranty",
"type": "n8n-nodes-pdfvector.pdfVector",
"typeVersion": 2,
"position": [
512,
176
],
"credentials": {
"pdfVectorApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "const data = ($input.first().json?.data || $input.first().json) || {};\nconst fileName = $('Google Drive Trigger').item.json.name;\nconst fileId = $('Google Drive Trigger').item.json.id;\n\nlet daysRemaining = 'N/A'; let warrantyStatus = 'Unknown';\nif (data.warrantyEndDate) {\n const end = new Date(data.warrantyEndDate); const today = new Date();\n daysRemaining = Math.ceil((end - today) / (1000*60*60*24));\n if (daysRemaining < 0) warrantyStatus = 'Expired';\n else if (daysRemaining <= 30) warrantyStatus = 'Expiring Soon';\n else if (daysRemaining <= 90) warrantyStatus = 'Expiring This Quarter';\n else warrantyStatus = 'Active';\n}\n\nreturn [{ json: {\n productName: data.productName || 'Unknown',\n brandName: data.brandName || 'N/A',\n modelNumber: data.modelNumber || 'N/A',\n serialNumber: data.serialNumber || 'N/A',\n purchaseDate: data.purchaseDate || 'N/A',\n purchasePrice: parseFloat(data.purchasePrice) || 0,\n retailerName: data.retailerName || 'N/A',\n warrantyType: data.warrantyType || 'N/A',\n warrantyEndDate: data.warrantyEndDate || 'N/A',\n daysRemaining,\n warrantyStatus,\n coverageList: data.coverageList || 'N/A',\n exclusionsList: data.exclusionsList || 'N/A',\n claimContactPhone: data.claimContactPhone || 'N/A',\n claimWebsite: data.claimWebsite || 'N/A',\n fileName, fileId,\n processedAt: new Date().toISOString()\n}}];"
},
"id": "6d3f8c9a-01fc-4a69-a9a8-dc5de261e16f",
"name": "Process Warranty",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
720,
176
]
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "list",
"cachedResultName": "Warranty Tracker"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Warranty Log"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Product": "={{ $json.productName }}",
"Brand": "={{ $json.brandName }}",
"Model": "={{ $json.modelNumber }}",
"Serial Number": "={{ $json.serialNumber }}",
"Purchase Date": "={{ $json.purchaseDate }}",
"Purchase Price": "={{ $json.purchasePrice }}",
"Retailer": "={{ $json.retailerName }}",
"Warranty Type": "={{ $json.warrantyType }}",
"Expires": "={{ $json.warrantyEndDate }}",
"Days Remaining": "={{ $json.daysRemaining }}",
"Status": "={{ $json.warrantyStatus }}",
"Coverage": "={{ $json.coverageList }}",
"Document Link": "=https://drive.google.com/file/d/{{ $json.fileId }}/view",
"Added Date": "={{ $json.processedAt.split('T')[0] }}"
},
"matchingColumns": [],
"schema": [
{
"id": "Product",
"displayName": "Product",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Brand",
"displayName": "Brand",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Model",
"displayName": "Model",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Serial Number",
"displayName": "Serial Number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Purchase Date",
"displayName": "Purchase Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Purchase Price",
"displayName": "Purchase Price",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Retailer",
"displayName": "Retailer",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Warranty Type",
"displayName": "Warranty Type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Expires",
"displayName": "Expires",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Days Remaining",
"displayName": "Days Remaining",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Status",
"displayName": "Status",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Coverage",
"displayName": "Coverage",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Document Link",
"displayName": "Document Link",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Added Date",
"displayName": "Added Date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"id": "a8e4ba40-e269-4cbf-99c1-0493c5c7de76",
"name": "Log to Warranty Tracker",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.4,
"position": [
912,
176
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 1
},
"conditions": [
{
"id": "fd3dfb7e-40fc-49c0-bee4-c6f640645347",
"leftValue": "={{ $('Process Warranty').item.json.warrantyStatus }}",
"rightValue": "Expired",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"id": "95988fe1-cade-4e05-b22f-0efa6bef5e2f",
"name": "Expiring Soon?",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
1120,
176
]
},
{
"parameters": {
"authentication": "oAuth2",
"select": "channel",
"channelId": {
"__rl": true,
"value": "YOUR_SLACK_CHANNEL_ID",
"mode": "list",
"cachedResultName": "warranty-alerts"
},
"text": "=\u26a0\ufe0f *Warranty Expiring Soon!*\n\n*Product:* {{ $('Process Warranty').item.json.productName }}\n*Brand:* {{ $('Process Warranty').item.json.productBrand || 'N/A' }}\n*Model:* {{ $('Process Warranty').item.json.productModel || 'N/A' }}\n\n\ud83d\udcc5 *Expires:* {{ $('Process Warranty').item.json.warrantyEndDate }}\n\u23f0 *Days Remaining:* {{ $('Process Warranty').item.json.daysRemaining }}\n\n*Coverage:* {{ $('Process Warranty').item.json.coverageList }}\n\nConsider filing any claims before warranty expires!",
"otherOptions": {}
},
"id": "787b5e0e-25f7-48e3-8b89-9a3c6d1e8cef",
"name": "Alert Expiring",
"type": "n8n-nodes-base.slack",
"typeVersion": 2.2,
"position": [
1312,
64
],
"credentials": {
"slackOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Google Drive Trigger": {
"main": [
[
{
"node": "Download Document",
"type": "main",
"index": 0
}
]
]
},
"Download Document": {
"main": [
[
{
"node": "PDF Vector - Extract Warranty",
"type": "main",
"index": 0
}
]
]
},
"PDF Vector - Extract Warranty": {
"main": [
[
{
"node": "Process Warranty",
"type": "main",
"index": 0
}
]
]
},
"Process Warranty": {
"main": [
[
{
"node": "Log to Warranty Tracker",
"type": "main",
"index": 0
}
]
]
},
"Log to Warranty Tracker": {
"main": [
[
{
"node": "Expiring Soon?",
"type": "main",
"index": 0
}
]
]
},
"Expiring Soon?": {
"main": [
[
{
"node": "Alert Expiring",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": []
}
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.
googleDriveOAuth2ApigoogleSheetsOAuth2ApipdfVectorApislackOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Warranty Document & Claim Tracker. Uses googleDriveTrigger, googleDrive, n8n-nodes-pdfvector, googleSheets. Event-driven trigger; 9 nodes.
Source: https://github.com/khanhduyvt0101/workflows/blob/0153ee2efc0f692c931b9bb4c2a04abf11756822/n8n-workflows/warranty-document-tracker.json — 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.
Lease Agreement Analyzer for Renters. Uses googleDriveTrigger, googleDrive, n8n-nodes-pdfvector, googleSheets. Event-driven trigger; 12 nodes.
Google Drive Trigger, Google Drive, N8N Nodes Pdfvector +2
Expense Report Processor with AI Categorization. Uses googleDriveTrigger, googleDrive, n8n-nodes-pdfvector, googleSheets. Event-driven trigger; 12 nodes.
Google Drive Trigger, Google Drive, N8N Nodes Pdfvector +2
Financial Report Analyzer (10-K, 10-Q). Uses googleDriveTrigger, googleDrive, n8n-nodes-pdfvector, googleSheets. Event-driven trigger; 11 nodes.
Google Drive Trigger, Google Drive, N8N Nodes Pdfvector +2
AI Contract Review & Risk Analysis. Uses googleDriveTrigger, googleDrive, n8n-nodes-pdfvector, googleSheets. Event-driven trigger; 10 nodes.
Google Drive Trigger, Google Drive, N8N Nodes Pdfvector +2
Patient Intake Form Processor for Healthcare. Uses googleDriveTrigger, googleDrive, n8n-nodes-pdfvector, googleSheets. Event-driven trigger; 10 nodes.
Google Drive Trigger, Google Drive, N8N Nodes Pdfvector +2