This workflow follows the Google Drive → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"active": true,
"connections": {
"Google Sheets": {
"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
}
]
]
},
"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
}
]
]
},
"\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": "Edit Fields4",
"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": "\u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441 \u043d\u0430 \u0442\u0440\u0435\u043a \u0438\u0437 \u0441\u0442\u043e\u043b\u0431\u0446\u0430 \u0442\u0440\u0435\u043a",
"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
}
]
]
},
"\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
},
{
"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
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "IF2",
"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 JsonDatabase3": {
"main": [
[
{
"node": "Item Lists1",
"type": "main",
"index": 0
},
{
"node": "Item Lists3",
"type": "main",
"index": 0
}
]
]
},
"Item Lists1": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Merge2": {
"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\u04321",
"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\u04321": {
"main": [
[
{
"node": "Edit Fields3",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields3": {
"main": [
[
{
"node": "AllTr",
"type": "main",
"index": 0
}
]
]
},
"AllTr": {
"main": [
[
{
"node": "IF",
"type": "main",
"index": 0
}
]
]
},
"IF": {
"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
}
]
]
},
"Edit Fields4": {
"main": [
[
{
"node": "AllTr1",
"type": "main",
"index": 0
}
]
]
},
"AllTr1": {
"main": [
[
{
"node": "\u0423\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435 \u0441\u0442\u0440\u043e\u043a\u04381",
"type": "main",
"index": 0
}
]
]
},
"\u0423\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435 \u0441\u0442\u0440\u043e\u043a\u04381": {
"main": [
[
{
"node": "\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0434\u043b\u0438\u043d\u043d\u0443 \u0441\u043f\u0438\u0441\u043a\u0430(\u0438\u0441\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435)",
"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": "IF4",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0438\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0442\u0440\u0435\u043a\u0438 \u0441 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c\u0438": {
"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\u04323",
"type": "main",
"index": 0
}
]
]
},
"\u0420\u0430\u0441\u043f\u0430\u043a\u043e\u0432\u044b\u0432\u0430\u0435\u043c \u043c\u0430\u0441\u0441\u0438\u0432 \u0441 \u0442\u0440\u0435\u043a\u0430\u043c\u0438": {
"main": [
[
{
"node": "\u0421\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0438\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0442\u0440\u0435\u043a\u0438 \u0441 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c\u0438",
"type": "main",
"index": 1
}
]
]
},
"\u041f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u043e\u0431\u0440\u0430\u043d\u043d\u044b\u0435 \u0442\u0440\u0435\u043a\u0438 BP \u0438\u0437 JSON": {
"main": [
[
{
"node": "\u0420\u0430\u0441\u043f\u0430\u043a\u043e\u0432\u044b\u0432\u0430\u0435\u043c \u043c\u0430\u0441\u0441\u0438\u0432 \u0441 \u0442\u0440\u0435\u043a\u0430\u043c\u0438",
"type": "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\u04323": {
"main": [
[
{
"node": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04265": {
"main": [
[
{
"node": "\u041f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u043e\u0431\u0440\u0430\u043d\u043d\u044b\u0435 \u0442\u0440\u0435\u043a\u0438 BP \u0438\u0437 JSON",
"type": "main",
"index": 0
}
]
]
},
"\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u04267",
"type": "main",
"index": 0
}
]
]
},
"IF1": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u0426",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields5": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
},
{
"node": "\u0421\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0438\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0442\u0440\u0435\u043a\u0438 \u0441 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c\u0438",
"type": "main",
"index": 0
}
]
]
},
"IF2": {
"main": [
[
{
"node": "\u0421\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0438\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0442\u0440\u0435\u043a\u0438 \u0441 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c\u0438",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04266": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u0426",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0434\u043b\u0438\u043d\u043d\u0443 \u0441\u043f\u0438\u0441\u043a\u0430(\u0438\u0441\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435)": {
"main": [
[
{
"node": "No Operation, do nothing2",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u043f\u0443\u0441\u0442\u043e\u0439 \u0432\u044b\u0432\u043e\u0434": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u04266",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing2": {
"main": [
[
{
"node": "No Operation, do nothing3",
"type": "main",
"index": 0
}
]
]
},
"No Operation, do nothing3": {
"main": [
[
{
"node": "\u041f\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u043f\u0443\u0441\u0442\u043e\u0439 \u0432\u044b\u0432\u043e\u0434",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441 \u043d\u0430 \u0442\u0440\u0435\u043a \u0438\u0437 \u0441\u0442\u043e\u043b\u0431\u0446\u0430 \u0442\u0440\u0435\u043a": {
"main": [
[
{
"node": "\u0421\u0417\u041f\u0426",
"type": "main",
"index": 0
}
],
[
{
"node": "\u0421\u0417\u041f\u04265",
"type": "main",
"index": 0
},
{
"node": "Edit Fields5",
"type": "main",
"index": 0
}
]
]
},
"\u041e\u0431\u043d\u0443\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 checkProcess1": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Convert to/from binary data1": {
"main": [
[
{
"node": "Google Drive1",
"type": "main",
"index": 0
}
]
]
},
"Google Drive1": {
"main": [
[
{
"node": "IF3",
"type": "main",
"index": 0
}
]
]
},
"\u041f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u043e\u0431\u0440\u0430\u043d\u043d\u044b\u0435 \u0442\u0440\u0435\u043a\u0438 BP \u0438\u0437 JSON1": {
"main": [
[
{
"node": "Convert to/from binary data1",
"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 checkProcess1",
"type": "main",
"index": 0
}
]
]
},
"IF3": {
"main": [
[
{
"node": "No Operation, do nothing6",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0417\u041f\u04267": {
"main": [
[
{
"node": "\u0421\u0442\u0430\u0432\u0438\u043c 1 \u0432 CcheckProcess.iterstion",
"type": "main",
"index": 0
}
]
]
},
"IF4": {
"main": [
[
{
"node": "HTTP Request1",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request1": {
"main": [
[
{
"node": "\u041f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u043e\u0431\u0440\u0430\u043d\u043d\u044b\u0435 \u0442\u0440\u0435\u043a\u0438 BP \u0438\u0437 JSON1",
"type": "main",
"index": 0
}
]
]
},
"\u0421\u0442\u0430\u0432\u0438\u043c 1 \u0432 CcheckProcess.iterstion": {
"main": [
[
{
"node": "IF1",
"type": "main",
"index": 0
}
]
]
},
"main JSON": {
"main": [
[
{
"node": "KED",
"type": "main",
"index": 0
}
]
]
},
"KED": {
"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 JsonDatabase3",
"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": "\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u0435\u0433\u043e \u0444\u0430\u0439\u043b\u0430 \u0432 JsonDatabase3",
"type": "main",
"index": 0
},
{
"node": "Google Sheets2",
"type": "main",
"index": 0
},
{
"node": "main JSON",
"type": "main",
"index": 0
}
]
]
},
"Code1": {
"main": [
[]
]
},
"\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": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 1
}
],
[
{
"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
}
]
]
},
"Item Lists3": {
"main": [
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Merge2",
"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
}
]
]
},
"\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": "Merge2",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2024-02-06T15:03:22.402Z",
"id": "dk2vpgDyztVqJFwU",
"isArchived": false,
"meta": {
"templateCredsSetupCompleted": true
},
"name": "PCN",
"nodes": [
{
"parameters": {},
"id": "923ced11-bfff-4f1f-a361-4ee33da979cd",
"name": "E_b2",
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-1120,
1440
]
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "={{ $json.table }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "={{ $json.page }}",
"mode": "id"
},
"filtersUI": {
"values": [
{
"lookupColumn": "\u0418\u043d\u0434\u0435\u043a\u0441",
"lookupValue": "={{ $json.\u0438\u043d\u0434\u0435\u043a\u0441 }}"
}
]
},
"options": {}
},
"id": "cc40becb-2ca9-47c1-b295-20122c7081c8",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1060,
1480
],
"alwaysOutputData": true,
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"batchSize": 1,
"options": {
"reset": false
}
},
"id": "0ef8cd13-806f-4e17-97c1-69226ff6f1dd",
"name": "Split In Batches2",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 2,
"position": [
440,
1100
]
},
{
"parameters": {
"path": "CPN",
"options": {}
},
"id": "d6e37e0e-64b2-438e-b7e8-366c4d8cd88a",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
-1160,
1200
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.\u0442\u0440\u0435\u043a }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "0ae82311-db39-4029-a285-5d7c265750a1",
"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": [
1160,
700
],
"alwaysOutputData": false
},
{
"parameters": {},
"id": "0c5e13d2-ff89-441d-9d3b-10b82bd05ce2",
"name": "No Operation, do nothing1",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
-80,
1680
]
},
{
"parameters": {},
"id": "ef90bf11-1522-48c7-969c-7807ae04557a",
"name": "No Operation, do nothing6",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
380,
2080
]
},
{
"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": "b7e4874c-38e3-4133-b17d-b9bf1d510f18",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
400,
2480
]
},
{
"parameters": {
"options": {
"dotNotation": false
}
},
"id": "bc10cfb5-9284-4dd6-9539-4590beada66f",
"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": [
760,
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": "25473499-04a4-4a3c-b9de-9c28e72060b5",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
-260,
1460
],
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}",
"operation": "isNotEmpty"
}
]
}
},
"id": "cff97dde-55c2-41e6-a0a4-6acc6b727c6f",
"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": [
220,
1400
]
},
{
"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": "4cac8c16-f95f-4873-a196-2017d53e48d3",
"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": [
1440,
680
],
"alwaysOutputData": false
},
{
"parameters": {
"jsCode": "return(\n [\n {\n \"headers\": {\n \"host\": \"n8ns.makees.site\",\n \"user-agent\": \"axios/0.21.4\",\n \"content-length\": \"167\",\n \"accept\": \"application/json,text/html,application/xhtml+xml,application/xml,text/*;q=0.9, image/*;q=0.8, */*;q=0.7\",\n \"content-type\": \"application/json\",\n \"x-forwarded-for\": \"172.18.0.1\",\n \"x-forwarded-host\": \"n8ns.makees.site\",\n \"x-forwarded-port\": \"443\",\n \"x-forwarded-proto\": \"https\",\n \"x-forwarded-server\": \"e8109027b64a\",\n \"x-real-ip\": \"172.18.0.1\",\n \"accept-encoding\": \"gzip\"\n },\n \"params\": {},\n \"query\": {},\n \"body\": {\n \"processID\": \"ZsTest\",\n \"main_tableID\": \"1E2_AUgkcpy0BrVZotmTyCH2Uy8ShDSkNZCpCddFwL-A\",\n \"main_pageID\": 1600679549,\n \"url_become\": \"https://n8ns.makees.site/webhook-waiting/23\"\n }\n }\n]\n);"
},
"id": "56e37a43-1987-471f-81d1-857b18e17fe0",
"name": "Code",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-900,
1440
],
"disabled": true
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "93c9b514-0355-41da-b45d-21abf1623ea8",
"name": "\u0421\u0417\u041f\u0426",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1600,
1560
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "f4855e1d-cb24-4f27-96e7-eee225f356c0",
"name": "\u0421\u0417\u041f\u04262",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
320,
1780
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"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,
"removed": 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": "0e6c2a29-9e14-42aa-ab81-4cedc3495065",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4,
"position": [
1720,
800
],
"alwaysOutputData": true,
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"filePath": "=root/n8n/{{ $json.processID }}.json"
},
"id": "ef9b5369-2e55-4276-b206-f2547d67ad70",
"name": "\u0427\u0442\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0441\u0435\u0433\u043e \u0444\u0430\u0439\u043b\u0430 \u0432 JsonDatabase3",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
-680,
1120
]
},
{
"parameters": {
"operation": "concatenateItems",
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "data.traks.BP_traks"
}
]
},
"options": {}
},
"id": "c64dfa8e-f31e-482d-8b43-4e9ec0eb5991",
"name": "Item Lists1",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3.1,
"position": [
-380,
1040
]
},
{
"parameters": {},
"id": "ef906414-f4c5-42e1-8159-997f36e5d2a5",
"name": "Merge2",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
0,
1140
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "traks",
"type": "arrayValue",
"arrayValue": "={{ $json['[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]'][0].traks }}"
}
]
},
"include": "none",
"options": {}
},
"id": "ad959aa8-8d1c-4b9d-8bb4-3d1cf166b8e5",
"name": "Edit Fields3",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
-220,
700
]
},
{
"parameters": {
"operation": "concatenateItems",
"aggregate": "aggregateAllItemData",
"destinationFieldName": "={{ $json.traks }}",
"options": {}
},
"id": "1d3942c0-e8a0-4f9d-97ea-a4b0c8e173f7",
"name": "\u041e\u0431\u044a\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0432\u0441\u0435 \u0442\u0440\u0435\u043a\u0438 \u0432 \u043e\u0434\u0438\u043d \u043c\u0430\u0441\u0441\u0438\u04321",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3,
"position": [
-440,
700
]
},
{
"parameters": {
"fieldToSplitOut": "traks",
"options": {}
},
"id": "d53f0401-7ada-4020-b96a-20461ecefb87",
"name": "AllTr",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3.1,
"position": [
-40,
700
]
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value1": true
}
]
}
},
"id": "6db6480e-0cef-4b0a-872a-a3a9e9dd3b79",
"name": "IF",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
140,
1080
]
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.page }}",
"operation": "equal",
"value2": "={{ $('\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b').item.json.\u0421\u0442\u0440\u0430\u043d\u0438\u0446\u0430 }}"
}
]
}
},
"id": "4baa4017-b6ff-4570-b544-d948bc6a77be",
"name": "\u0423\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435 \u0441\u0442\u0440\u043e\u043a\u04381",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1040,
1140
],
"alwaysOutputData": true
},
{
"parameters": {
"fields": {
"values": [
{
"name": "traks",
"type": "arrayValue",
"arrayValue": "={{ $('Edit Fields3').first().json.traks }}"
}
]
},
"include": "none",
"options": {}
},
"id": "7a2e8dde-285a-456f-9c53-51b5357d964a",
"name": "Edit Fields4",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
600,
900
]
},
{
"parameters": {
"fieldToSplitOut": "traks",
"options": {}
},
"id": "cfc01fe3-e3c7-498b-aee9-47eb97a82824",
"name": "AllTr1",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3.1,
"position": [
1000,
900
]
},
{
"parameters": {
"operation": "opWrite",
"queryPath": "checkProcess.Traks",
"sourceType": "sourceTypeJson",
"sourceData": "={{ JSON.stringify($json.data) }}",
"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": "bd23bb8e-605a-48af-929c-bf333d10da34",
"name": "\u0417\u0430\u043f\u0438\u0441\u044c \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 traks",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
2660,
1020
]
},
{
"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": "2efb7f20-7bf1-4737-88d0-7dc78df91b3b",
"name": "\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": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
600,
1780
]
},
{
"parameters": {},
"id": "6d033db5-1a4d-4456-b783-4b0277d4214d",
"name": "\u0421\u043e\u0435\u0434\u0438\u043d\u044f\u0435\u043c \u0438\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0442\u0440\u0435\u043a\u0438 \u0441 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c\u0438",
"type": "n8n-nodes-base.merge",
"typeVersion": 2.1,
"position": [
1920,
1020
]
},
{
"parameters": {
"fieldToSplitOut": "data",
"options": {}
},
"id": "b4a63343-cc2f-49d7-9d13-1bc951a76e0c",
"name": "\u0420\u0430\u0441\u043f\u0430\u043a\u043e\u0432\u044b\u0432\u0430\u0435\u043c \u043c\u0430\u0441\u0441\u0438\u0432 \u0441 \u0442\u0440\u0435\u043a\u0430\u043c\u0438",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3,
"position": [
2260,
1140
],
"alwaysOutputData": true
},
{
"parameters": {
"queryPath": "checkProcess.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": "fdbfb75c-f3b2-45b4-84fc-784c629e6b4f",
"name": "\u041f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u043e\u0431\u0440\u0430\u043d\u043d\u044b\u0435 \u0442\u0440\u0435\u043a\u0438 BP \u0438\u0437 JSON",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
2080,
1140
]
},
{
"parameters": {
"operation": "concatenateItems",
"aggregate": "aggregateAllItemData",
"options": {}
},
"id": "7d3a5433-9391-40c3-93ea-b0e6f4ea8627",
"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\u04323",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 3,
"position": [
2440,
1020
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "0e8773a6-830b-4358-b761-3d0fe6f0f13b",
"name": "\u0421\u0417\u041f\u04265",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1700,
1200
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value1": true
}
]
}
},
"id": "4e095976-841d-4d90-ae8f-ec5d445c30c3",
"name": "IF1",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
2860,
1180
]
},
{
"parameters": {
"fields": {
"values": [
{
"name": "\u0442\u0440\u0435\u043a",
"stringValue": "={{ $json.\u0442\u0440\u0435\u043a }}"
},
{
"name": "\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441",
"stringValue": "={{ $json['\u0410\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441'] }}"
},
{
"name": "\u0438\u043d\u0434\u0435\u043a\u0441",
"stringValue": "={{ $json.\u0418\u043d\u0434\u0435\u043a\u0441 }}"
},
{
"name": "row",
"type": "numberValue",
"numberValue": "={{ $json.row_number }}"
},
{
"name": "=\u0442\u0430\u0431\u043b\u0438\u0446\u0430",
"stringValue": "={{ $('\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 }}"
},
{
"name": "\u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430",
"stringValue": "={{ $('\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 }}"
}
]
},
"include": "none",
"options": {}
},
"id": "01820811-c6d7-43f9-a41c-4e32d713c4b4",
"name": "Edit Fields5",
"type": "n8n-nodes-base.set",
"typeVersion": 3.2,
"position": [
1620,
1020
]
},
{
"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": "50b6f7f7-1c0e-431a-8786-fde103a92f10",
"name": "\u041e\u0431\u043d\u0443\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 checkProcess1",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
420,
2280
]
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value1": true
}
]
}
},
"id": "19536a45-6f41-4f70-aab3-66715314a136",
"name": "IF2",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1820,
640
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "420f11d2-94d3-4d95-8f24-d79618e3cc86",
"name": "\u0421\u0417\u041f\u04266",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1280,
1560
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $input.all().length }}",
"operation": "smallerEqual",
"value2": "=1"
}
]
}
},
"id": "2e99abaf-acbb-4a1f-8180-b44efb01779e",
"name": "\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0434\u043b\u0438\u043d\u043d\u0443 \u0441\u043f\u0438\u0441\u043a\u0430(\u0438\u0441\u043a\u043b\u044e\u0447\u0430\u0435\u043c \u043f\u0443\u0441\u0442\u044b\u0435)",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
500,
1460
],
"alwaysOutputData": false
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.row_number }}",
"operation": "isEmpty"
}
],
"string": [
{
"value1": "={{ $json.\u0442\u0440\u0435\u043a }}",
"operation": "isEmpty"
},
{
"value1": "={{ $json.\u0438\u043d\u0434\u0435\u043a\u0441 }}",
"operation": "isEmpty"
},
{
"value1": "={{ $json.page }}",
"operation": "isEmpty"
},
{
"value1": "={{ $json.table }}",
"operation": "isEmpty"
}
]
}
},
"id": "f1c64a2b-6fa8-4ccc-8d73-6ff8d74ce34a",
"name": "\u041f\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u043f\u0443\u0441\u0442\u043e\u0439 \u0432\u044b\u0432\u043e\u0434",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1300,
1120
]
},
{
"parameters": {},
"id": "9a4ae5c6-7702-4f1a-9a51-68d0aefb5520",
"name": "No Operation, do nothing2",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
700,
1320
]
},
{
"parameters": {},
"id": "63f314dc-2f55-4f8e-b44b-40f24764fee0",
"name": "No Operation, do nothing3",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
1340,
1320
]
},
{
"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": "e06a6433-2cb6-46b0-87a7-e77379ab3a51",
"name": "\u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u044b\u0439 \u0441\u0442\u0430\u0442\u0443\u0441 \u043d\u0430 \u0442\u0440\u0435\u043a \u0438\u0437 \u0441\u0442\u043e\u043b\u0431\u0446\u0430 \u0442\u0440\u0435\u043a",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1520,
1280
],
"alwaysOutputData": false
},
{
"parameters": {
"mode": "jsonToBinary",
"options": {}
},
"id": "d1cad319-2d81-47c7-bb90-3fc272a40f44",
"name": "Convert to/from binary data1",
"type": "n8n-nodes-base.moveBinaryData",
"typeVersion": 1.1,
"position": [
1180,
1800
]
},
{
"parameters": {
"name": "={{ $('\u0412\u0432\u043e\u0434 id \u0441\u0442\u0430\u0442\u0438\u0447\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446').first().json.processID }}_{{ $now.toISO().slice(0,19) }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"folderId": {
"__rl": true,
"value": "1pUomJR50VhnhZf_DWVXhyvJaFDNhKzBg",
"mode": "list",
"cachedResultName": "n8n.online_jsonHistory",
"cachedResultUrl": "https://drive.google.com/drive/folders/1pUomJR50VhnhZf_DWVXhyvJaFDNhKzBg"
},
"options": {}
},
"id": "4ebf3124-8d6e-49bd-941f-78d531c7bf6c",
"name": "Google Drive1",
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
1380,
1800
],
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"queryPath": "checkProcess.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": "c562d67a-0403-414c-ad15-b0e2ac81dc07",
"name": "\u041f\u043e\u0434\u0442\u044f\u0433\u0438\u0432\u0430\u0435\u043c \u0432\u0441\u0435 \u0441\u043e\u0431\u0440\u0430\u043d\u043d\u044b\u0435 \u0442\u0440\u0435\u043a\u0438 BP \u0438\u0437 JSON1",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
"typeVersion": 1,
"position": [
980,
1800
]
},
{
"parameters": {
"conditions": {
"boolean": [
{
"value1": true
}
]
}
},
"id": "11dbf78e-85d1-4164-8369-a06514e65d65",
"name": "IF3",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1380,
2060
]
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.data.checkProcess.Iteration }}",
"operation": "notEqual"
}
]
}
},
"id": "49a9cdd2-ae12-4658-904c-f24494485297",
"name": "IF4",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
600,
2020
]
},
{
"parameters": {
"keepOnlySet": true,
"options": {
"dotNotation": false
}
},
"id": "6205856b-70f0-4254-a52c-f92fae961e03",
"name": "\u0421\u0417\u041f\u04267",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
2660,
880
],
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"url": "={{ $('main JSON').first().json.data.endPoints['\u0418\u0441\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u043c\u0430\u0445\u043e\u0432'] }}",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "recheck",
"value": "need"
},
{
"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 }}"
}
]
},
"options": {}
},
"id": "6ed6c538-e54f-4ba5-a1b3-0553bd2c68b0",
"name": "HTTP Request1",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
980,
2000
]
},
{
"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": "e21cf12f-61f9-4049-9158-a944192ffa92",
"name": "\u0421\u0442\u0430\u0432\u0438\u043c 1 \u0432 CcheckProcess.iterstion",
"type": "@n-octo-n/n8n-nodes-json-database.JsonDatabase",
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleDriveOAuth2ApigoogleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Source: https://github.com/makees-by/n8ns/blob/9ecc9ce03dd07ad3f21456f95d3ecba945139578/workflowPCN.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.
TrackCollect. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, moveBinaryData. Webhook trigger; 31 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +2
The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet
Google Sheets, Google Drive, HTTP Request
🔥 March Sale – n8n Community Members Get ideoGener8r for Just $27! (Reg. $47) Use Coupon Code: (Valid until 3/31/2025 for n8n community members)
HTTP Request, Google Drive, Google Sheets
📄 Documentation: Notion Guide
Google Sheets, Google Drive, HTTP Request +2
Overview
Google Sheets, Google Drive, HTTP Request