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\u04351",
"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 nothing8",
"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 nothing8",
"type": "main",
"index": 0
}
]
]
},
"\u0422\u0443\u043f\u0438\u043a \u043b\u043e\u04332": {
"main": [
[
{
"node": "No Operation, do nothing8",
"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
},
{
"node": "Limit1",
"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 nothing8",
"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
}
]
]
},
"No Operation, do nothing8": {
"main": [
[
{
"node": "\u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0441\u0435\u0433\u043e\u0434\u043d\u044f \u043d\u0430 \u0447\u0451\u0442\u043d\u043e\u0441\u0442\u044c",
"type": "main",
"index": 0
}
]
]
},
"\u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0441\u0435\u0433\u043e\u0434\u043d\u044f \u043d\u0430 \u0447\u0451\u0442\u043d\u043e\u0441\u0442\u044c": {
"main": [
[
{
"node": "\u041f\u043e \u0447\u0451\u0442\u043d\u044b\u043c \u043f\u0435\u0440\u0432\u044b\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 3350",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e \u0447\u0451\u0442\u043d\u044b\u043c \u043f\u0435\u0440\u0432\u044b\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 3350": {
"main": [
[
{
"node": "No Operation, do nothing6",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2025-01-31T13:13:03.159Z",
"id": "VRaYqIk2U8RAcAjz",
"isArchived": false,
"meta": null,
"name": "BP_check2",
"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": "870df4df-c8b4-49d6-8bd2-5cc7858bb830",
"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": [
1440,
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": "31993aad-c5e4-4abd-89bc-a2aca460fdfc",
"name": "IF3",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1580,
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": "4fdbc6fa-3341-41f1-a111-77025c856a49",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-2200,
580
]
},
{
"parameters": {
"options": {}
},
"id": "f66c36bd-f567-4373-8c2f-ca5ac2c9c3c1",
"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": [
1040,
1320
],
"executeOnce": true
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $input.all().length }}",
"operation": "larger",
"value2": 1
}
]
}
},
"id": "a925a349-bca5-47d3-bed3-bf1aa1e6f952",
"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": "3fefc0eb-d69b-4c75-884f-7fdc3175133a",
"name": "IF4",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
-1320,
1340
]
},
{
"parameters": {
"path": "BP_check2",
"options": {}
},
"id": "b9470fd5-1375-485a-894a-b49a3227a9af",
"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": "87214353-a0fd-44f6-832b-57ab2cb8439b",
"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": [
1560,
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": "365e0ebc-a0fc-4cd4-ac76-828a454deac5",
"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": [
2020,
1460
],
"alwaysOutputData": true,
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"continueOnFail": true
},
{
"parameters": {},
"id": "e96c41cc-5184-479a-a1dd-f7deee46187f",
"name": "No Operation, do nothing2",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
0,
640
]
},
{
"parameters": {},
"id": "a1fe6c4a-e5b4-4284-b81f-268aab214ce7",
"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": "00a173fc-f6cc-4c22-927b-cb8b0bbc8883",
"name": "IF",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1760,
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,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id":
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
About this workflow
BP_check2. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 95 nodes.
Source: https://github.com/makees-by/n8ns/blob/9ecc9ce03dd07ad3f21456f95d3ecba945139578/workflowBP_check2.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.
BP_check. Uses googleSheets, @n-octo-n/n8n-nodes-json-database, httpRequest, itemLists. Webhook trigger; 99 nodes.
Google Sheets, @N Octo N/N8N Nodes Json Database, HTTP Request +2
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
Actualizar asignaciones de operaciones en financing y loans. Uses googleSheets, itemLists, mySql. Scheduled trigger; 41 nodes.
Google Sheets, Item Lists, MySQL