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": false,
"connections": {
"Google Sheets": {
"main": [
[
{
"node": "Item Lists",
"type": "main",
"index": 0
}
]
]
},
"Split In Batches2": {
"main": [
[
{
"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
}
],
[
{
"node": "\u0421\u0417\u041f\u04262",
"type": "main",
"index": 0
}
]
]
},
"E_b2": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446",
"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": "\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\u04309",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing6": {
"main": [
[
{
"node": "\u041e\u0431\u043d\u0443\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 checkProcess",
"type": "main",
"index": 0
}
]
]
},
"\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446": {
"main": [
[
{
"node": "Google Sheets2",
"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": "Google Sheets",
"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": "Split In Batches2",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing1",
"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
}
]
]
},
"\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\u04309": {
"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 \u0435\u0432\u0440\u043e\u043f\u043e\u0447\u0442\u043010",
"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 \u0435\u0432\u0440\u043e\u043f\u043e\u0447\u0442\u043010": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u0426",
"type": "main",
"index": 0
}
],
[
{
"node": "\u0421\u0417\u041f\u04261",
"type": "main",
"index": 0
},
{
"node": "\u0421\u0431\u043e\u0440 \u043d\u0435\u0432\u0435\u0440\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446",
"type": "main",
"index": 0
}
]
]
},
"Item Lists": {
"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
}
]
]
},
"\u0421\u0417\u041f\u0426": {
"main": [
[
{
"node": "Split In Batches2",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04262": {
"main": [
[
{
"node": "No Operation, do nothing6",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04261": {
"main": [
[
{
"node": "\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u0435\u0433\u043e \u0444\u0430\u0439\u043b\u0430 \u0432 JsonDatabase",
"type": "main",
"index": 0
}
]
]
},
"\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u0435\u0433\u043e \u0444\u0430\u0439\u043b\u0430 \u0432 JsonDatabase": {
"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\u043e",
"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\u043e": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
],
[
{
"node": "\u0421\u0417\u041f\u04263",
"type": "main",
"index": 0
}
]
]
},
"\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": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
},
{
"node": "Compare Datasets",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0431\u043e\u0440 \u043d\u0435\u0432\u0435\u0440\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445": {
"main": [
[
{
"node": "\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": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04263": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks1": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
}
]
]
},
"Merge": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks1",
"type": "main",
"index": 0
},
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks2",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks2": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0443\u0441\u043a \u043c\u043e\u0434\u0443\u043b\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438": {
"main": [
[
{
"node": "Stop and Error",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04264": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0443\u0441\u043a \u043c\u043e\u0434\u0443\u043b\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438",
"type": "main",
"index": 0
}
]
]
},
"\u041e\u0431\u043d\u0443\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 checkProcess": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u04264",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Compare Datasets",
"type": "main",
"index": 1
}
]
]
},
"Compare Datasets": {
"main": [
[],
[
{
"node": "Item Lists2",
"type": "main",
"index": 0
}
]
]
},
"Item Lists2": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Split In Batches2",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2023-12-15T18:49:54.435Z",
"id": "z4JEW8jpxWNFpwrw",
"isArchived": false,
"meta": null,
"name": "checkProcess(old)",
"nodes": [
{
"parameters": {},
"id": "7d492fc5-ce76-415e-98bd-e9c77175ddda",
"name": "E_b2",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-540,
1300
]
},
{
"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"
},
"options": {
"returnAllMatches": "returnAllMatches"
}
},
"id": "8ca061bf-348c-4db3-81a9-3f4581453592",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
740,
880
],
"alwaysOutputData": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7,
"triggerAtMinute": 7
}
]
}
},
"id": "714e29f7-a541-4fad-a47b-c336a4b67bab",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.1,
"position": [
-660,
1040
],
"disabled": true
},
{
"parameters": {
"batchSize": 1,
"options": {
"reset": false
}
},
"id": "bf63cc94-cfed-424a-ab64-5e15fc02dbab",
"name": "Split In Batches2",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 2,
"position": [
400,
1080
]
},
{
"parameters": {
"path": "checkProcess",
"options": {}
},
"id": "0ecaece7-2cf8-4f94-8cad-266a4dd92bdd",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
-440,
960
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.\u0442\u0440\u0435\u043a }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "bf5b07f3-f938-41e6-b244-917059e01670",
"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": [
1140,
880
],
"alwaysOutputData": false
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"string": [
{
"name": "url_become",
"value": "={{ $json.body.url_become }}"
},
{
"name": "processID",
"value": "={{ $json.body.processID }}"
},
{
"name": "main_tableID",
"value": "={{ $json.body.main_tableID }}"
}
],
"number": [
{
"name": "main_pageID",
"value": "={{ $json.body.main_pageID }}"
}
]
},
"options": {
"dotNotation": false
}
},
"id": "6cf17d5f-409a-4449-9fd9-63c79dd44625",
"name": "\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
-160,
1140
],
"executeOnce": false,
"alwaysOutputData": false
},
{
"parameters": {},
"id": "d7a47a86-1e25-450a-a9b7-bd060fcaa077",
"name": "No Operation, do nothing1",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
160,
1440
]
},
{
"parameters": {},
"id": "2be99c71-de5f-4e5c-b1a1-90ad5eeecf62",
"name": "No Operation, do nothing6",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
280,
520
]
},
{
"parameters": {
"url": "={{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.url_become }}",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "TrackCollect",
"value": "OK"
}
]
},
"options": {}
},
"id": "8612c9b6-dd97-4674-92fc-fda5ef572270",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
760,
500
]
},
{
"parameters": {
"options": {
"dotNotation": false
}
},
"id": "a33df484-f8d5-45f7-8bac-9fea2688e53c",
"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": [
800,
1080
],
"executeOnce": true
},
{
"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": "6eeb3cda-1f83-4993-b6ab-58d530e1675c",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
60,
1140
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "60cb0573-4c4c-43e6-b327-a8459643b7de",
"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": [
620,
1140
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json['\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441'] }}",
"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]"
},
{
"value1": "={{ $json['\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441'] }}",
"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"
}
]
},
"combineOperation": "any"
},
"id": "feaafa76-4626-4e5e-99d1-8cc0ad76a5f7",
"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\u04309",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1380,
660
],
"alwaysOutputData": false
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json['\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441'] }}",
"operation": "contains",
"value2": "={{ $json.\u0442\u0440\u0435\u043a }}"
}
]
},
"combineOperation": "any"
},
"id": "b5843e96-257d-41d8-b9ac-051669f1c574",
"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\u043010",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1440,
1280
],
"alwaysOutputData": false
},
{
"parameters": {
"chatId": "20678427",
"text": "\u041f\u0440\u0438 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430 ForIra \u043d\u0430\u0439\u0434\u0435\u043d\u044b \u043e\u0448\u0438\u0431\u043a\u0438. \u041f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435 \u0432 \u043b\u043e\u0433\u0430\u0445 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430.",
"additionalFields": {}
},
"id": "4d8cf2e4-0730-4682-8b50-b450cb029caf",
"name": "Telegram2",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1,
"position": [
2060,
520
],
"disabled": true
},
{
"parameters": {
"filePath": "=root/n8n/{{ $json.processID }}.json"
},
"id": "bece6c50-dc6c-4efb-a63a-beaeb869e026",
"name": "\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u0435\u0433\u043e \u0444\u0430\u0439\u043b\u0430 \u0432 JsonDatabase2",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
40,
760
]
},
{
"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\": \"ForIra\",\n \"main_tableID\": \"16oHTECcQN5z7xQ-3zBZCfgFNOM5MX0N7bE3S3QeiX1s\",\n \"main_pageID\": 874646227,\n \"url_become\": \"https://n8ns.makees.site/webhook-waiting/23\"\n }\n }\n]\n);"
},
"id": "05af5db8-1cc3-4c63-a555-0507fce6e7a6",
"name": "Code",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-380,
1200
],
"disabled": true
},
{
"parameters": {
"operation": "limit",
"maxItems": 500,
"keep": "lastItems"
},
"id": "5d34478d-7c50-4a17-a44d-517007fc41b6",
"name": "Item Lists",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3.1,
"position": [
960,
880
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "9a6bd8b3-56da-4a4a-8c25-c4ec4d1be74c",
"name": "\u0421\u0417\u041f\u0426",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1080,
1240
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "7ab85220-5e27-440d-afa2-f28cee232053",
"name": "\u0421\u0417\u041f\u04262",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
500,
860
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"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 }}"
},
{
"name": "\u0442\u0430\u0431\u043b\u0438\u0446\u0430",
"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').first().json.\u0422\u0430\u0431\u043b\u0438\u0446\u0430 }}"
}
],
"number": [
{
"name": "\u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430",
"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').first().json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}"
}
]
},
"options": {
"dotNotation": false
}
},
"id": "6a1107ea-922d-4956-a4ff-719be1b986a4",
"name": "\u0421\u0431\u043e\u0440 \u043d\u0435\u0432\u0435\u0440\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1500,
820
],
"executeOnce": false,
"alwaysOutputData": false
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "40be44d8-d267-4d7b-b283-5a1242ca13fb",
"name": "\u0421\u0417\u041f\u04261",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1520,
980
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"filePath": "=root/n8n/{{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.processID }}.json"
},
"id": "967d1ef6-aa02-4895-b656-f5062d07c773",
"name": "\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u0435\u0433\u043e \u0444\u0430\u0439\u043b\u0430 \u0432 JsonDatabase",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
1720,
980
]
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.data.checkProcess.Iteration }}",
"operation": "larger"
}
]
}
},
"id": "e4f04d38-5987-4b6a-887a-8ac8bad7b951",
"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\u043e",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1900,
980
],
"alwaysOutputData": false
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "checkProcess.Iteration",
"sourceType": "sourceTypeJson",
"sourceData": "=1",
"filePath": "=root/n8n/{{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.processID }}.json "
},
"id": "4c8a7ad8-2071-4458-87b0-51c8109f897b",
"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": [
2400,
1300
]
},
{
"parameters": {
"operation": "concatenateItems",
"aggregate": "aggregateAllItemData",
"destinationFieldName": "Traks",
"options": {}
},
"id": "d35809b5-40f1-464f-b0e2-238937b95641",
"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": [
2000,
820
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "72e0a990-962f-452e-9e2c-9e091dec355d",
"name": "\u0421\u0417\u041f\u04263",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1900,
1280
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"mode": "chooseBranch",
"output": "input2"
},
"id": "769e5d22-d774-4f36-9ec7-bee036e9006e",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
2100,
1220
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "checkProcess.Traks",
"sourceType": "sourceTypeJson",
"sourceData": "={{ JSON.stringify($input.item.json.Traks) }}",
"filePath": "=root/n8n/{{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.processID }}.json "
},
"id": "b42a0736-db3a-4ab9-b2be-febc5bd8dfad",
"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": [
2400,
1120
]
},
{
"parameters": {
"errorMessage": "\u041c\u043e\u0434\u0443\u043b\u044c \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u043e\u0432 \u043e\u0431\u043d\u0430\u0440\u0443\u0436\u0438\u043b \u043d\u0435\u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435. \u041f\u0440\u043e\u0446\u0435\u0441\u0441 \u043f\u0435\u0440\u0435\u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0449\u0435\u043d \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438."
},
"id": "cc299576-a64f-4b29-8388-7fa5b6b8d503",
"name": "Stop and Error",
"type": "n8n-nodes-base.stopAndError",
"typeVersion": 1,
"position": [
2900,
1040
]
},
{
"parameters": {
"url": "https://n8n.makees.online/webhook/checkProcess",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "=processID",
"value": "={{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.processID }}"
},
{
"name": "main_tableID",
"value": "={{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.main_tableID }}"
},
{
"name": "main_pageID",
"value": "={{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.main_pageID }}"
},
{
"name": "url_become",
"value": "={{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.url_become }}"
}
]
},
"options": {}
},
"id": "3fdd8709-117c-46a4-8cc7-12f20d8bd8d1",
"name": "\u0417\u0430\u043f\u0443\u0441\u043a \u043c\u043e\u0434\u0443\u043b\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
2920,
1200
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "ce3eb467-f899-46ee-bfa9-c2816c3d2af7",
"name": "\u0421\u0417\u041f\u04264",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
2740,
1200
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "checkProcess",
"sourceType": "sourceTypeJson",
"sourceData": "={\n\"Iteration\": 0,\n\"Traks\": \n{\n}\n}",
"filePath": "=root/n8n/{{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.processID }}.json "
},
"id": "832502db-b77c-4c0d-92f1-ae085c438b5f",
"name": "\u041e\u0431\u043d\u0443\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 checkProcess 1",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
-180,
780
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "checkProcess",
"sourceType": "sourceTypeJson",
"sourceData": "={\n\"Iteration\": 0,\n\"Traks\": \n{\n}\n}",
"filePath": "=root/n8n/{{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.processID }}.json "
},
"id": "49f71872-be5f-4b02-bb95-e900bbf0fe79",
"name": "\u041e\u0431\u043d\u0443\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 checkProcess",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
520,
500
]
},
{
"parameters": {
"mode": "chooseBranch",
"output": "input2"
},
"id": "8cd55be2-e92f-4e49-84d2-13a9e811dc73",
"name": "Merge1",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
2560,
1200
]
},
{
"parameters": {
"mergeByFields": {
"values": [
{
"field1": "Traks",
"field2": "Traks"
}
]
},
"resolve": "mix",
"options": {}
},
"id": "6012f683-cae1-44a1-a0b9-e54740320488",
"name": "Compare Datasets",
"type": "n8n-nodes-base.compareDatasets",
"typeVersion": 2.3,
"position": [
2440,
840
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "Traks",
"type": "arrayValue",
"arrayValue": "={{ $json.data.checkProcess.Traks }}"
}
]
},
"include": "none",
"options": {}
},
"id": "3e869386-5b90-4491-8eb8-36f80cf9886f",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
2200,
960
]
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"value": "={{ $json.\u0442\u0430\u0431\u043b\u0438\u0446\u0430 }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $json.\u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}",
"mode": "id"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"\u041e\u0442\u043c\u0435\u0442\u043a\u0430 \u043e \u0434\u043e\u0441\u0442\u0430\u0432\u043a\u0435": "\u041d\u0435 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e",
"\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441": "\u041e\u0448\u0438\u0431\u043e\u0447\u043d\u0430\u044f \u043e\u0442\u043c\u0435\u0442\u043a\u0430. \u0421\u0442\u0430\u0442\u0443\u0441 \u0432\u044b\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438.",
"\u0418\u043d\u0434\u0435\u043a\u0441": "={{ $json.\u0438\u043d\u0434\u0435\u043a\u0441 }}"
},
"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,
"removed": 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
},
{
"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
}
]
},
"options": {}
},
"id": "02fb9204-3cca-412f-a605-b5af7b5d849f",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
2860,
820
],
"alwaysOutputData": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"fieldToSplitOut": "Traks",
"options": {}
},
"id": "d1284632-d870-4bf3-864b-ca0813a2f4c1",
"name": "Item Lists2",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3,
"position": [
2660,
820
],
"alwaysOutputData": 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": "2024-02-13T13:20:16.000Z",
"versionId": "2115b302-55db-4fd1-a18d-042e44d05123"
}
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
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
checkProcess(old). Uses googleSheets, httpRequest, telegram, @n-octo-n/n8n-nodes-json-database. Event-driven trigger; 40 nodes.
Source: https://github.com/makees-by/n8ns/blob/9ecc9ce03dd07ad3f21456f95d3ecba945139578/workflowcheckProcess(old).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.
Automates LinkedIn job searches across multiple countries and categories, filters results with AI, stores data in Google Sheets, and sends weekly Telegram notifications. Perfect for professionals seek
BillBot. Uses telegram, telegramTrigger, httpRequest, googleSheets. Event-driven trigger; 7 nodes.
TextMain. Uses telegramTrigger, stopAndError, telegram, httpRequest. Event-driven trigger; 56 nodes.
This template monitors Google Drive folder for new files, extracts text from PDFs, images, text files, CSVs, and Google Docs., reads images with meta/llama-3.2-11b-vision-instruct, structures the resu
This workflow provides a complete solution for handling Telegram Stars payments, invoicing and refunds using n8n. It automates the process of sending invoices, managing pre-checkout approvals, recordi