I have a workflow that downloads proofs from an API and uploads them to Google Drive. When uploading to one specific Shared Drive, each file gets uploaded 3 times (3 proofs = 9 files). The same workflow works fine with other drives.
workflow
{
“nodes”: [
{
“parameters”: {},
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
-2624,
1072
],
“id”: “bdc0042f-4aab-4d9a-8644-0129a5b7a5eb”,
“name”: “When clicking ‘Execute workflow’”
},
{
“parameters”: {
“authentication”: “serviceAccount”,
“operation”: “download”,
“fileId”: {
“__rl”: true,
“value”: “1W0MmHWpgJf0CRFsccjehyVghFVQo9kfcAbqiCgGG1cQ”,
“mode”: “”
},
“options”: {}
},
“id”: “4ecb1b1e-9558-4939-bdbd-60d03a60515d”,
“name”: “Download Google Sheet3”,
“type”: “n8n-nodes-base.googleDrive”,
“typeVersion”: 2,
“position”: [
-2336,
1056
],
“credentials”: {
“googleApi”: {
“id”: “4vuNC6LlRuero6WA”,
“name”: “Claim Ops Service Account”
}
}
},
{
“parameters”: {
“functionCode”: “return $items(‘Read DHL Tab’).map(i => ({\n json: {\n “ORDER_OR_PARCEL_URL”: i.json[“ORDER_OR_PARCEL_URL”],\n “Tracking Number”: i.json[“Tracking Number”]\n }\n}));”
},
“id”: “0e4871f1-8e91-44c9-8f78-9facb7bbe993”,
“name”: “Pick Required Columns3”,
“type”: “n8n-nodes-base.function”,
“typeVersion”: 1,
“position”: [
-896,
1056
]
},
{
“parameters”: {
“batchSize”: 1,
“options”: {}
},
“id”: “c665808d-ca0d-45be-8f8e-85a350f67522”,
“name”: “Split In Batches3”,
“type”: “n8n-nodes-base.splitInBatches”,
“typeVersion”: 1,
“position”: [
-176,
1248
]
},
{
“parameters”: {
“url”: “``https://claims.prod.deliverr.com/claims/claims”``,
“authentication”: “genericCredentialType”,
“genericAuthType”: “oAuth2Api”,
“sendQuery”: true,
“queryParameters”: {
“parameters”: [
{
“name”: “externalRef”,
“value”: “={{ $json.orderId }}”
},
{
“name”: “externalRefType”,
“value”: “orderId”
}
]
},
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.3,
“position”: [
-288,
-112
],
“id”: “9a248d6d-39a6-42f4-8444-5a4aa7ce8eff”,
“name”: “HTTP Request → Claims3”,
“credentials”: {
“oAuth2Api”: {
“id”: “T6nDyfTfWTobxHUU”,
“name”: “claims credential”
}
}
},
{
“parameters”: {
“functionCode”: “return items.map(item => {\n const row = item.json;\n const tracking = row[‘Tracking Number’];\n const url = row[‘ORDER_OR_PARCEL_URL’];\n\n let orderId = null;\n if (url) {\n const match = url.match(/orders\/(\d+)\/detail/);\n if (match) orderId = match[1];\n }\n\n return {\n json: {\n orderId,\n trackingNumber: tracking,\n }\n };\n});”
},
“id”: “9ed94047-1bad-4cb0-9a7c-89341d2825d6”,
“name”: “Extract OrderId & Tracking3”,
“type”: “n8n-nodes-base.function”,
“typeVersion”: 1,
“position”: [
208,
1248
]
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“name”: “proofs”,
“value”: “={{ $json.proofs }}”,
“type”: “array”,
“id”: “b2fb8008-4d27-4aed-aeef-2df6f8acde66”
},
{
“name”: “externalRef”,
“value”: “={{ $json.externalRef }}”,
“type”: “string”,
“id”: “3d31f571-0649-4bc7-95bd-4f755ebb7823”
},
{
“name”: “trackingId”,
“value”: “={{ $(‘Extract OrderId & Tracking3’).item.json.trackingNumber }}”,
“type”: “string”,
“id”: “167c408f-efe5-4db7-a58c-be3198f1692f”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
-96,
704
],
“id”: “1039a268-b01b-466e-8fdf-0748442339bb”,
“name”: “Edit Fields (keep proofs + tracking)3”
},
{
“parameters”: {
“method”: “POST”,
“url”: “``https://upload.deliverr.com/v1/upload/download/claim”``,
“authentication”: “genericCredentialType”,
“genericAuthType”: “oAuth2Api”,
“sendBody”: true,
“bodyParameters”: {
“parameters”: [
{
“name”: “key”,
“value”: “={{ $json.proofs.url }}”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.3,
“position”: [
688,
624
],
“id”: “2d6b01ae-9edf-46a5-a6eb-7e8f11e87d6d”,
“name”: “HTTP Request → S3 download3”,
“alwaysOutputData”: true,
“retryOnFail”: true,
“waitBetweenTries”: 5000,
“credentials”: {
“oAuth2Api”: {
“id”: “T6nDyfTfWTobxHUU”,
“name”: “claims credential”
}
},
“onError”: “continueRegularOutput”
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“id”: “da1fffc3-3467-480d-a5c2-92a8ffacf74c”,
“name”: “trackingNumber”,
“value”: “={{ $(‘Split Out proofs3’).item.json.trackingId }}”,
“type”: “string”
},
{
“id”: “063e30fc-6b0a-41f0-95a8-3e6beddb8cd6”,
“name”: “externalRef”,
“value”: “={{ $(‘Split Out proofs3’).item.json.externalRef }}”,
“type”: “string”
},
{
“id”: “48920255-0712-4208-a567-d712f3f486ab”,
“name”: “proofType”,
“value”: “={{ $(‘Split Out proofs3’).item.json.proofs.name === “Proof of Customer Communication” ? “POD” : $(‘Split Out proofs3’).item.json.proofs.name === “Proof of Customer Invoice” ? “POC” :\n ($(‘Split Out proofs3’).item.json.proofs.name === “Proof of Wholesale Cost” ? “POC” : $item.json.proofs.name) }}”,
“type”: “string”
},
{
“id”: “e93a3980-3557-47bf-bc5f-8c919b38b999”,
“name”: “data”,
“value”: “={{ $json.data }}”,
“type”: “string”
},
{
“id”: “f264430f-cfaf-4d6a-8358-75aebb8f69fd”,
“name”: “mimeType”,
“value”: “={{ $json.data.match(/\.pdf(\?|$)/) ? ‘pdf’ : ‘png’ }}”,
“type”: “string”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
1104,
640
],
“id”: “8b44b64b-5cd2-4aec-a804-7e275ea25e47”,
“name”: “Edit Fields3”
},
{
“parameters”: {
“assignments”: {
“assignments”: [
{
“name”: “filename”,
“value”: “={{ $json.trackingNumber + ‘_’ + $json.proofType + ($data.mimeType === ‘pdf’ ? ‘.pdf’ : ‘.png’) }}”,
“type”: “string”,
“id”: “9ca9d150-c6e0-46be-aae5-1163fe2872e7”
},
{
“id”: “285c65a3-f5fd-4fc2-8ece-79b9e55fa6cf”,
“name”: “s3Url”,
“value”: “={{ $json.data }}”,
“type”: “string”
}
]
},
“options”: {}
},
“type”: “n8n-nodes-base.set”,
“typeVersion”: 3.4,
“position”: [
1280,
672
],
“id”: “272dd97a-0a8a-4cbc-a102-47a3775b2578”,
“name”: “Create Filename3”
},
{
“parameters”: {
“url”: “={{$json[“s3Url”]}}”,
“options”: {}
},
“id”: “430e0a39-eeba-4406-b021-645922c3b9a2”,
“name”: “HTTP Request (Download File)3”,
“type”: “n8n-nodes-base.httpRequest”,
“position”: [
1328,
912
],
“typeVersion”: 4.3
},
{
“parameters”: {
“authentication”: “serviceAccount”,
“name”: “={{ $json.filename }}”,
“driveId”: {
“__rl”: true,
“value”: “0AFrhZ_XhPTStUk9PVA”,
“mode”: “list”,
“cachedResultName”: “Insurance”,
“cachedResultUrl”: “``https://drive.google.com/drive/folders/…….sdcsvf”
},
“folderId”: {
“__rl”: true,
“value”: “={{ $(‘Create Folder3’).item.json.id }}”,
“mode”: “id”
},
“options”: {}
},
“id”: “09d2226d-4203-4fe4-8e54-5a9e8291280e”,
“name”: “Upload to Google Drive3”,
“type”: “n8n-nodes-base.googleDrive”,
“position”: [
1344,
1168
],
“typeVersion”: 3,
“retryOnFail”: true,
“waitBetweenTries”: 5000,
“alwaysOutputData”: true,
“credentials”: {
“googleApi”: {
“id”: “4vuNC6LlRuero6WA”,
“name”: “Claim Ops Service Account”
}
},
“onError”: “continueRegularOutput”
},
{
“parameters”: {
“fieldToSplitOut”: “proofs”,
“include”: “selectedOtherFields”,
“fieldsToInclude”: “externalRef, trackingId”,
“options”: {}
},
“type”: “n8n-nodes-base.splitOut”,
“typeVersion”: 1,
“position”: [
192,
672
],
“id”: “d47455ed-32ac-4e90-baaa-afeb351b3a02”,
“name”: “Split Out proofs3”
},
{
“parameters”: {
“aggregate”: “aggregateAllItemData”,
“options”: {}
},
“type”: “n8n-nodes-base.aggregate”,
“typeVersion”: 1,
“position”: [
-1664,
1056
],
“id”: “a9999d01-f1a6-4a8e-84bc-40a014d461e9”,
“name”: “Aggregate3”
},
{
“parameters”: {
“authentication”: “serviceAccount”,
“resource”: “folder”,
“name”: “={{ new Date().toLocaleDateString(‘en-US’, { month: ‘2-digit’, day: ‘2-digit’ }).replace(‘/’, ‘.’) + ’ Claims Submissions’ }}”,
“driveId”: {
“__rl”: true,
“value”: “0AIyN9RcFzsHWscdcUk9PVA”,
“mode”: “list”,
“cachedResultName”: “claim drive”,
“cachedResultUrl”: “``https://drive.google.com/drive/folders/0AIy…….FzsHWUk9PVA”
},
“folderId”: {
“__rl”: true,
“value”: “1J4JDNq8McNHKH8yaBcI1es63BOn0cjUP”,
“mode”: “list”,
“cachedResultName”: “temp fOLDER”,
“cachedResultUrl”: “``https://drive.google.com/drive/folders/1J4JD…``..”
},
“options”: {
“simplifyOutput”: false
}
},
“id”: “61d3931e-8a0e-426a-a88a-1f1cfc25299b”,
“name”: “Create Folder3”,
“type”: “n8n-nodes-base.googleDrive”,
“typeVersion”: 3,
“position”: [
-1168,
944
],
“credentials”: {
“googleApi”: {
“id”: “4vuNC6LlRuero6WA”,
“name”: “Claim Ops Service Account”
}
}
},
{
“parameters”: {
“options”: {
“sheetName”: “DHL.Parcel.Ground - Batch Submissions”
}
},
“id”: “2ba43bbf-adec-4e81-aa73-26814166b5cd”,
“name”: “Read DHL Tab”,
“type”: “n8n-nodes-base.spreadsheetFile”,
“typeVersion”: 1,
“position”: [
-1968,
1056
]
},
{
“parameters”: {},
“type”: “n8n-nodes-base.limit”,
“typeVersion”: 1,
“position”: [
-1424,
944
],
“id”: “b9c0b047-592d-4c25-8711-a26cbf5f5966”,
“name”: “Limit”
}
],
“connections”: {
“When clicking ‘Execute workflow’”: {
“main”: [
[
{
“node”: “Download Google Sheet3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Download Google Sheet3”: {
“main”: [
[
{
“node”: “Read DHL Tab”,
“type”: “main”,
“index”: 0
}
]
]
},
“Pick Required Columns3”: {
“main”: [
[
{
“node”: “Split In Batches3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Split In Batches3”: {
“main”: [
[
{
“node”: “Extract OrderId & Tracking3”,
“type”: “main”,
“index”: 0
}
]
]
},
“HTTP Request → Claims3”: {
“main”: [
[
{
“node”: “Edit Fields (keep proofs + tracking)3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Extract OrderId & Tracking3”: {
“main”: [
[
{
“node”: “HTTP Request → Claims3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Edit Fields (keep proofs + tracking)3”: {
“main”: [
[
{
“node”: “Split Out proofs3”,
“type”: “main”,
“index”: 0
}
]
]
},
“HTTP Request → S3 download3”: {
“main”: [
[
{
“node”: “Edit Fields3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Edit Fields3”: {
“main”: [
[
{
“node”: “Create Filename3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Create Filename3”: {
“main”: [
[
{
“node”: “HTTP Request (Download File)3”,
“type”: “main”,
“index”: 0
}
]
]
},
“HTTP Request (Download File)3”: {
“main”: [
[
{
“node”: “Upload to Google Drive3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Split Out proofs3”: {
“main”: [
[
{
“node”: “HTTP Request → S3 download3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Aggregate3”: {
“main”: [
[
{
“node”: “Limit”,
“type”: “main”,
“index”: 0
}
]
]
},
“Create Folder3”: {
“main”: [
[
{
“node”: “Pick Required Columns3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Read DHL Tab”: {
“main”: [
[
{
“node”: “Aggregate3”,
“type”: “main”,
“index”: 0
}
]
]
},
“Limit”: {
“main”: [
[
{
“node”: “Create Folder3”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“instanceId”: “d62df5f1be329f41019ddca7d9533612d63b0c0d16c5b7dc9bd02d1080b44f3d”
}
}
output returned by the last node
-
`Split Out proofs3`: 3 items (correct)
-
`HTTP Request (Download File)3`: 3 items (correct)
-
`Upload to Google Drive3`: 3 items shown, but 9 files actually uploaded to drive
Observed behavior:
-
When uploading to Shared Drive A (ID: `0PTStUk9PVA…..`): Files upload 3x (3 proofs become 9 files)
-
When uploading to Shared Drive B: Works correctly (3 proofs = 3 files)
Steps to reproduce:
1. Process 1 order with 3 proofs
2. Split proofs into individual items (3 items)
3. Upload each to specific Shared Drive folder
4. Expected: 3 files uploaded
5. Actual: 9 files uploaded (each file 3 times)