This workflow follows the Google Drive → Google Sheets 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,
"connections": {
"Webhook": {
"main": [
[
{
"node": "\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430",
"type": "main",
"index": 0
}
]
]
},
"When clicking \"Execute Workflow\"": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Code1",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
},
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks",
"type": "main",
"index": 0
},
{
"node": "main JSON",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets2": {
"main": [
[
{
"node": "\u0423\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435 \u0441\u0442\u0440\u043e\u043a\u0438",
"type": "main",
"index": 0
}
]
]
},
"\u0423\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435 \u0441\u0442\u0440\u043e\u043a\u0438": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u042610",
"type": "main",
"index": 0
}
],
[
{
"node": "\u041f\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 \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": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u0426",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0442\u0440\u043e\u043a\u0438 \u0441 \u0442\u0440\u0435\u043a\u043e\u043c": {
"main": [
[
{
"node": "\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 \u0431\u0435\u043b\u043f\u043e1",
"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\u04305": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets3": {
"main": [
[
{
"node": "YGP7",
"type": "main",
"index": 0
}
]
]
},
"\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 \u0431\u0435\u043b\u043f\u043e1": {
"main": [
[
{
"node": "\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u04305",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u0426": {
"main": [
[
{
"node": "\u041f\u043e\u0433\u0440\u0443\u0436\u0430\u0435\u043c\u0441\u044f \u0433\u043b\u0443\u0431\u0436\u0435 \u0432 \u0441\u0431\u043e\u0440 \u0442\u0440\u0435\u043a\u043e\u0432",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u042610": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks2",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing13": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks1",
"type": "main",
"index": 0
}
]
]
},
"YGP6": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
},
"YGP7": {
"main": [
[]
]
},
"\u0416\u0434\u0443\u043d": {
"main": [
[
{
"node": "No Operation, do nothing13",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e\u0433\u0440\u0443\u0436\u0430\u0435\u043c\u0441\u044f \u0433\u043b\u0443\u0431\u0436\u0435 \u0432 \u0441\u0431\u043e\u0440 \u0442\u0440\u0435\u043a\u043e\u0432": {
"main": [
[
{
"node": "\u0416\u0434\u0443\u043d",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks1": {
"main": [
[
{
"node": "Convert to/from binary data",
"type": "main",
"index": 0
}
]
]
},
"Convert to/from binary data": {
"main": [
[
{
"node": "Google Drive",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks2": {
"main": [
[
{
"node": "Convert to/from binary data1",
"type": "main",
"index": 0
}
]
]
},
"Convert to/from binary data1": {
"main": [
[
{
"node": "Google Drive1",
"type": "main",
"index": 0
}
]
]
},
"Google Drive": {
"main": [
[
{
"node": "YGP6",
"type": "main",
"index": 0
}
]
]
},
"Google Drive1": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"main JSON": {
"main": [
[
{
"node": "KED",
"type": "main",
"index": 0
}
]
]
},
"KED": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
},
"Code1": {
"main": [
[
{
"node": "\u0421\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2023-11-29T07:05:50.659Z",
"id": "pwofnTe8IYGRQZrS",
"isArchived": false,
"meta": null,
"name": "TrackCollect",
"nodes": [
{
"parameters": {
"path": "modul_trackCollect",
"options": {}
},
"id": "0250a58b-26fc-4d49-8d72-3b9176ec164f",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
180,
300
]
},
{
"parameters": {},
"id": "f4057c71-4ceb-48df-b825-c359e175a12f",
"name": "When clicking \"Execute Workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
480,
560
]
},
{
"parameters": {
"jsCode": "return(\n [\n {\n \"headers\": {\n \"host\": \"n8ns.makees.site\",\n \"user-agent\": \"axios/0.21.4\",\n \"content-length\": \"167\",\n \"accept\": \"application/json,text/html,application/xhtml+xml,application/xml,text/*;q=0.9, image/*;q=0.8, */*;q=0.7\",\n \"content-type\": \"application/json\",\n \"x-forwarded-for\": \"172.18.0.1\",\n \"x-forwarded-host\": \"n8ns.makees.site\",\n \"x-forwarded-port\": \"443\",\n \"x-forwarded-proto\": \"https\",\n \"x-forwarded-server\": \"e8109027b64a\",\n \"x-real-ip\": \"172.18.0.1\",\n \"accept-encoding\": \"gzip\"\n },\n \"params\": {},\n \"query\": {},\n \"body\": {\n \"processID\": \"ZsTest\",\n \"main_tableID\": \"1E2_AUgkcpy0BrVZotmTyCH2Uy8ShDSkNZCpCddFwL-A\",\n \"main_pageID\": 1600679549,\n \"url_become\": \"https://n8ns.makees.site/webhook-waiting/23\"\n }\n }\n]\n);"
},
"id": "1a1ad283-a579-408f-b45a-e58b7f83e830",
"name": "Code",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
740,
560
],
"disabled": true
},
{
"parameters": {
"fields": {
"values": [
{
"name": "processID",
"stringValue": "={{ $json.body.processID }}"
},
{
"name": "main_tableID",
"stringValue": "={{ $json.body.main_tableID }}"
},
{
"name": "main_pageID",
"type": "numberValue",
"numberValue": "={{ $json.body.main_pageID }}"
},
{
"name": "url_become",
"stringValue": "={{ $json.body.url_become }}"
}
]
},
"options": {}
},
"id": "22241b89-682f-427d-9801-ecce0e0ca612",
"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": 3.2,
"position": [
660,
300
]
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "={{ $json.main_tableID }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $json.main_pageID }}",
"mode": "id"
},
"filtersUI": {
"values": [
{
"lookupColumn": "\u0427\u0435\u043a-\u0431\u043e\u043a\u0441",
"lookupValue": "true"
}
]
},
"options": {
"returnAllMatches": "returnAllMatches"
}
},
"id": "75dde8f9-4de6-4c93-849d-2325688193c5",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
960,
300
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "9c0d5f96-8aa8-4ddb-9859-dbecd2dfb108",
"name": "\u0423\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435 \u0441\u0442\u0440\u043e\u043a\u0438",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1180,
300
]
},
{
"parameters": {
"options": {}
},
"id": "baf49b2e-1a7a-479c-b40d-93d977c904c3",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1460,
280
]
},
{
"parameters": {
"options": {
"dotNotation": false
}
},
"id": "52142fd5-61ae-43ef-890c-a7394f4d1b6a",
"name": "\u041f\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": [
1840,
300
],
"executeOnce": true
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.\u0442\u0440\u0435\u043a }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "1c53066e-0f39-43cb-8678-d24513980dac",
"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 \u0431\u0435\u043b\u043f\u043e1",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1820,
-120
],
"alwaysOutputData": false
},
{
"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": "23c6bd1a-ae4f-4665-99a7-63b984771524",
"name": "\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0442\u0440\u043e\u043a\u0438 \u0441 \u0442\u0440\u0435\u043a\u043e\u043c",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1980,
0
],
"alwaysOutputData": true,
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"number": [
{
"name": "row_number",
"value": "={{ $json.row_number }}"
}
],
"string": [
{
"name": "\u0442\u0440\u0435\u043a",
"value": "={{ $json.\u0442\u0440\u0435\u043a.toUpperCase() }}"
},
{
"name": "\u0438\u043d\u0434\u0435\u043a\u0441",
"value": "={{ $json.\u0418\u043d\u0434\u0435\u043a\u0441 }}"
}
]
},
"options": {
"dotNotation": false
}
},
"id": "157cd9f3-ba5f-4329-9489-ee9b35fba729",
"name": "\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0437\u0430\u043a\u0430\u0437\u04305",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1920,
-340
],
"executeOnce": false
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "={{ $('\u041f\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 }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $('\u041f\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 }}",
"mode": "id"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"\u0418\u043d\u0434\u0435\u043a\u0441": "={{ $json.\u0438\u043d\u0434\u0435\u043a\u0441 }}",
"\u0442\u0440\u0435\u043a": "={{ $json.\u0442\u0440\u0435\u043a }}"
},
"matchingColumns": [
"\u0418\u043d\u0434\u0435\u043a\u0441"
],
"schema": [
{
"id": "\u0447\u0438\u0441\u043b\u043e",
"displayName": "\u0447\u0438\u0441\u043b\u043e",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0444\u0438\u043e \u043c\u0435\u043d\u0435\u0434\u0436\u0435\u0440\u0430",
"displayName": "\u0444\u0438\u043e \u043c\u0435\u043d\u0435\u0434\u0436\u0435\u0440\u0430",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0444\u0438\u043e \u043f\u043e\u043a\u0443\u043f\u0430\u0442\u0435\u043b\u044f",
"displayName": "\u0444\u0438\u043e \u043f\u043e\u043a\u0443\u043f\u0430\u0442\u0435\u043b\u044f",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u043f\u0440\u043e\u0434\u0430\u0436\u0430",
"displayName": "\u043f\u0440\u043e\u0434\u0430\u0436\u0430",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0431\u0435\u0437 \u043d\u0430\u043a\u0440\u0443\u0442\u0430",
"displayName": "\u0431\u0435\u0437 \u043d\u0430\u043a\u0440\u0443\u0442\u0430",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u043d\u0430\u043a\u0440\u0443\u0442",
"displayName": "\u043d\u0430\u043a\u0440\u0443\u0442",
"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
},
{
"id": "\u043d\u0435\u0432\u043e\u0441\u0442\u0440\u0435\u0431",
"displayName": "\u043d\u0435\u0432\u043e\u0441\u0442\u0440\u0435\u0431",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u043d\u0430\u043b\u0438\u0447\u0438\u0435",
"displayName": "\u043d\u0430\u043b\u0438\u0447\u0438\u0435",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u043b\u0438\u0447\u043d\u044b\u0439",
"displayName": "\u043b\u0438\u0447\u043d\u044b\u0439",
"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,
"removed": true
}
]
},
"options": {}
},
"id": "b098eec3-6f1e-4c4d-85c6-821c2c392e88",
"name": "Google Sheets3",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
2180,
-340
],
"alwaysOutputData": true,
"retryOnFail": true,
"waitBetweenTries": 3000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"continueOnFail": true
},
{
"parameters": {
"content": "## \u041f\u043e\u0434\u043c\u043e\u0434\u0443\u043b\u044c \u0443\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u044f \u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0430 \u0434\u043b\u044f \u0442\u0440\u0435\u043a\u043e\u0432",
"height": 348.4244308747857,
"width": 538.8801317324187
},
"id": "9b50dfca-2a5d-434e-9da7-328ae683639a",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
1860,
-480
]
},
{
"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": "d777a89d-5781-4895-bb9d-dfcb85d9d573",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
1560,
-420
]
},
{
"parameters": {},
"id": "1eeb1746-f239-4cfb-88de-c5f5eac91ee4",
"name": "No Operation, do nothing13",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
2860,
600
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "ac0b3cf5-71f4-4b54-9914-e17eb2576c21",
"name": "\u0421\u0417\u041f\u0426",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
2220,
300
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "c9555fdd-c7a4-4d4f-92e7-7ff85060fc39",
"name": "\u0421\u0417\u041f\u042610",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1440,
80
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "traks",
"sourceType": "sourceTypeJson",
"sourceData": "={\n\"BP_traks\": \n{\n},\n\"EP_traks\": \n{\n}\n}",
"filePath": "=root/n8n/{{ $json.processID }}.json"
},
"id": "e6c30c05-2d09-4ac6-a255-5e6ffa27ed45",
"name": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
760,
80
]
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "43ff8b30-6868-4a83-a17d-10c08415d6f8",
"name": "YGP6",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1020,
80
],
"alwaysOutputData": false
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value2": true
}
]
}
},
"id": "9816cc59-261d-4ba5-8145-da5708e47a75",
"name": "YGP7",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
2240,
20
],
"alwaysOutputData": false
},
{
"parameters": {
"resume": "webhook",
"options": {}
},
"id": "4d956d53-47fb-4f0a-b9ea-b2e396e78247",
"name": "\u0416\u0434\u0443\u043d",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
2860,
300
]
},
{
"parameters": {
"url": "={{ $('main JSON').first().json.data.endPoints['\u0421\u0431\u043e\u0440 \u0442\u0440\u0435\u043a\u043e\u0432_\u0433\u043b\u0443\u0431\u0438\u043d\u04302_(2\u0439 \u0438\u0437 2\u0445)'] }}",
"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": "check_tableID",
"value": "={{ $('\u041f\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 }}"
},
{
"name": "check_pageID",
"value": "={{ $('\u041f\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 }}"
},
{
"name": "url_become",
"value": "={{ $execution.resumeUrl }}"
}
]
},
"options": {}
},
"id": "a6905103-f65d-45b6-b4ce-1732ee95f743",
"name": "\u041f\u043e\u0433\u0440\u0443\u0436\u0430\u0435\u043c\u0441\u044f \u0433\u043b\u0443\u0431\u0436\u0435 \u0432 \u0441\u0431\u043e\u0440 \u0442\u0440\u0435\u043a\u043e\u0432",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
2540,
300
]
},
{
"parameters": {
"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": "74f1d97c-35a2-4a37-b650-40c26f879d7c",
"name": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks1",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
700,
-80
]
},
{
"parameters": {
"mode": "jsonToBinary",
"options": {}
},
"id": "d8ea417f-373c-487d-b4f3-e862b48643d9",
"name": "Convert to/from binary data",
"type": "n8n-nodes-base.moveBinaryData",
"typeVersion": 1.1,
"position": [
660,
-260
]
},
{
"parameters": {
"name": "={{ $('\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 }}_{{ $now.toISO().slice(0,19) }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"folderId": {
"__rl": true,
"value": "1pUomJR50VhnhZf_DWVXhyvJaFDNhKzBg",
"mode": "list",
"cachedResultName": "n8n.online_jsonHistory",
"cachedResultUrl": "https://drive.google.com/drive/folders/1pUomJR50VhnhZf_DWVXhyvJaFDNhKzBg"
},
"options": {}
},
"id": "38c2d2ca-937a-46e5-aeb5-1936838b5814",
"name": "Google Drive",
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
940,
-260
],
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"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": "e0eceaa9-f145-4e21-8621-a6fe65082d3d",
"name": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks2",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
1360,
-80
]
},
{
"parameters": {
"mode": "jsonToBinary",
"options": {}
},
"id": "c5d04f2a-2a7d-4ceb-8004-a7692f8aa572",
"name": "Convert to/from binary data1",
"type": "n8n-nodes-base.moveBinaryData",
"typeVersion": 1.1,
"position": [
1320,
-260
]
},
{
"parameters": {
"name": "={{ $('\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 }}_{{ $now.toISO().slice(0,19) }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"folderId": {
"__rl": true,
"value": "1pUomJR50VhnhZf_DWVXhyvJaFDNhKzBg",
"mode": "list",
"cachedResultName": "n8n.online_jsonHistory",
"cachedResultUrl": "https://drive.google.com/drive/folders/1pUomJR50VhnhZf_DWVXhyvJaFDNhKzBg"
},
"options": {}
},
"id": "4f4ea61c-9130-4bb3-84c9-8a6a804c961b",
"name": "Google Drive1",
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
1280,
-420
],
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"filePath": "=root/n8n/main.json"
},
"id": "bae4aa50-a60d-457d-a3a3-fd3e41cd8ec5",
"name": "main JSON",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
420,
-280
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "8e8d0f79-3e13-47de-993c-dfc596609716",
"name": "KED",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
440,
220
]
},
{
"parameters": {
"jsCode": "return(\n [\n {\n \"headers\": {\n \"host\": \"n8n.makeesn8n.online\",\n \"user-agent\": \"axios/1.8.2\",\n \"content-length\": \"179\",\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\": \"zsForvika\",\n \"main_tableID\": \"1_9LgkTKoyqjtKD4zr8yrpiS8B626zwwShptCgpfJhoE\",\n \"main_pageID\": 1847106999,\n \"url_become\": \"https://n8n.makeesn8n.online/webhook-waiting/890690\"\n },\n \"webhookUrl\": \"https://n8n.makeesn8n.online/webhook/modul_trackCollect\",\n \"executionMode\": \"production\"\n }\n]\n);"
},
"id": "981ba3f5-7146-43ae-a6c3-671f022fb524",
"name": "Code1",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
980,
560
],
"disabled": true
}
],
"settings": {
"executionOrder": "v1",
"saveManualExecutions": true,
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": "k3cmqrd2rdjhkgrK"
},
"staticData": null,
"tags": [
{
"createdAt": "2023-12-29T05:49:12.607Z",
"updatedAt": "2023-12-29T05:49:12.607Z",
"id": "2F2JpICiTQCMNk1Q",
"name": "treck_check"
},
{
"createdAt": "2023-12-29T05:48:03.050Z",
"updatedAt": "2023-12-29T05:48:03.050Z",
"id": "AgzDK5Bx0yz5Db7h",
"name": "json"
},
{
"createdAt": "2023-12-29T05:48:23.798Z",
"updatedAt": "2023-12-29T05:48:23.798Z",
"id": "UR0e0BgkatF4AB4O",
"name": "potap"
}
],
"triggerCount": 1,
"updatedAt": "2025-05-30T11:44:08.000Z",
"versionId": "dafd9008-3918-4b5f-96f8-5f5b2a063493"
}
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.
googleDriveOAuth2ApigoogleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
TrackCollect. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, moveBinaryData. Webhook trigger; 31 nodes.
Source: https://github.com/makees-by/n8ns/blob/9ecc9ce03dd07ad3f21456f95d3ecba945139578/workflowTrackCollect.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
Transform your n8n instance management with this advanced automation system featuring artificial intelligence-driven workflow selection. This template provides comprehensive maintenance operations wit
n8n, HTTP Request, Google Sheets +1
Convalidaciones Académicas - Estructura Base. Uses googleSheets, emailSend, googleDrive, httpRequest. Webhook trigger; 35 nodes.
Google Sheets, Email Send, Google Drive +2
This workflow automatically saves files received via LINE Messaging API into Google Drive and logs the file details into a Google Sheet. It checks the file type against allowed types, organizes files
Google Sheets, Google Drive, HTTP Request
This workflow turns your Google Sheet into a fully automated AI video factory powered by Google Veo 3 via Vertex AI. Simply fill in your prompts, choose your video settings, tick a checkbox — and walk
HTTP Request, Google Drive, Google Sheets