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,
"connections": {
"IF3": {
"main": [
[
{
"node": "IF",
"type": "main",
"index": 0
}
],
[
{
"node": "\u0411\u0435\u0437 \u043e\u0442\u043c\u0435\u0442\u043a\u0438 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e \u043c\u044d\u0442\u0447 \u043f\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0443 (\u043f\u043e ID) \u0431\u043f",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u0443\u0435\u043c http \u043e\u0442\u0432\u0435\u0442": {
"main": [
[
{
"node": "IF3",
"type": "main",
"index": 0
}
]
]
},
"\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d": {
"main": [
[
{
"node": "\u041e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043d\u0430 \u0434\u0440\u0443\u0433\u043e\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043f\u0440\u0430\u0432\u0438\u0442 \u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0411\u041f1",
"type": "main",
"index": 0
}
]
]
},
"IF2": {
"main": [
[
{
"node": "\u0422\u0443\u0442 \u0441\u043e\u0431\u0440\u0430\u043d\u044b \u0432\u0441\u0435 \u0442\u0440\u0435\u043a\u0438 \u043d\u0430 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443",
"type": "main",
"index": 0
}
],
[
{
"node": "IF4",
"type": "main",
"index": 0
}
]
]
},
"IF4": {
"main": [
[
{
"node": "\u0422\u0443\u0442 \u0441\u043e\u0431\u0440\u0430\u043d\u044b \u0432\u0441\u0435 \u0442\u0440\u0435\u043a\u0438 \u043d\u0430 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "\u0412\u0432\u043e\u0434 \u043e\u0442\u0440\u0438\u0431\u0443\u0442\u043e\u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441",
"type": "main",
"index": 0
}
]
]
},
"\u0411\u0435\u0437 \u043e\u0442\u043c\u0435\u0442\u043a\u0438 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e \u043c\u044d\u0442\u0447 \u043f\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0443 (\u043f\u043e ID) \u0431\u043f": {
"main": [
[
{
"node": "No Operation, do nothing3",
"type": "main",
"index": 0
}
]
]
},
"\u0421 \u043e\u0442\u043c\u0435\u0442\u043a\u043e\u0439 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e \u043c\u044d\u0442\u0447 \u043f\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0443 (\u043f\u043e ID) \u0431\u043f": {
"main": [
[
{
"node": "No Operation, do nothing3",
"type": "main",
"index": 0
}
]
]
},
"When clicking \"Execute Workflow\"": {
"main": [
[
{
"node": "\u0412\u0445\u043e\u0434\u044f\u0449\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u04352",
"type": "main",
"index": 0
}
]
]
},
"IF": {
"main": [
[
{
"node": "\u0421 \u043e\u0442\u043c\u0435\u0442\u043a\u043e\u0439 \u0412\u0440\u0443\u0447\u0435\u043d\u043e \u043e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u0435\u043b\u044e\u043c\u044d\u0442\u0447 \u043f\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0443 (\u043f\u043e ID) \u0431\u043f1",
"type": "main",
"index": 0
}
],
[
{
"node": "\u0421 \u043e\u0442\u043c\u0435\u0442\u043a\u043e\u0439 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e \u043c\u044d\u0442\u0447 \u043f\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0443 (\u043f\u043e ID) \u0431\u043f",
"type": "main",
"index": 0
}
]
]
},
"\u0421 \u043e\u0442\u043c\u0435\u0442\u043a\u043e\u0439 \u0412\u0440\u0443\u0447\u0435\u043d\u043e \u043e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u0435\u043b\u044e\u043c\u044d\u0442\u0447 \u043f\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0443 (\u043f\u043e ID) \u0431\u043f1": {
"main": [
[
{
"node": "No Operation, do nothing3",
"type": "main",
"index": 0
}
]
]
},
"\u0412\u0445\u043e\u0434\u044f\u0449\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435": {
"main": [
[
{
"node": "\u0412\u0432\u043e\u0434 \u043e\u0442\u0440\u0438\u0431\u0443\u0442\u043e\u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441",
"type": "main",
"index": 0
}
]
]
},
"IF6": {
"main": [
[
{
"node": "No Operation, do nothing1",
"type": "main",
"index": 0
}
],
[
{
"node": "\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u0435\u0433\u043e \u0444\u0430\u0439\u043b\u0430 \u0432 JsonDatabase1",
"type": "main",
"index": 0
}
]
]
},
"IF7": {
"main": [
[
{
"node": "45db",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u04261",
"type": "main",
"index": 0
}
],
[
{
"node": "\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d",
"type": "main",
"index": 0
},
{
"node": "\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c procesID",
"type": "main",
"index": 0
},
{
"node": "Date & Time",
"type": "main",
"index": 0
}
]
]
},
"\u043e\u0448\u0438\u0431\u043a\u0430 \u043f\u0440\u0438 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e \u0442\u0440\u0435\u043a\u0443": {
"main": [
[
{
"node": "No Operation, do nothing3",
"type": "main",
"index": 0
}
]
]
},
"\u0412\u0432\u043e\u0434 \u043e\u0442\u0440\u0438\u0431\u0443\u0442\u043e\u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441": {
"main": [
[
{
"node": "\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 workProcess1",
"type": "main",
"index": 0
},
{
"node": "main JSON",
"type": "main",
"index": 0
},
{
"node": "\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u04381",
"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": "Item Lists2",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u0426": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04261": {
"main": [
[
{
"node": "No Operation, do nothing2",
"type": "main",
"index": 0
}
]
]
},
"\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 workProcess1": {
"main": [
[
{
"node": "\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043e\u043a\u043e\u043d\u0447\u0435\u043d\u0430 \u043b\u0438 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0430\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043e\u043a\u043e\u043d\u0447\u0435\u043d\u0430 \u043b\u0438 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0430\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430": {
"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
}
],
[
{
"node": "IF6",
"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 JsonDatabase1": {
"main": [
[
{
"node": "Item Lists",
"type": "main",
"index": 0
}
]
]
},
"Item Lists": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "IF7",
"type": "main",
"index": 0
},
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"45db": {
"main": [
[
{
"node": "IF8",
"type": "main",
"index": 0
}
]
]
},
"IF8": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "IF2",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 workProcess4": {
"main": [
[
{
"node": "MySQL4",
"type": "main",
"index": 0
}
]
]
},
"main JSON": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing": {
"main": [
[
{
"node": "No Operation, do nothing4",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing1": {
"main": [
[
{
"node": "No Operation, do nothing2",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing4": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u04261",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0443\u0442 \u0441\u043e\u0431\u0440\u0430\u043d\u044b \u0432\u0441\u0435 \u0442\u0440\u0435\u043a\u0438 \u043d\u0430 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443": {
"main": [
[
{
"node": "IF5",
"type": "main",
"index": 0
},
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04305",
"type": "main",
"index": 0
}
]
]
},
"IF5": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u04262",
"type": "main",
"index": 0
},
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04301",
"type": "main",
"index": 0
},
{
"node": "IF9",
"type": "main",
"index": 0
},
{
"node": "\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\u043c",
"type": "main",
"index": 0
},
{
"node": "No Operation, do nothing7",
"type": "main",
"index": 0
}
],
[
{
"node": "\u0434\u043e 250 \u0442\u0440\u0435\u043a\u043e\u0432",
"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 JsonDatabase2": {
"main": [
[
{
"node": "\u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0434\u0440\u0443\u0433\u043e\u0439 \u0441\u0435\u0440\u0432\u0430\u043a",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04262": {
"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 JsonDatabase2",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04301": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433 1",
"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\u04301": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04303",
"type": "main",
"index": 0
}
],
[
{
"node": "tmp read",
"type": "main",
"index": 0
}
]
]
},
"\u0427\u0442\u0435\u043d\u0438\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430": {
"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\u04301",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433": {
"main": [
[
{
"node": "\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 workProcess1",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433 1": {
"main": [
[
{
"node": "No Operation, do nothing7",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u04332": {
"main": [
[
{
"node": "No Operation, do nothing7",
"type": "main",
"index": 0
}
]
]
},
"\u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0434\u0440\u0443\u0433\u043e\u0439 \u0441\u0435\u0440\u0432\u0430\u043a": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u04332",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing5": {
"main": [
[
{
"node": "\u0417\u0430\u0432\u0435\u0440\u0448\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430. \u0412\u043e\u0437\u0432\u0440\u0430\u0442 \u0432 \u0442\u0433\u043b\u0430\u0432\u043d\u044b\u0439 \u043f\u0440\u043e\u0446\u0435\u0441\u0441.",
"type": "main",
"index": 0
}
]
]
},
"IF9": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "\u0422\u0430\u0439\u043c\u0435\u0440 \u0442\u0443\u0442",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "\u0422\u0430\u0439\u043c\u0435\u0440 \u0442\u0443\u0442",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0430\u0439\u043c\u0435\u0440 \u0442\u0443\u0442": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u04332",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "\u0427\u0442\u0435\u043d\u0438\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430": {
"main": [
[
{
"node": "\u0427\u0442\u0435\u043d\u0438\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04302": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"tmp read": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"If": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04302",
"type": "main",
"index": 0
}
],
[
{
"node": "\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": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04303": {
"main": [
[
{
"node": "No Operation, do nothing5",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing2": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430",
"type": "main",
"index": 0
},
{
"node": "\u0414\u0430\u043d\u043d\u044b\u0435 \u0434\u043b\u044f \u0437\u0430\u043d\u044f\u0442\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u04301",
"type": "main",
"index": 0
}
]
]
},
"\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": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04303",
"type": "main",
"index": 0
}
]
]
},
"\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\u043c": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u04333",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u04333": {
"main": [
[
{
"node": "No Operation, do nothing7",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u04305": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433 ",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433 ": {
"main": [
[
{
"node": "IF5",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u04381": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433 2",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433 2": {
"main": [
[
{
"node": "\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d",
"type": "main",
"index": 0
}
]
]
},
"\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c procesID": {
"main": [
[
{
"node": "\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438",
"type": "main",
"index": 0
}
]
]
},
"Item Lists2": {
"main": [
[
{
"node": "IF2",
"type": "main",
"index": 0
}
]
]
},
"Date & Time": {
"main": [
[
{
"node": "\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u0433 2",
"type": "main",
"index": 0
}
]
]
},
"\u0440\u0430\u0437\u043d\u0438\u0446\u0430": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Edit Fields3",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields4",
"type": "main",
"index": 0
}
]
]
},
"Wait3": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 workProcess4",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields3": {
"main": [
[
{
"node": "Wait3",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields4": {
"main": [
[
{
"node": "Wait3",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing3": {
"main": [
[
{
"node": "\u0440\u0430\u0437\u043d\u0438\u0446\u0430",
"type": "main",
"index": 0
}
]
]
},
"\u0412\u0445\u043e\u0434\u044f\u0449\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u04351": {
"main": [
[
{
"node": "\u0412\u0432\u043e\u0434 \u043e\u0442\u0440\u0438\u0431\u0443\u0442\u043e\u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441",
"type": "main",
"index": 0
}
]
]
},
"\u041e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043d\u0430 \u0434\u0440\u0443\u0433\u043e\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043f\u0440\u0430\u0432\u0438\u0442 \u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0411\u041f": {
"main": [
[],
[]
]
},
"\u041e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043d\u0430 \u0434\u0440\u0443\u0433\u043e\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043f\u0440\u0430\u0432\u0438\u0442 \u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0411\u041f1": {
"main": [
[
{
"node": "\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u0443\u0435\u043c http \u043e\u0442\u0432\u0435\u0442",
"type": "main",
"index": 0
}
],
[
{
"node": "\u043e\u0448\u0438\u0431\u043a\u0430 \u043f\u0440\u0438 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e \u0442\u0440\u0435\u043a\u0443",
"type": "main",
"index": 0
}
]
]
},
"\u0434\u043e 250 \u0442\u0440\u0435\u043a\u043e\u0432": {
"main": [
[
{
"node": "No Operation, do nothing6",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing6": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
},
{
"node": "\u0414\u0430\u043d\u043d\u044b\u0435 \u0434\u043b\u044f \u0437\u0430\u043d\u044f\u0442\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u0430",
"type": "main",
"index": 0
}
]
]
},
"\u0414\u0430\u043d\u043d\u044b\u0435 \u0434\u043b\u044f \u0437\u0430\u043d\u044f\u0442\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u0430": {
"main": [
[
{
"node": "Execute Workflow",
"type": "main",
"index": 0
}
]
]
},
"MySQL4": {
"main": [
[
{
"node": "\u0437\u0430\u043c\u0435\u043d\u0430 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f",
"type": "main",
"index": 0
}
]
]
},
"\u0437\u0430\u043c\u0435\u043d\u0430 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u0426",
"type": "main",
"index": 0
}
]
]
},
"\u0414\u0430\u043d\u043d\u044b\u0435 \u0434\u043b\u044f \u0437\u0430\u043d\u044f\u0442\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u04301": {
"main": [
[
{
"node": "Execute Workflow1",
"type": "main",
"index": 0
}
]
]
},
"Limit1": {
"main": [
[]
]
},
"No Operation, do nothing7": {
"main": [
[
{
"node": "\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u043c \u0447\u0451\u0442\u043d\u0430\u044f \u0434\u0430\u0442\u0430 \u043b\u0438 \u043d\u0435\u0442",
"type": "main",
"index": 0
}
]
]
},
"\u041e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u043c \u0447\u0451\u0442\u043d\u0430\u044f \u0434\u0430\u0442\u0430 \u043b\u0438 \u043d\u0435\u0442": {
"main": [
[
{
"node": "\u041f\u043e \u0447\u0451\u0442\u043d\u044b\u043c 1\u0435 350",
"type": "main",
"index": 0
}
],
[
{
"node": "\u041f\u043e \u043d\u0435\u0447\u0451\u0442\u043d\u044b\u043c \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 350",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e \u0447\u0451\u0442\u043d\u044b\u043c 1\u0435 350": {
"main": [
[
{
"node": "No Operation, do nothing6",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e \u043d\u0435\u0447\u0451\u0442\u043d\u044b\u043c \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 350": {
"main": [
[
{
"node": "No Operation, do nothing6",
"type": "main",
"index": 0
}
]
]
},
"\u0412\u0445\u043e\u0434\u044f\u0449\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u04352": {
"main": [
[
{
"node": "\u0412\u0445\u043e\u0434\u044f\u0449\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u04351",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2024-03-24T15:52:10.628Z",
"id": "z1ebLdFwBMuXHUut",
"isArchived": false,
"meta": null,
"name": "BP_check",
"nodes": [
{
"parameters": {
"keepOnlySet": true,
"values": {
"string": [
{
"name": "\u0422\u0440\u0435\u043a \u043d\u043e\u043c\u0435\u0440",
"value": "={{ $json[\"data\"][0][\"number\"] }}"
},
{
"name": "\u0421\u0442\u0430\u0442\u0443\u0441 \u0438 \u0434\u0430\u0442\u0430 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f",
"value": "={{ $json[\"data\"][0][\"steps\"][0][\"event\"] }} / {{ $json[\"data\"][0][\"steps\"][0][\"place\"] }} / {{ $json[\"data\"][0][\"steps\"][0][\"place_index\"] }} / {{ $json[\"data\"][0][\"steps\"][0][\"created_at\"] }}"
},
{
"name": "\u0441\u0442\u0430\u0442\u0443\u0441 \u043a\u043e\u0440.",
"value": "={{ $json[\"data\"][0][\"steps\"][0][\"event\"] }}"
},
{
"name": "=\u0438\u043d\u0434\u0435\u043a\u0441",
"value": "={{ $('\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d').item.json.\u0438\u043d\u0434\u0435\u043a\u0441 }}"
}
],
"number": [
{
"name": "table",
"value": "={{ $('\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d').item.json.table }}"
},
{
"name": "page",
"value": "={{ $('\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d').item.json.page }}"
}
]
},
"options": {}
},
"id": "7a61c8de-91f7-4d01-828b-69976b1461b7",
"name": "\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u0443\u0435\u043c http \u043e\u0442\u0432\u0435\u0442",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1220,
1060
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json['\u0421\u0442\u0430\u0442\u0443\u0441 \u0438 \u0434\u0430\u0442\u0430 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f'] }}",
"operation": "contains",
"value2": "\u0412\u0440\u0443\u0447\u0435\u043d\u043e"
}
]
}
},
"id": "c40c2dcd-f764-431b-96b4-85ae390de02a",
"name": "IF3",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1360,
1360
]
},
{
"parameters": {
"content": "## \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0411\u0415\u041b\u041f\u041e\u0427\u0422\u042b",
"height": 80,
"width": 321.4218402115646
},
"id": "0bbe49b5-328c-4f97-8314-d499e991faaa",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-2200,
580
]
},
{
"parameters": {
"options": {}
},
"id": "7309dbd4-516e-4198-98ea-6c2015b46a56",
"name": "\u043f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0442\u0440\u0435\u043a \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
820,
1320
],
"executeOnce": true
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $input.all().length }}",
"operation": "larger",
"value2": 1
}
]
}
},
"id": "e0cf1e78-183a-4cf9-98e2-0c89ccd7ac2d",
"name": "IF2",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
-1360,
1140
],
"alwaysOutputData": false
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.\u0442\u0440\u0435\u043a }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "937081ac-64e3-48d5-8165-fe914f45ec34",
"name": "IF4",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
-1320,
1340
]
},
{
"parameters": {
"path": "bp_check",
"options": {}
},
"id": "2237620d-c629-4604-8335-6a22b462e62f",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
-2140,
1040
]
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "={{ $json.table }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $json.page }}",
"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": "={{ $now.toISO().slice(0,19) }} \u0411\u041f",
"\u0418\u043d\u0434\u0435\u043a\u0441": "={{ $json.\u0438\u043d\u0434\u0435\u043a\u0441 }}",
"\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441": "={{ $('\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u0443\u0435\u043c http \u043e\u0442\u0432\u0435\u0442').first().json['\u0422\u0440\u0435\u043a \u043d\u043e\u043c\u0435\u0440'] }}: {{ $json['\u0421\u0442\u0430\u0442\u0443\u0441 \u0438 \u0434\u0430\u0442\u0430 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f'] }} "
},
"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": "\u0442\u0430\u0431\u043b\u0438\u0446\u0430",
"displayName": "\u0442\u0430\u0431\u043b\u0438\u0446\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": "\u0448\u0442\u0440\u0430\u0444",
"displayName": "\u0448\u0442\u0440\u0430\u0444",
"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": "\u0420\u043e\u0441 \u0440\u0443\u0431",
"displayName": "\u0420\u043e\u0441 \u0440\u0443\u0431",
"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": false
}
]
},
"options": {}
},
"id": "6a67fadb-6f24-4bb4-ab55-cb6790bfe526",
"name": "\u0411\u0435\u0437 \u043e\u0442\u043c\u0435\u0442\u043a\u0438 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e \u043c\u044d\u0442\u0447 \u043f\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0443 (\u043f\u043e ID) \u0431\u043f",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1340,
1680
],
"retryOnFail": true,
"waitBetweenTries": 3000,
"alwaysOutputData": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"continueOnFail": true
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "={{ $json.table }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $json.page }}",
"mode": "id"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"\u041e\u0442\u043c\u0435\u0442\u043a\u0430 \u043e \u0434\u043e\u0441\u0442\u0430\u0432\u043a\u0435": "\u0414\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e",
"\u0414\u0430\u0442\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f": "={{ $now.toISO().slice(0,19) }} \u0411\u041f",
"\u0418\u043d\u0434\u0435\u043a\u0441": "={{ $json.\u0438\u043d\u0434\u0435\u043a\u0441 }}",
"\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441": "={{ $('\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u0443\u0435\u043c http \u043e\u0442\u0432\u0435\u0442').first().json['\u0422\u0440\u0435\u043a \u043d\u043e\u043c\u0435\u0440'] }}: {{ $json['\u0421\u0442\u0430\u0442\u0443\u0441 \u0438 \u0434\u0430\u0442\u0430 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f'] }} "
},
"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": "\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": false
},
{
"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
}
]
},
"options": {}
},
"id": "95febb49-672e-4d07-86d9-04b657f5bb28",
"name": "\u0421 \u043e\u0442\u043c\u0435\u0442\u043a\u043e\u0439 \u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u043e \u043c\u044d\u0442\u0447 \u043f\u043e \u0438\u043d\u0434\u0435\u043a\u0441\u0443 (\u043f\u043e ID) \u0431\u043f",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1800,
1460
],
"alwaysOutputData": true,
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"continueOnFail": true
},
{
"parameters": {},
"id": "65567016-cd25-4ac9-856c-27932e6325b8",
"name": "No Operation, do nothing2",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
-220,
640
]
},
{
"parameters": {},
"id": "10eb28f8-a942-4304-bbeb-bb816dc69875",
"name": "When clicking \"Execute Workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-2460,
1240
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json['\u0421\u0442\u0430\u0442\u0443\u0441 \u0438 \u0434\u0430\u0442\u0430 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f'] }}",
"operation": "contains",
"value2": "\u0412\u0440\u0443\u0447\u0435\u043d\u043e \u043e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u0435\u043b\u044e"
}
]
}
},
"id": "52ee66ba-11d7-4f99-a969-94a5fc41d71a",
"name": "IF",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1540,
1280
]
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "={{ $json.table }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $json.page }}",
"mode": "id"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"\u041e\u0442\u043c\u0435\u0442\u043a\u0430 \u043e \u0434\u043e\u0441\u0442\u0430\u0432\u043a\u0435": "\u0412\u0440\u0443\u0447\u0435\u043d\u043e \u043e\u0442\u043f\u0440\u0430\u0432\u0438\u0442\u0435\u043b\u044e",
"\u0414\u0430\u0442\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f": "={{ $now.toISO().slice(0,19) }} \u0411\u041f",
"\u0418\u043d\u0434\u0435\u043a\u0441": "={{ $json.\u0438\u043d\u0434\u0435\u043a\u0441 }}",
"\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441": "={{ $('\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u0443\u0435\u043c http \u043e\u0442\u0432\u0435\u0442').first().json['\u0422\u0440\u0435\u043a \u043d\u043e\u043c\u0435\u0440'] }}: {{ $json['\u0421\u0442\u0430\u0442\u0443\u0441 \u0438 \u0434\u0430\u0442\u0430 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f']}} "
},
"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,
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.
googleSheetsOAuth2ApimySql
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow checks and processes delivery status updates for business parcels, pulling data from Google Sheets and a JSON database to match records by ID and update statuses via HTTP requests. It is designed for logistics teams who need to handle high-volume parcel tracking without manual intervention. The core step involves matching incoming webhook data against existing records and filtering only unique deliveries before sending confirmations.
Use it when you receive frequent webhook notifications from carriers and need to avoid duplicate updates in your tracking system. Avoid it for simple one-off checks or when your data volume stays below a few hundred records daily, as the 99-node structure becomes unnecessary overhead. A common variation replaces the JSON database lookup with MySQL queries for teams already using relational databases.
About this workflow
BP_check. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 99 nodes.
Source: https://github.com/makees-by/n8ns/blob/9ecc9ce03dd07ad3f21456f95d3ecba945139578/workflowBP_check.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.
This workflow demonstrates how to export SQL to XML and present the data nicely formatted using an XSL Template.
MySQL, Item Lists, XML +2
v25.1.3. Uses httpRequest, mySql, n8n-nodes-zohozeptomail. Webhook trigger; 98 nodes.
HTTP Request, MySQL, N8N Nodes Zohozeptomail
This workflow automates raw materials inventory management for businesses, eliminating manual stock updates, delayed material issue approvals, and missed low stock alerts. It ensures real-time stock t
Google Sheets, Gmail, Supabase +1
This template demonstrates how to build a low-code, AI-powered data analysis workflow in n8n. It enables you to connect to various data sources (such as MySQL, Google Sheets, or local files), process
MySQL, Google Sheets, Read Write File +2
This workflow is designed for software teams, project managers, and developers who manage work across Azure DevOps and GitHub. It helps organizations that use Azure DevOps for work item tracking but r
HTTP Request, Google Sheets, GitHub