This workflow follows the Google Sheets → HTTP Request 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 →
{
"active": true,
"activeVersion": {
"updatedAt": "2025-12-03T05:38:17.884Z",
"createdAt": "2025-12-03T05:38:17.884Z",
"versionId": "779dd76d-d6a0-425c-a61d-9b3ec9e3435f",
"workflowId": "AH0rdp23A5bNlc6a",
"nodes": [
{
"parameters": {},
"id": "3930d9ed-7e2c-4ca6-9b55-5fe07706a9ea",
"name": "When clicking \"Execute Workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
1760,
840
]
},
{
"parameters": {
"jsCode": "return(\n [\n {\n \"headers\": {\n \"host\": \"n8n.makees.online\",\n \"user-agent\": \"axios/1.6.7\",\n \"content-length\": \"178\",\n \"accept\": \"application/json,text/html,application/xhtml+xml,application/xml,text/*;q=0.9, image/*;q=0.8, */*;q=0.7\",\n \"accept-encoding\": \"gzip, compress, deflate, br\",\n \"content-type\": \"application/json\",\n \"x-forwarded-for\": \"172.18.0.1\",\n \"x-forwarded-host\": \"n8n.makees.online\",\n \"x-forwarded-port\": \"443\",\n \"x-forwarded-proto\": \"https\",\n \"x-forwarded-server\": \"7b1b178c0c6a\",\n \"x-real-ip\": \"172.18.0.1\"\n },\n \"params\": {},\n \"query\": {},\n \"body\": {\n \"processID\": \"ZsForAnn\",\n \"check_tableID\": \"1ZBRfaqM4JgTKR-VwZ-Xz3BP-6SMRUUap0xTPmfyxqvw\",\n \"check_pageID\": \"1229911020\",\n \"url_become\": \"https://n8n.makees.online/webhook-waiting/297714\"\n },\n \"webhookUrl\": \"https://n8n.makees.online/webhook/deep_TC\",\n \"executionMode\": \"production\"\n }\n]\n);"
},
"id": "17e8d895-439a-4b04-9693-072e860371a7",
"name": "Code",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2220,
500
],
"disabled": true
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"number": [
{
"name": "row_number",
"value": "={{ $json.row_number }}"
}
],
"string": [
{
"name": "\u0442\u0440\u0435\u043a",
"value": "={{ $json.\u0442\u0440\u0435\u043a }}"
},
{
"name": "\u0438\u043d\u0434\u0435\u043a\u0441",
"value": "={{ $json.\u0418\u043d\u0434\u0435\u043a\u0441 }}"
}
]
},
"options": {
"dotNotation": false
}
},
"id": "abd28709-3bcd-42cc-b255-1ec9b1fad71b",
"name": "\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u0430",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
3940,
-500
],
"executeOnce": false
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"number": [
{
"name": "row_number",
"value": "={{ $json.row_number }}"
}
],
"string": [
{
"name": "\u0442\u0440\u0435\u043a",
"value": "={{ $json.\u0442\u0440\u0435\u043a }}"
},
{
"name": "\u0438\u043d\u0434\u0435\u043a\u0441",
"value": "={{ $json.\u0418\u043d\u0434\u0435\u043a\u0441 }}"
}
]
},
"options": {
"dotNotation": false
}
},
"id": "8ab5d77a-5442-481b-aa19-c2092ddaa690",
"name": "\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u04301",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
4220,
220
],
"executeOnce": false
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "={{ $('\u0417\u0430\u043d\u043e\u0432\u043e \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b').first().json.\u0422\u0430\u0431\u043b\u0438\u0446\u0430 }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $('\u0417\u0430\u043d\u043e\u0432\u043e \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b').first().json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}",
"mode": "id"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"\u0414\u0430\u0442\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f": "=\u043d\u0435\u0442 \u0442\u0440\u0435\u043a\u0430 {{ $now.toISO().slice(0,19) }} ",
"\u0418\u043d\u0434\u0435\u043a\u0441": "={{ $json.\u0418\u043d\u0434\u0435\u043a\u0441 }}"
},
"matchingColumns": [
"\u0418\u043d\u0434\u0435\u043a\u0441"
],
"schema": [
{
"id": "\u0410",
"displayName": "\u0410",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0426\u0435\u043d\u0430 \u0418\u041f",
"displayName": "\u0426\u0435\u043d\u0430 \u0418\u041f",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0442\u0440\u0435\u043a",
"displayName": "\u0442\u0440\u0435\u043a",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0415\u041f",
"displayName": "\u0415\u041f",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0412\u0420\u0423\u0427\u0415\u041d\u041e/\u041d\u0415\u0412\u041e\u0421\u0422\u0420\u0415\u0411",
"displayName": "\u0412\u0420\u0423\u0427\u0415\u041d\u041e/\u041d\u0415\u0412\u041e\u0421\u0422\u0420\u0415\u0411",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u041e\u0442\u043c\u0435\u0442\u043a\u0430 \u043e \u0434\u043e\u0441\u0442\u0430\u0432\u043a\u0435",
"displayName": "\u041e\u0442\u043c\u0435\u0442\u043a\u0430 \u043e \u0434\u043e\u0441\u0442\u0430\u0432\u043a\u0435",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0418\u043d\u0434\u0435\u043a\u0441",
"displayName": "\u0418\u043d\u0434\u0435\u043a\u0441",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "\u0414\u0430\u0442\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f",
"displayName": "\u0414\u0430\u0442\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441",
"displayName": "\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
}
]
},
"options": {}
},
"id": "cfd79ef8-b18f-4a5c-8db9-fbf0790c810e",
"name": "\u0411\u0435\u0437 \u0442\u0440\u0435\u043a\u043d\u043e\u043c\u0435\u0440\u0430",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
3640,
860
],
"retryOnFail": true,
"waitBetweenTries": 3000,
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GsKpjBhTzM4aUjza",
"name": "Google Sheets account"
}
},
"onError": "continueRegularOutput"
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"number": [
{
"name": "=page",
"value": "={{ $('\u0417\u0430\u043d\u043e\u0432\u043e \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b').item.json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}"
}
],
"string": [
{
"name": "table",
"value": "={{ $('\u0417\u0430\u043d\u043e\u0432\u043e \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b').item.json.\u0422\u0430\u0431\u043b\u0438\u0446\u0430 }}"
}
]
},
"options": {
"dotNotation": false
}
},
"id": "bb6da21e-1c82-41e3-9dc2-e1a5ffa3b680",
"name": "\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u04304",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
4220,
420
],
"executeOnce": true,
"alwaysOutputData": true,
"continueOnFail": true
},
{
"parameters": {
"mode": "combine",
"combinationMode": "multiplex",
"options": {}
},
"id": "e3133e3d-aa48-4e2c-be5a-bd7d9991895e",
"name": "Merge3",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
4420,
400
]
},
{
"parameters": {
"url": "={{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.url_become }}",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "TrackCollect",
"value": "OK"
}
]
},
"options": {}
},
"id": "dae6e9e6-366d-410b-9325-c8f43a4a3560",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
7220,
980
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.\u0442\u0440\u0435\u043a }}",
"operation": "isNotEmpty"
},
{
"value1": "={{ $json.\u0422\u0440\u0435\u043a }}",
"operation": "isNotEmpty"
}
]
},
"combineOperation": "any"
},
"id": "c3a533d4-70ba-4020-be0e-6cd0ef2c065c",
"name": "\u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0435\u0441\u0442\u044c \u043b\u0438 \u0442\u0440\u0435\u043a",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
3040,
280
],
"alwaysOutputData": false
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"string": [
{
"name": "\u0422\u0430\u0431\u043b\u0438\u0446\u0430",
"value": "={{ $json.body.check_tableID }}"
},
{
"name": "\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430",
"value": "={{ $json.body.check_pageID }}"
},
{
"name": "processID",
"value": "={{ $json.body.processID }}"
},
{
"name": "url_become",
"value": "={{ $json.body.url_become }}"
}
]
},
"options": {
"dotNotation": false
}
},
"id": "fc138084-31f5-4d92-8ed2-89046a5b83d3",
"name": "\u0417\u0430\u043d\u043e\u0432\u043e \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
2240,
260
],
"executeOnce": false,
"alwaysOutputData": false
},
{
"parameters": {
"content": "# \u0421\u043e\u0431\u0438\u0440\u0430\u0435\u043c \u0442\u0440\u0435\u043a\u0438 \u0431\u0435\u043b\u043f\u043e\u0447\u0442\u044b",
"height": 130.52426395939085,
"width": 513.295596447602,
"color": 5
},
"id": "ab852b07-8f35-4e60-8bfc-54515dec66e2",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
3560,
-740
]
},
{
"parameters": {
"content": "# \u0421\u043e\u0431\u0438\u0440\u0430\u0435\u043c \u0442\u0440\u0435\u043a\u0438 \u0435\u0432\u0440\u043e\u043f\u043e\u0447\u0442\u044b\n",
"height": 142.94857142857143,
"width": 529.1848753108349
},
"id": "6f6af8f3-8981-4484-b79a-bf9f2a22f621",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
3800,
-40
]
},
{
"parameters": {
"content": "# \u0412\u044b\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c \u043e\u0442\u043c\u0435\u0442\u043a\u0443 \u043e\u0431 \u043e\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0438\u0438 \u0442\u0440\u0435\u043a \u043d\u043e\u043c\u0435\u0440\u0430, \u0435\u0441\u043b\u0438 \u0432\u043c\u0441\u0435\u0441\u0442\u043e \u0442\u0440\u0435\u043a\u0430 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0447\u0442\u043e \u0442\u043e \u0434\u0440\u0443\u0433\u043e\u0435",
"height": 133.9370246058483,
"width": 939.2971497794813
},
"id": "6573ffea-db13-44e4-be30-960d167d7f6b",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
3780,
800
]
},
{
"parameters": {
"content": "\u0422\u0430\u0439\u043c\u0435\u0440 20 \u0441\u0435\u043a\nhttps://n8n.makees.site/workflow/73",
"height": 80,
"width": 284.43425442385546
},
"id": "6627ebd5-464a-4e16-926e-53ac0e6978fa",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
2100,
-120
]
},
{
"parameters": {},
"id": "c2831636-806e-4447-85a2-aa544412dd74",
"name": "No Operation, do nothing14",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
3780,
-400
]
},
{
"parameters": {},
"id": "ca9a5767-04ab-4b4a-9ccc-6175ebd4a3ab",
"name": "No Operation, do nothing16",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
4040,
320
]
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.data.TrigerBP }}",
"operation": "equal",
"value2": 1
},
{
"value1": "={{ $json.data.TrigerEP }}",
"operation": "equal",
"value2": 1
},
{
"value1": "={{ $json.data.TrigerNT }}",
"operation": "equal",
"value2": 1
}
]
}
},
"id": "a0c209f7-9eaa-4e8c-a3ad-2a6ab34ae81c",
"name": "\u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0442\u0440\u0435\u043a\u043d\u043e\u043c\u0435\u0440 \u043d\u0430 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u0448\u0430\u0431\u043b\u043e\u043d\u0443 \u0435\u0432\u0440\u043e\u043f\u043e\u0447\u0442\u04301",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
6400,
1000
],
"alwaysOutputData": false
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "process.trigers",
"sourceType": "sourceTypeJson",
"sourceData": "{ \"TrigerNT\": 1, \"TrigerBP\": 1, \"TrigerEP\": 1 }",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "e6c3ee99-9cd5-4651-bb6c-08447aff977f",
"name": "JsonDatabase",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
2620,
-160
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "67982f73-5a2a-4cd2-9cdd-3500216ab801",
"name": "\u0421\u0417\u041f\u04261",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
2660,
40
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "d86d6c93-3701-43ab-9a56-6562b19fd81b",
"name": "YGP",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
2940,
-160
],
"alwaysOutputData": false
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "c4b08fe4-6ca3-43e8-a6ce-1e0d062d990b",
"name": "YGP1",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
5200,
-660
],
"alwaysOutputData": false
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "80984c4a-57a8-4cb7-9e56-3568233e1fc1",
"name": "\u0421\u0417\u041f\u04262",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
3640,
-660
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"number": [
{
"name": "=page",
"value": "={{ $('\u0417\u0430\u043d\u043e\u0432\u043e \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b').item.json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}"
}
],
"string": [
{
"name": "table",
"value": "={{ $('\u0417\u0430\u043d\u043e\u0432\u043e \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b').item.json.\u0422\u0430\u0431\u043b\u0438\u0446\u0430 }}"
}
]
},
"options": {
"dotNotation": false
}
},
"id": "75f58425-3642-4b26-b72f-c997bb52552e",
"name": "\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u04303",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
3940,
-300
],
"executeOnce": true,
"alwaysOutputData": false
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "b897cbfe-0253-46af-9445-1713c2230abf",
"name": "\u0421\u0417\u041f\u04263",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
5280,
-480
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "process.trigers.TrigerBP",
"sourceType": "sourceTypeJson",
"sourceData": "0",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "10380145-be5b-4722-a926-1030e5b640d1",
"name": "\u041c\u0435\u043d\u044f\u0435\u043c BP_triger \u043d\u0430 1",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
4380,
-660
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "313c09b9-4872-47d7-a730-c1d397604957",
"name": "\u0421\u0417\u041f\u04264",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
4120,
-500
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"queryPath": "traks.BP_traks",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "8272b5b5-e38f-471e-96e1-07b4a067f754",
"name": "\u041f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u043e\u0431\u0440\u0430\u043d\u043d\u044b\u0435 \u0442\u0440\u0435\u043a\u0438 BP \u0438\u0437 JSON",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
4360,
-500
]
},
{
"parameters": {
"fieldToSplitOut": "data",
"options": {}
},
"id": "62201034-013a-4971-90d4-0c161cf0f891",
"name": "\u0420\u0430\u0441\u043f\u0430\u043a\u043e\u0432\u044b\u0432\u0430\u0435\u043c \u043c\u0430\u0441\u0441\u0438\u0432 \u0441 \u0442\u0440\u0435\u043a\u0430\u043c\u0438",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3,
"position": [
4560,
-500
],
"alwaysOutputData": true
},
{
"parameters": {
"mode": "combine",
"combinationMode": "multiplex",
"options": {}
},
"id": "8a3ddba8-7792-4ccf-8272-6b1e1064d727",
"name": "\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a/\u0438\u043d\u0434\u0435\u043a\u0441 \u0441 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430\u043c\u0438 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
4140,
-320
]
},
{
"parameters": {},
"id": "83604c98-6d72-4b64-91e4-f4fa5288a406",
"name": "\u0421\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0438\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0442\u0440\u0435\u043a\u0438 \u0441 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c\u0438",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
4380,
-300
]
},
{
"parameters": {
"operation": "concatenateItems",
"aggregate": "aggregateAllItemData",
"options": {}
},
"id": "5ba67a29-4c0d-4227-bc42-79c88c47f85b",
"name": "\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0432\u0441\u0435 \u0442\u0440\u0435\u043a\u0438 \u0432 \u043e\u0434\u0438\u043d \u043c\u0430\u0441\u0441\u0438\u0432",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3,
"position": [
4760,
-300
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "traks.BP_traks",
"sourceType": "sourceTypeJson",
"sourceData": "={{ JSON.stringify($input.item.json.data) }}",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "1ba356eb-fc1b-42f0-a325-8f742c87e7e8",
"name": "\u041e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 BP_tracks",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
5180,
-300
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "00ca7035-e754-4996-9fb8-f8754074e821",
"name": "\u0421\u0417\u041f\u04265",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
3900,
40
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "de9394fd-e563-430e-8210-ff114b9308bb",
"name": "YGP2",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
5040,
40
],
"alwaysOutputData": false
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "bc484eea-37a1-4b9d-acc2-2aeac7b9e606",
"name": "\u0421\u0417\u041f\u04266",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
4420,
220
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"queryPath": "traks.EP_traks",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "21c4db53-7131-43e2-8c45-b0bc7b28868a",
"name": "\u041f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u043e\u0431\u0440\u0430\u043d\u043d\u044b\u0435 \u0442\u0440\u0435\u043a\u0438 BP \u0438\u0437 JSON1",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
4600,
220
]
},
{
"parameters": {
"fieldToSplitOut": "data",
"options": {}
},
"id": "ff6977ad-8b74-4cf0-8956-7e7444c0ffe5",
"name": "\u0420\u0430\u0441\u043f\u0430\u043a\u043e\u0432\u044b\u0432\u0430\u0435\u043c \u043c\u0430\u0441\u0441\u0438\u0432 \u0441 \u0442\u0440\u0435\u043a\u0430\u043c\u04381",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3,
"position": [
4800,
220
],
"alwaysOutputData": true
},
{
"parameters": {},
"id": "4bf13bf1-5d5b-4007-9382-fd3f25f327c4",
"name": "\u0421\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0438\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0442\u0440\u0435\u043a\u0438 \u0441 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c\u04381",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
4600,
420
]
},
{
"parameters": {
"operation": "concatenateItems",
"aggregate": "aggregateAllItemData",
"options": {}
},
"id": "7b3fe56f-850b-4d79-87f2-16b96b19f429",
"name": "\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0432\u0441\u0435 \u0442\u0440\u0435\u043a\u0438 \u0432 \u043e\u0434\u0438\u043d \u043c\u0430\u0441\u0441\u0438\u04321",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3,
"position": [
4800,
420
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "traks.EP_traks",
"sourceType": "sourceTypeJson",
"sourceData": "={{ JSON.stringify($input.item.json.data) }}",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "576faf13-b54c-42d7-8ffb-91a0f84b7f27",
"name": "\u041e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 BP_tracks1",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
5020,
420
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "1182a185-4cb0-4a51-b1db-249f28f733d9",
"name": "\u0421\u0417\u041f\u04267",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
5100,
220
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "d78b985e-9567-4cc1-a1f8-160d162023e0",
"name": "YGP3",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
5520,
220
],
"alwaysOutputData": false
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "61ce580a-8757-452e-b183-906f261e152e",
"name": "\u0421\u0417\u041f\u04268",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
5600,
1000
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"queryPath": "process.trigers",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "1700c4b8-2c0f-4ded-8fe0-a46b4a6d79ad",
"name": "JsonDatabase2",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
6060,
1000
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "84333435-2d0c-4287-a93e-6a21a519c8de",
"name": "\u0421\u0417\u041f\u04269",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
4760,
640
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {},
"id": "da0db3e5-0569-43ac-bd20-97999959d047",
"name": "No Operation, do nothing1",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
5540,
760
]
},
{
"parameters": {},
"id": "7f34172c-9bf1-45d3-bab0-59b2e55a5667",
"name": "\u0422\u0440\u0435\u043a\u0438 \u0411\u0435\u043b\u043f\u043e\u0447\u0442\u044b",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
3540,
-420
]
},
{
"parameters": {},
"id": "dafa8797-9a04-4baa-84e5-056906051307",
"name": "\u0422\u0440\u0435\u043a\u0438 \u0415\u0432\u0440\u043e\u043f\u043e\u0447\u0442\u044b",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
3840,
220
]
},
{
"parameters": {},
"id": "71aed66e-f22b-4f11-8ca1-4b39771f3b67",
"name": "\u041d\u0435 \u0442\u0440\u0435\u043a\u0438 \u0432 \u0442\u0440\u0435\u043a\u0435",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
3560,
660
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "9a3525ec-5a72-4c91-9c21-e916c1d5deaf",
"name": "\u0441\u0431\u0440\u043e\u0441 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u043f\u043e\u0441\u043b\u0435 \u0446\u0438\u043a\u043b\u0430",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
6680,
980
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "550ba713-4a42-4cdd-acec-e1ade52da0ff",
"name": "\u0421\u0417\u041f\u042611",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
3900,
660
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "ddffb41e-a217-428a-83cd-8156dfae44bc",
"name": "YGP4",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
4360,
660
],
"alwaysOutputData": false
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "71704de8-3744-4abc-af67-3c9cda915469",
"name": "YGP5",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
5540,
420
],
"alwaysOutputData": false
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "4277b705-ada5-44bc-b9e6-4bcbb743b0ea",
"name": "YGP8",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
5520,
20
],
"alwaysOutputData": false
},
{
"parameters": {},
"id": "762a4c90-faab-49af-a981-326933d74d24",
"name": "No Operation, do nothing",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
4720,
860
]
},
{
"parameters": {},
"id": "38b9c136-dab4-4a1c-8fc2-03db14a3b542",
"name": "No Operation, do nothing2",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
5240,
640
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "process.trigers.TrigerBP",
"sourceType": "sourceTypeJson",
"sourceData": "1",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "18ab1f6b-98e0-474f-8a71-569e1350d007",
"name": "\u041c\u0435\u043d\u044f\u0435\u043c BP_triger \u043d\u0430 6",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
5340,
20
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "process.trigers.TrigerEP",
"sourceType": "sourceTypeJson",
"sourceData": "1",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "76d7c18d-0d76-4592-8d3b-65ebf14c507c",
"name": "\u041c\u0435\u043d\u044f\u0435\u043c EP_triger \u043d\u0430 1",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
5340,
220
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "process.trigers.TrigerNT",
"sourceType": "sourceTypeJson",
"sourceData": "1",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "e58efa00-52ae-4c73-bf16-9fb180da0dde",
"name": "\u041c\u0435\u043d\u044f\u0435\u043c NT_triger \u043d\u0430 5",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
5340,
420
]
},
{
"parameters": {
"options": {
"dotNotation": false
}
},
"id": "53fe33d9-8deb-489a-a9df-f9bf93978a21",
"name": "\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
2420,
260
],
"executeOnce": false,
"alwaysOutputData": false
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "process.trigers.TrigerNT",
"sourceType": "sourceTypeJson",
"sourceData": "0",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "582b8ce6-2ad5-407f-aced-f02e7bfd3490",
"name": "\u041c\u0435\u043d\u044f\u0435\u043c NT_triger \u043d\u0430 0",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
4080,
660
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "process.trigers.TrigerEP",
"sourceType": "sourceTypeJson",
"sourceData": "0",
"filePath": "=root/n8n/{{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').first().json.processID }}.json"
},
"id": "2c50774f-856d-4e61-81cd-8e89fa0642a5",
"name": "\u041c\u0435\u043d\u044f\u0435\u043c EP_triger \u043d\u0430 0",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
4600,
40
]
},
{
"parameters": {
"url": "={{ $('main JSON').first().json.data.endPoints.\u0422\u0430\u0439\u043c\u0435\u0440 }}",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "timer",
"value": "10"
}
]
},
"options": {}
},
"id": "e9c184b7-66e3-41c8-9ed5-30d39fc431b8",
"name": "\u0422\u0430\u0439\u043c\u0435\u0440 10 \u0441\u0435\u043a",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
6380,
1240
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "7861b89a-2204-4b67-8953-f83994be6673",
"name": "\u0421\u0417\u041f\u0426",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
2940,
1020
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"amount": 15,
"unit": "seconds"
},
"id": "10d7cb97-a16a-4d8e-bd8c-08815977e330",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
6900,
980
],
"webhookId": "574d48bc-31e8-4c6b-bdae-f92588583f37"
},
{
"parameters": {
"filePath": "=root/n8n/main.json"
},
"id": "829a15a1-6329-4f7f-82a4-62f77f374b4d",
"name": "main JSON",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
2180,
60
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "3f08babf-340b-4d3a-a514-5641d5e64c36",
"name": "KED",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
2420,
60
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.\u0418\u043d\u0434\u0435\u043a\u0441 }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "d13b2582-3b1b-4936-9f1a-8e8098273b32",
"name": "IF",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
3240,
260
]
},
{
"parameters": {},
"id": "48d641ac-5ae4-478f-907d-c5547a4bcbc5",
"name": "\u043d\u0435\u0442 \u043d\u0438\u0447\u0435\u0433\u043e",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
5620,
1200
]
},
{
"parameters": {
"dataType": "string",
"value1": "={{ $json.\u0442\u0440\u0435\u043a }}",
"rules": {
"rules": [
{
"operation": "regex",
"value2": "[A-Z][A-Z][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]B|bY|y",
"outputKey": "0"
},
{
"operation": "regex",
"value2": "[A-Z][A-Z][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]",
"outputKey": "1"
},
{
"value2": "[empty]",
"outputKey": "2"
},
{
"operation": "notEqual",
"value2": "[empty]",
"outputKey": "3"
}
]
},
"fallbackOutput": 3
},
"id": "43e2d177-fd2a-4374-aa08-1438716b3698",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"typeVersion": 2,
"position": [
3460,
220
]
},
{
"parameters": {},
"id": "5ceccb5c-b841-42ea-9c5b-c7cf8b004258",
"name": "No Operation, do nothing3",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
7260,
1360
],
"disabled": true
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "={{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').item.json['\u0422\u0430\u0431\u043b\u0438\u0446\u0430'] }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').item.json['\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430'] }}",
"mode": "id"
},
"filtersUI": {
"values": [
{
"lookupColumn": "\u041e\u0442\u043c\u0435\u0442\u043a\u0430 \u043e \u0434\u043e\u0441\u0442\u0430\u0432\u043a\u0435",
"lookupValue": "\u041d\u0435 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e"
}
]
},
"options": {
"returnAllMatches": "returnAllMatches"
}
},
"id": "9eba9e32-9a43-4e2d-a885-20064af32b0b",
"name": "\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u0441 \u043e\u0442\u043c\u0435\u0442\u043a\u043e\u0443 \u043d\u0435 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
2680,
260
],
"alwaysOutputData": false,
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GsKpjBhTzM4aUjza",
"name": "Google Sheets account"
}
},
"onError": "continueErrorOutput"
},
{
"parameters": {
"amount": 10.11
},
"id": "230dfd7a-4c22-4fa8-a7b2-8d64e68964c9",
"name": "Wait1",
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
2760,
1380
],
"webhookId": "e099626e-82f9-4dfb-a14c-f3b70b402852"
},
{
"parameters": {
"jsCode": "return(\n [\n {\n \"headers\": {\n \"host\": \"n8n.makeesn8n.online\",\n \"user-agent\": \"axios/1.7.4\",\n \"content-length\": \"181\",\n \"accept\": \"application/json,text/html,application/xhtml+xml,application/xml,text/*;q=0.9, image/*;q=0.8, */*;q=0.7\",\n \"accept-encoding\": \"gzip, compress, deflate, br\",\n \"content-type\": \"application/json\",\n \"x-forwarded-for\": \"172.19.0.1\",\n \"x-forwarded-host\": \"n8n.makeesn8n.online\",\n \"x-forwarded-port\": \"443\",\n \"x-forwarded-proto\": \"https\",\n \"x-forwarded-server\": \"1f3353e3b88e\",\n \"x-real-ip\": \"172.19.0.1\"\n },\n \"params\": {},\n \"query\": {},\n \"body\": {\n \"processID\": \"zsForHel\",\n \"check_tableID\": \"10Vubjm_1wRx_LAaDWlYsZkYrJaBZsPF9yetpplv01kQ\",\n \"check_pageID\": \"692697150\",\n \"url_become\": \"https://n8n.makeesn8n.online/webhook-waiting/487553\"\n },\n \"webhookUrl\": \"https://n8n.makeesn8n.online/webhook/deep_TC\",\n \"executionMode\": \"production\"\n }\n]\n);"
},
"id": "7cfba37c-5dd5-4e49-ae0e-5140be6db40e",
"name": "Code1",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2240,
720
],
"disabled": true
},
{
"parameters": {
"url": "={{ $('main JSON').first().json.data.endPoints['\u0427\u0430\u0442 \u0431\u043e\u0442 \u0442\u0435\u043b\u0435\u0433\u0438'] }}",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "=processID",
"value": "={{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').item.json.processID }}"
},
{
"name": "send",
"value": "=\u041f\u0440\u043e\u0446\u0435\u0441\u0441 trackCollectDiper \u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u0441 \u0442\u0430\u0431\u043b\u0438\u0446\u0435\u0439 {{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').item.json['\u0422\u0430\u0431\u043b\u0438\u0446\u0430'].slice(39) }} {{ $('\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430').item.json['\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430'] }}. \u0421\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043b\u043e\u0433\u0438 https://n8n.makeesn8n.online/workflow/AH0rdp23A5bNlc6a/executions/{{ $execution.id }}"
}
]
},
"options": {}
},
"id": "f691969e-714b-4cc9-b732-d5a3f0f20c84",
"name": "\u041e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 \u0432 \u0442\u0435\u043b\u0435\u0433\u0440\u0430\u043c\u043c6",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
7160,
1220
]
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "={{ $json.\u0422\u0430\u0431\u043b\u0438\u0446\u0430 }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}",
"mode": "id"
},
"filtersUI": {
"values": [
{
"lookupColumn": "\u041e\u0442\u043c\u0435\u0442\u043a\u0430 \u043e \u0434\u043e\u0441\u0442\u0430\u0432\u043a\u0435",
"lookupValue": "\u041d\u0435 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e"
}
]
},
"options": {
"returnAllMatches": "returnAllMatches"
}
},
"id": "05df4150-35f1-40ad-bd6a-3e92e8fd4a40",
"name": "\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u0441 \u043e\u0442\u043c\u0435\u0442\u043a\u043e\u0443 \u043d\u0435 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e1",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
2520,
660
],
"alwaysOutputData": true,
"retryOnFail": true,
"waitBetweenTries": 2000,
"executeOnce": true,
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GsKpjBhTzM4aUjza",
"name": "Google Sheets account"
}
},
"onError": "continueErrorOutput"
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.row_number }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "6416e947-7baa-4e4a-961f-b05195fced8f",
"name": "\u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0435\u0441\u0442\u044c \u043b\u0438 \u0442\u0440\u0435\u043a2",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
2520,
460
],
"alwaysOutputData": false
},
{
"parameters": {
"path": "deep_TC",
"options": {}
},
"id": "061dd92c-e878-4f16-a514-488961bb2802",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
1980,
260
],
"webhookId": "4267f6ac-16a7-4c28-b2bf-085ddf4c1e57"
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.row_number }}",
"operation": "isEmpty"
}
]
}
},
"id": "a79cc93c-d0ab-4750-9fcb-1271ca399485",
"name": "\u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u043f\u0443\u0441\u0442\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
2860,
420
],
"alwaysOutputData": false
},
{
"parameters": {
"jsCode": "return(\n[\n {\n \"headers\": {\n \"host\": \"n8n.makeesn8n.online\",\n \"user-agent\": \"axios/1.8.2\",\n \"content-length\": \"175\",\n \"accept\": \"application/json,text/html,application/xhtml+xml,application/xml,text/*;q=0.9, image/*;q=0.8, */*;q=0.7\",\n \"accept-encoding\": \"gzip, compress, deflate, br\",\n \"content-type\": \"application/json\",\n \"x-forwarded-for\": \"172.18.0.1\",\n \"x-forwarded-host\": \"n8n.makeesn8n.online\",\n \"x-forwarded-port\": \"443\",\n \"x-forwarded-proto\": \"https\",\n \"x-forwarded-server\": \"2031571a90c1\",\n \"x-real-ip\": \"172.18.0.1\"\n },\n \"params\": {},\n \"query\": {},\n \"body\": {\n \"processID\": \"ZsForAleks\",\n \"check_tableID\": \"1-VllDvtGVo2VV4OP0BI2qJLlJBo46ViWwUj5Ubq9kKc\",\n \"check_pageID\": \"0\",\n \"url_become\": \"https://n8n.makeesn8n.online/webhook-waiting/898832\"\n },\n \"webhookUrl\": \"https://n8n.makeesn8n.online/webhook/deep_TC\",\n \"executionMode\": \"production\"\n }\n]\n);"
},
"id": "fee82d30-ffa4-44a0-81a6-1d01bb384da0",
"name": "Code2",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2160,
980
],
"disabled": true
}
],
"connections": {
"When clicking \"Execute Workflow\"": {
"main": [
[
{
"node": "Code2",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "\u0417\u0430\u043d\u043e\u0432\u043e \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u0430": {
"main": [
[
{
"node": "\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a/\u0438\u043d\u0434\u0435\u043a\u0441 \u0441 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430\u043c\u0438 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b",
"type": "main",
"index": 0
},
{
"node": "\u0421\u0417\u041f\u04264",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u04304": {
"main": [
[
{
"node": "Merge3",
"type": "main",
"index": 1
}
]
]
},
"\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u04301": {
"main": [
[
{
"node": "Merge3",
"type": "main",
"index": 0
},
{
"node": "\u0421\u0417\u041f\u04266",
"type": "main",
"index": 0
}
]
]
},
"Merge3": {
"main": [
[
{
"node": "\u0421\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0438\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0442\u0440\u0435\u043a\u0438 \u0441 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c\u04381",
"type": "main",
"index": 0
}
]
]
},
"\u0411\u0435\u0437 \u0442\u0440\u0435\u043a\u043d\u043e\u043c\u0435\u0440\u0430": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"\u0
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.
googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow automatically retrieves order details, checks Google Sheets for existing tracking numbers, and uses HTTP requests to fetch or update shipment information when none is found. It suits e-commerce teams or logistics staff who need to keep tracking data consistent across systems without manual lookups. The key step is the conditional check against the spreadsheet that decides whether to enrich the record via an external API call.
Use it for recurring order batches where tracking data arrives late or needs verification. Skip it for one-off checks or when your tracking source changes daily. A common variation replaces the HTTP node with a different carrier endpoint while keeping the same Google Sheets lookup logic.
About this workflow
TrackCollect_deeper. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 80 nodes.
Source: https://github.com/makees-by/n8ns/blob/9ecc9ce03dd07ad3f21456f95d3ecba945139578/workflowTrackCollect_deeper.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.
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
This workflow allows to scrape Google Maps data in an efficient way using SerpAPI.
Google Sheets, HTTP Request, Item Lists
This workflow shows a low code approach to parsing an XML file and storing its contents in a Google Sheets spreadsheet.
HTTP Request, XML, Google Sheets +1
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
HTTP Request, Gmail, Twilio +3
The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet
Google Sheets, Google Drive, HTTP Request