{ "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" }
