{ "edges": [ { "to": "2228f42d-03a3-468e-aa70-585b39516b7e", "from": "524ac1d6-6b27-41de-a8c1-4af416c098d8", "toPort": "0", "fromPort": "0" }, { "to": "9c02c042-6c95-4942-84af-3ba19ca72439", "from": "40f28904-5973-4b9a-bc25-c9778ecddb2e", "toPort": "0", "fromPort": "0" }, { "to": "56f9f2c5-91e6-4667-86f5-12026c52668e", "from": "d3248755-6b76-4a86-9505-5ef6d9e5febb", "toPort": "0", "fromPort": "0" }, { "to": "6a03f798-1a64-46bf-b037-06173fbe4999", "from": "d3248755-6b76-4a86-9505-5ef6d9e5febb", "toPort": "0", "fromPort": "1" }, { "to": "fd6e2c7c-b6f8-4c0a-94c8-49149708c272", "from": "65056f6a-d5c3-4c76-bcb2-23d8ec744423", "toPort": "0", "fromPort": "0" }, { "to": "01249746-9d41-410b-aa1f-f33038201f12", "from": "bb54ec0f-e627-4784-85e0-0cb87178ced4", "toPort": "0", "fromPort": "0" }, { "to": "2b0d9190-f707-4d17-a1ed-6bcdf257fd95", "from": "56f9f2c5-91e6-4667-86f5-12026c52668e", "toPort": "0", "fromPort": "0" }, { "to": "e3aad525-4606-4c5f-a826-cd740ea1c7a6", "from": "8f267be2-484a-4275-8079-f7036d8c877c", "toPort": "0", "fromPort": "0" }, { "to": "302d0a5e-7082-4af3-88f3-c49bfdc8ca8a", "from": "2b0d9190-f707-4d17-a1ed-6bcdf257fd95", "toPort": "0", "fromPort": "0" }, { "to": "524ac1d6-6b27-41de-a8c1-4af416c098d8", "from": "775afb58-5971-4482-8fda-c9fbd732622d", "toPort": "0", "fromPort": "0" }, { "to": "65056f6a-d5c3-4c76-bcb2-23d8ec744423", "from": "9c02c042-6c95-4942-84af-3ba19ca72439", "toPort": "0", "fromPort": "0" }, { "to": "56f9f2c5-91e6-4667-86f5-12026c52668e", "from": "01249746-9d41-410b-aa1f-f33038201f12", "toPort": "0", "fromPort": "0" }, { "to": "8f267be2-484a-4275-8079-f7036d8c877c", "from": "6a03f798-1a64-46bf-b037-06173fbe4999", "toPort": "0", "fromPort": "0" }, { "to": "775afb58-5971-4482-8fda-c9fbd732622d", "from": "fd6e2c7c-b6f8-4c0a-94c8-49149708c272", "toPort": "0", "fromPort": "0" }, { "to": "d3248755-6b76-4a86-9505-5ef6d9e5febb", "from": "302d0a5e-7082-4af3-88f3-c49bfdc8ca8a", "toPort": "0", "fromPort": "0" }, { "to": "40f28904-5973-4b9a-bc25-c9778ecddb2e", "from": "e3aad525-4606-4c5f-a826-cd740ea1c7a6", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "01249746-9d41-410b-aa1f-f33038201f12", "name": "Initialize \"items\" field", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "0126c659-03a5-4fc8-bd76-62d2ecea1195", "name": "items", "type": "array", "value": "={{ [] }}" } ] } }, "position": [ 128, 624 ] }, { "id": "302d0a5e-7082-4af3-88f3-c49bfdc8ca8a", "name": "Merge \"items\" with DFS response", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "ddd82419-e43e-44d8-919c-2d6602704da5", "name": "items", "type": "array", "value": "={{ [ ...$('Set \"items\" field').item.json.items, ...$json.tasks[0].result[0].items] }}" } ] } }, "position": [ 800, 544 ] }, { "id": "d3248755-6b76-4a86-9505-5ef6d9e5febb", "name": "Has more pages?", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "cd5943f7-df0b-4329-8436-9a1af3ec7caf", "operator": { "type": "number", "operation": "lt" }, "leftValue": "={{ $runIndex }}", "rightValue": "={{ $('Get lost backlinks').item.json.tasks[0].result[0].total_count / 1000 - 1}}" }, { "id": "9cd8ede8-c09a-4cbc-8050-5d23989ee07e", "operator": { "type": "number", "operation": "lt" }, "leftValue": "={{ $runIndex }}", "rightValue": 5 } ] } }, "position": [ 1024, 624 ] }, { "id": "6a03f798-1a64-46bf-b037-06173fbe4999", "name": "Filter (has new backlinks)", "type": "passthrough", "params": { "mode": "filter", "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "648f4d1e-367c-41b2-b223-1363dadc2cc8", "operator": { "type": "number", "operation": "gt" }, "leftValue": "={{ $('Get lost backlinks').item.json.tasks[0].result[0].total_count }}", "rightValue": 0 } ] } }, "position": [ -304, 1088 ] }, { "id": "40f28904-5973-4b9a-bc25-c9778ecddb2e", "name": "Append columns", "type": "integration", "params": { "columns": { "value": {}, "schema": [], "mappingMode": "autoMapInputData", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "id", "value": "={{ $('Create spreadsheet').item.json.sheets[0].properties.sheetId }}" }, "documentId": { "__rl": true, "mode": "id", "value": "={{ $('Create spreadsheet').item.json.spreadsheetId }}" } }, "position": [ 368, 1088 ] }, { "id": "9c02c042-6c95-4942-84af-3ba19ca72439", "name": "Set final \"items\" field", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "1e2c8353-5628-4948-abe6-35f8d0f660a5", "name": "items", "type": "array", "value": "={{ [...$('Set \"items\" field').item.json.items, ... $('Get lost backlinks').item.json.tasks[0].result[0].items]}}" } ] } }, "position": [ 592, 1088 ] }, { "id": "65056f6a-d5c3-4c76-bcb2-23d8ec744423", "name": "Split out items", "type": "passthrough", "params": { "mode": "splitOut", "field": "items", "options": {}, "fieldToSplitOut": "items" }, "position": [ 816, 1088 ] }, { "id": "2b0d9190-f707-4d17-a1ed-6bcdf257fd95", "name": "Get lost backlinks", "type": "integration", "params": { "limit": 1000, "offset": "={{ $runIndex * 1000 }}", "target": "=dataforseo.com", "filters": "=[\"last_seen\", \">\", \"{{ $now.minus(1, \"days\").format(\"yyyy-MM-dd\") }}\"]", "service": "dataforseobacklinksapi", "operation": "get-backlinks", "__originalType": "n8n-nodes-dataforseo.dataForSeoBacklinksApi", "include_indirect_links": false }, "position": [ 576, 544 ] }, { "id": "56f9f2c5-91e6-4667-86f5-12026c52668e", "name": "Set \"items\" field", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "4b3c95a2-4e38-4e37-8e2f-a7e4544808d6", "name": "items", "type": "array", "value": "={{ $json.items }}" } ] } }, "position": [ 352, 624 ] }, { "id": "8f267be2-484a-4275-8079-f7036d8c877c", "name": "Create spreadsheet", "type": "integration", "params": { "title": "=Lost Backlinks to {{ $('Get lost backlinks').item.json.tasks[0].data.target }} - {{ $now.format(\"yyyy-MM-dd\") }}", "options": {}, "service": "googleSheets", "resource": "spreadsheet", "sheetsUi": { "sheetValues": [ { "title": "Lost Backlinks" } ] }, "operation": "read" }, "position": [ -80, 1088 ] }, { "id": "775afb58-5971-4482-8fda-c9fbd732622d", "name": "Append row in sheet", "type": "integration", "params": { "columns": { "value": {}, "schema": [ { "id": "Date", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Target", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Target", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Backlink", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Backlink", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Spam Score", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Spam Score", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Backlink Rank", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Backlink Rank", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Domain from", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Domain from", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Domain from Rank", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Domain from Rank", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "URL from", "type": "string", "display": true, "removed": false, "required": false, "displayName": "URL from", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "URL from Rank", "type": "string", "display": true, "removed": false, "required": false, "displayName": "URL from Rank", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Backlink Is Broken", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Backlink Is Broken", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Backlinks Is Dofollow", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Backlinks Is Dofollow", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "autoMapInputData", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "id", "value": "={{ $('Create spreadsheet').item.json.sheets[0].properties.sheetId }}" }, "documentId": { "__rl": true, "mode": "id", "value": "={{ $('Create spreadsheet').item.json.spreadsheetId }}" } }, "position": [ 1264, 1088 ] }, { "id": "2228f42d-03a3-468e-aa70-585b39516b7e", "name": "Send a message", "type": "integration", "params": { "sendTo": "user@example.com", "message": "=

Here is your daily lost backlinks report for {{ $('Get lost backlinks').item.json.tasks[0].data.target }}.

During the past day, we identified {{ $('Get lost backlinks').item.json.tasks[0].result[0].total_count }} backlinks.

You can review the full list here: Lost Backlinks to {{ $('Get lost backlinks').item.json.tasks[0].data.target }} - {{ $now.format(\"yyyy-MM-dd\") }} ", "options": {}, "service": "gmail", "subject": "=Lost Backlinks to {{ $('Get lost backlinks').item.json.tasks[0].data.target }} - {{ $now.format(\"yyyy-MM-dd\") }}", "operation": "read" }, "position": [ 1696, 1088 ] }, { "id": "bb54ec0f-e627-4784-85e0-0cb87178ced4", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 9 } ] } }, "position": [ -96, 624 ] }, { "id": "524ac1d6-6b27-41de-a8c1-4af416c098d8", "name": "Aggregate", "type": "passthrough", "params": { "mode": "aggregate", "options": {}, "aggregate": "aggregateAllItemData" }, "position": [ 1488, 1088 ] }, { "id": "e3aad525-4606-4c5f-a826-cd740ea1c7a6", "name": "Prepare columns for Google Sheets", "type": "set", "params": { "mode": "raw", "options": {}, "jsonOutput": "{\n \"Date\": \"\",\n \"Target\": \"\",\n \"Backlink\": \"\",\n \"Spam Score\": \"\",\n \"Backlink Rank\": \"\",\n \"Domain from\": \"\",\n \"Domain from Rank\": \"\",\n \"URL from\": \"\",\n \"URL from Rank\": \"\",\n \"Backlink Is Broken\":\"\",\n \"Backlinks Is Dofollow\":\"\"\n}\n" }, "position": [ 144, 1088 ] }, { "id": "fd6e2c7c-b6f8-4c0a-94c8-49149708c272", "name": "Prepare data for Google Sheets", "type": "set", "params": { "mode": "raw", "options": {}, "jsonOutput": "={\n \"Date\": \"{{ $now.format('yyyy-MM-dd') }}\",\n \"Target\": \"{{ $('Get lost backlinks').item.json.tasks[0].data.target }}\",\n \"Backlink\": \" {{ $json.url_to }}\",\n \"Spam Score\": \"{{ $json.backlink_spam_score }}\",\n \"Backlink Rank\": \"{{ $json.rank }}\",\n \"Domain from\": \"{{ $json.domain_from }}\",\n \"Domain from Rank\": \"{{ $json.domain_from_rank }}\",\n \"URL from\": \"{{ $json.url_from }}\",\n \"URL from Rank\": \"{{ $json.page_from_rank }}\",\n \"Backlink Is Broken\":\"{{ $json.is_broken }}\",\n \"Backlinks Is Dofollow\":\"{{ $json.dofollow }}\"\n}" }, "position": [ 1040, 1088 ] } ] }

Monitor lost backlinks with DataForSEO, Google Sheets and Gmail