{
"active": true,
"connections": {
"Read Keywords": {
"main": [
[
{
"node": "EmptyParamCheck",
"type": "main",
"index": 0
}
]
]
},
"Create New Sheets": {
"main": [
[
{
"node": "IF1",
"type": "main",
"index": 0
}
]
]
},
"Add Key Row to Sheets": {
"main": [
[
{
"node": "IF no more batches1",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Read Keywords",
"type": "main",
"index": 0
}
]
]
},
"SplitInBatches": {
"main": [
[
{
"node": "Add Key Row to Sheets",
"type": "main",
"index": 0
}
]
]
},
"IF1": {
"main": [
[
{
"node": "Function",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 0
},
{
"node": "IF2",
"type": "main",
"index": 0
}
]
]
},
"IF": {
"main": [
[],
[
{
"node": "Key : Value Matching1",
"type": "main",
"index": 0
}
]
]
},
"Key : Value Matching1": {
"main": [
[
{
"node": "Add Data ",
"type": "main",
"index": 0
}
]
]
},
"EmptyParamCheck": {
"main": [
[
{
"node": "Create New Sheets",
"type": "main",
"index": 0
}
]
]
},
"Function": {
"main": [
[
{
"node": "SplitInBatches",
"type": "main",
"index": 0
}
]
]
},
"IF no more batches1": {
"main": [
[
{
"node": "IF3",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 1
}
],
[
{
"node": "SplitInBatches",
"type": "main",
"index": 0
}
]
]
},
"Item Lists4": {
"main": [
[
{
"node": "Key : Value Matching2",
"type": "main",
"index": 0
}
]
]
},
"Key : Value Matching2": {
"main": [
[
{
"node": "Add Data 2",
"type": "main",
"index": 0
}
]
]
},
"Add Data 2": {
"main": [
[
{
"node": "SplitInBatches1",
"type": "main",
"index": 0
}
]
]
},
"Split up1": {
"main": [
[
{
"node": "SplitInBatches2",
"type": "main",
"index": 0
}
]
]
},
"Item Lists": {
"main": [
[
{
"node": "Item Lists4",
"type": "main",
"index": 0
}
]
]
},
"SplitInBatches1": {
"main": [
[
{
"node": "Item Lists",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Date",
"type": "main",
"index": 0
},
{
"node": "API Request",
"type": "main",
"index": 0
},
{
"node": "PixelSERP",
"type": "main",
"index": 0
}
]
]
},
"IF2": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"IF3": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"PixelSERP": {
"main": [
[
{
"node": "SplitInBatches1",
"type": "main",
"index": 0
}
]
]
},
"API Request": {
"main": [
[]
]
},
"Item Lists5": {
"main": [
[
{
"node": "Key : Value Matching",
"type": "main",
"index": 0
}
]
]
},
"Key : Value Matching": {
"main": [
[
{
"node": "Add Data 3",
"type": "main",
"index": 0
}
]
]
},
"Add Data 3": {
"main": [
[
{
"node": "SplitInBatches2",
"type": "main",
"index": 0
}
]
]
},
"Item Lists1": {
"main": [
[
{
"node": "Item Lists5",
"type": "main",
"index": 0
}
]
]
},
"SplitInBatches2": {
"main": [
[
{
"node": "Item Lists1",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2022-03-01T13:02:13.287Z",
"id": "2",
"name": "Multiple",
"nodes": [
{
"parameters": {},
"name": "Start",
"type": "n8n-nodes-base.start",
"typeVersion": 1,
"position": [
240,
300
]
},
{
"parameters": {
"authentication": "oAuth2",
"sheetId": "={{$node[\"Webhook\"].json[\"headers\"][\"sheetid\"]}}",
"range": "A:C",
"options": {}
},
"name": "Read Keywords",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
660,
300
],
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"authentication": "oAuth2",
"operation": "create",
"sheetId": "={{$item(0).$node[\"Webhook\"].json[\"headers\"][\"sheetid\"]}}",
"options": {
"tabColor": "#C4002A",
"title": "={{$json[\"Keyword\"]}}"
}
},
"name": "Create New Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
1060,
300
],
"retryOnFail": false,
"notesInFlow": false,
"maxTries": 3,
"waitBetweenTries": 500,
"alwaysOutputData": false,
"executeOnce": false,
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Google Sheets account"
}
},
"continueOnFail": true
},
{
"parameters": {
"authentication": "oAuth2",
"operation": "update",
"sheetId": "={{$item(0).$node[\"Webhook\"].json[\"headers\"][\"sheetid\"]}}",
"range": "={{$json[\"title\"] }}!A1:G1",
"rawData": true,
"options": {}
},
"name": "Add Key Row to Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
1060,
500
],
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"path": "4d0720e1-9c47-4528-8fa8-9d4f63a51f70",
"options": {}
},
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
440,
300
],
"webhookId": "4d0720e1-9c47-4528-8fa8-9d4f63a51f70"
},
{
"parameters": {
"batchSize": 1,
"options": {}
},
"name": "SplitInBatches",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 1,
"position": [
860,
500
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{$json[\"error\"]}}",
"operation": "notEqual",
"value2": "Bad request - please check your parameters"
}
]
}
},
"name": "IF1",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1260,
300
],
"alwaysOutputData": false
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{$node[\"SplitInBatches1\"].json[\"searchSuggestions\"][\"footer\"][0]}}",
"operation": "isEmpty"
}
]
}
},
"name": "IF",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
2560,
880
]
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"string": [
{
"name": "URL",
"value": "There Was a"
},
{
"name": "Domain",
"value": "Problem With"
},
{
"name": "Title",
"value": "Request!!!"
},
{
"name": "Description",
"value": "Please Delete The Sheet and Try Again."
}
],
"number": [
{
"name": "Type"
},
{
"name": "Position",
"value": 404
}
]
},
"options": {}
},
"name": "Key : Value Matching1",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
2700,
880
],
"continueOnFail": true
},
{
"parameters": {
"authentication": "oAuth2",
"operation": "append",
"sheetId": "={{$node[\"Webhook\"].json[\"headers\"][\"sheetid\"]}}",
"range": "={{$node[\"SplitInBatches1\"].json[\"title\"]}}!A:F",
"options": {}
},
"name": "Add Data ",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
2840,
880
],
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Google Sheets account"
}
},
"continueOnFail": true
},
{
"parameters": {
"functionCode": "for (item of items) {\n console.log(item.json.Language)\n if (item.json.Language === '' || item.json.Language == null){\n item.json.Language = \"en\"\n }\n if(item.json.Location === '' || item.json.Location == null){\n item.json.Location = \"gb\"\n }\n}\n\nreturn items;"
},
"name": "EmptyParamCheck",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
860,
300
]
},
{
"parameters": {
"functionCode": "for (item of items) {\n item.json.data = \n [\n [\n \"Position\",\n \"Type\",\n \"URL\",\n \"Domain\",\n \"Title\",\n \"Description\",\n \"Date\"\n ]\n ] \n}\n\nreturn items;"
},
"name": "Function",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
660,
500
]
},
{
"parameters": {
"conditions": {
"number": [],
"boolean": [
{
"value1": "={{$node[\"SplitInBatches\"].context[\"noItemsLeft\"]}}",
"value2": true
}
]
}
},
"name": "IF no more batches1",
"type": "n8n-nodes-base.if",
"position": [
1260,
500
],
"typeVersion": 1
},
{
"parameters": {
"operation": "limit",
"maxItems": "={{$node[\"Webhook\"].json[\"headers\"][\"searchlength\"]}}"
},
"name": "Item Lists4",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 1,
"position": [
2980,
400
]
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"string": [
{
"name": "URL",
"value": "={{$json[\"link\"][\"url\"]}}"
},
{
"name": "Domain",
"value": "={{$json[\"link\"][\"visibleText\"]}}"
},
{
"name": "Title",
"value": "={{$json[\"title\"]}}"
},
{
"name": "Description",
"value": "={{$node[\"API Request1\"].json[\"results\"][1][\"description\"]}}"
},
{
"name": "Date",
"value": "={{$node[\"Date\"].json[\"requestDate\"]}}"
}
],
"number": [
{
"name": "Type",
"value": "={{$json[\"type\"]}}"
},
{
"name": "Position",
"value": "={{$json[\"order\"]}}"
}
]
},
"options": {}
},
"name": "Key : Value Matching2",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
3200,
400
],
"continueOnFail": true
},
{
"parameters": {
"authentication": "oAuth2",
"operation": "append",
"sheetId": "={{$node[\"Webhook\"].json[\"headers\"][\"sheetid\"]}}",
"range": "={{$node[\"SplitInBatches1\"].json[\"searchSuggestions\"][\"footer\"][0]}}!A:G",
"options": {}
},
"name": "Add Data 2",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
3400,
400
],
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Google Sheets account"
}
},
"continueOnFail": true
},
{
"parameters": {
"functionCode": "const newItems = [];\nfor (const item of items[0].json) {\n newItems.push({json: item});\n}\nreturn newItems;"
},
"name": "Split up1",
"type": "n8n-nodes-base.function",
"position": [
2340,
600
],
"typeVersion": 1
},
{
"parameters": {
"fieldToSplitOut": "results",
"options": {}
},
"name": "Item Lists",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 1,
"position": [
2760,
400
],
"continueOnFail": true
},
{
"parameters": {
"batchSize": 1,
"options": {}
},
"name": "SplitInBatches1",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 1,
"position": [
2540,
400
]
},
{
"parameters": {},
"name": "Merge",
"type": "n8n-nodes-base.merge",
"typeVersion": 1,
"position": [
1940,
400
],
"executeOnce": true
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{$items(\"Read Keywords\").length}}",
"operation": "equal",
"value2": "={{$items().length}}"
}
]
}
},
"name": "IF2",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1540,
240
]
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{$items(\"Read Keywords\").length}}",
"operation": "equal",
"value2": "={{$items(\"Function\").length}}"
}
]
}
},
"name": "IF3",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1540,
540
]
},
{
"parameters": {
"functionCode": "var nowDate = new Date().toLocaleString('tr-TR', { timeZone: 'Turkey' })\n\n//items[0].json.requestDate = nowDate;\n\nitems.unshift({json : {requestDate : nowDate}})\n\n\nreturn items;"
},
"name": "Date",
"type": "n8n-nodes-base.function",
"position": [
2140,
200
],
"typeVersion": 1,
"executeOnce": true
},
{
"parameters": {
"url": "http://141.95.102.63:8080/api/pixelserp/output/",
"options": {},
"headerParametersUi": {
"parameter": [
{
"name": "sheetId",
"value": "={{$node[\"Webhook\"].json[\"headers\"][\"sheetid\"]}}"
}
]
},
"queryParametersUi": {
"parameter": []
}
},
"name": "API Request",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
2140,
600
],
"executeOnce": true,
"retryOnFail": true
},
{
"parameters": {
"keywords": "fake",
"additionalFields": {}
},
"name": "PixelSERP",
"type": "n8n-nodes-base.pixelSERP",
"typeVersion": 1,
"position": [
2140,
400
],
"credentials": {
"pixelSERPApi": {
"id": "1",
"name": "PixelSERP account"
}
}
},
{
"parameters": {
"operation": "limit",
"maxItems": "={{$node[\"Webhook\"].json[\"headers\"][\"searchlength\"]}}"
},
"name": "Item Lists5",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 1,
"position": [
2980,
600
]
},
{
"parameters": {
"keepOnlySet": true,
"values": {
"string": [
{
"name": "URL",
"value": "={{$json[\"link\"][\"url\"]}}"
},
{
"name": "Domain",
"value": "={{$json[\"link\"][\"visibleText\"]}}"
},
{
"name": "Title",
"value": "={{$json[\"title\"]}}"
},
{
"name": "Description",
"value": "={{$node[\"API Request1\"].json[\"results\"][1][\"description\"]}}"
},
{
"name": "Date",
"value": "={{$node[\"Date\"].json[\"requestDate\"]}}"
}
],
"number": [
{
"name": "Type",
"value": "={{$json[\"type\"]}}"
},
{
"name": "Position",
"value": "={{$json[\"order\"]}}"
}
]
},
"options": {}
},
"name": "Key : Value Matching",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
3200,
600
],
"continueOnFail": true
},
{
"parameters": {
"authentication": "oAuth2",
"operation": "append",
"sheetId": "={{$node[\"Webhook\"].json[\"headers\"][\"sheetid\"]}}",
"range": "={{$node[\"SplitInBatches2\"].json[\"searchSuggestions\"][\"footer\"][0]}}!A:G",
"options": {}
},
"name": "Add Data 3",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
3400,
600
],
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Google Sheets account"
}
},
"continueOnFail": true
},
{
"parameters": {
"fieldToSplitOut": "results",
"options": {}
},
"name": "Item Lists1",
"type": "n8n-nodes-base.itemLists",
"typeVersion": 1,
"position": [
2760,
600
],
"continueOnFail": true
},
{
"parameters": {
"batchSize": 1,
"options": {}
},
"name": "SplitInBatches2",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 1,
"position": [
2540,
600
]
}
],
"settings": {},
"staticData": null,
"tags": [],
"updatedAt": "2022-03-01T13:26:49.398Z"
}Workflows/Multiple
Column
Date
Mar 19, 2022 05:09 PM
Tags
地址