{
  "name": "Pull new backlinks into Google Sheets with DataForSEO and Gmail email report",
  "nodes": [
    {
      "id": "6eb9056e-89d7-4662-ae20-b95a94dae4c3",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        -128
      ],
      "parameters": {
        "width": 1120,
        "height": 352,
        "content": "## Get new backlinks with DataForSEO\nCreate a DataForSEO connection, specify a Target Domain, and set up additional parameters if needed."
      }
    },
    {
      "id": "1a948938-98bc-43d2-9ad2-96919090c382",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -384,
        48
      ]
    },
    {
      "id": "0208977d-a647-4e3a-820c-4374898dae99",
      "name": "Create spreadsheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -368,
        512
      ]
    },
    {
      "id": "e1cb44b8-35d5-4a06-9fdf-2dd03fbe324b",
      "name": "Append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        976,
        512
      ]
    },
    {
      "id": "5efea612-1094-429d-9bf4-960678cbc40b",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1200,
        512
      ]
    },
    {
      "id": "c171439f-f390-4546-88ab-f14d31f412c4",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1408,
        512
      ]
    },
    {
      "id": "5b6e819f-7609-466b-9700-e2e167f617ac",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -624,
        320
      ],
      "parameters": {
        "width": 2160,
        "height": 384,
        "content": "## Create a Google Sheet with new backlinks and send it via email\nCreate a Google Sheets connection.\nCreate a Gmail connection and set a receiver."
      }
    },
    {
      "id": "761070c8-362b-4262-9ac0-8f3b6ae00c00",
      "name": "Initialize \"items\" field",
      "type": "n8n-nodes-base.set",
      "position": [
        -160,
        48
      ]
    },
    {
      "id": "3f805fb6-3529-475a-b7b5-176b52eb841e",
      "name": "Set \"items\" field",
      "type": "n8n-nodes-base.set",
      "position": [
        64,
        48
      ]
    },
    {
      "id": "e39fc8f1-2118-40bb-b364-6d427c55a8ad",
      "name": "Get new backlinks",
      "type": "n8n-nodes-dataforseo.dataForSeoBacklinksApi",
      "position": [
        288,
        -32
      ]
    },
    {
      "id": "54061afe-abd8-4f72-a3f1-a3ba70ae1fca",
      "name": "Merge \"items\" with DFS response",
      "type": "n8n-nodes-base.set",
      "position": [
        512,
        -32
      ]
    },
    {
      "id": "40c3e866-9d94-4880-826b-36f56995680d",
      "name": "Has more pages?",
      "type": "n8n-nodes-base.if",
      "position": [
        736,
        48
      ]
    },
    {
      "id": "92bd880e-3ba4-4e8b-87c8-ce545ca075ea",
      "name": "Filter (has new backlinks)",
      "type": "n8n-nodes-base.filter",
      "position": [
        -592,
        512
      ]
    },
    {
      "id": "2a10e79f-f4be-4af3-bf80-5a8d23090667",
      "name": "Append columns",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        80,
        512
      ]
    },
    {
      "id": "84ed3b69-21f6-4253-b1ad-f2157b664bdf",
      "name": "Set final \"items\" field",
      "type": "n8n-nodes-base.set",
      "position": [
        304,
        512
      ]
    },
    {
      "id": "909015f2-a75e-4f20-baa6-f4f3c286dd72",
      "name": "Split out items",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        528,
        512
      ]
    },
    {
      "id": "b9a7e47a-8f84-4233-9c4f-1cb85ed31a0e",
      "name": "Prepare data for Google Sheets",
      "type": "n8n-nodes-base.set",
      "position": [
        752,
        512
      ]
    },
    {
      "id": "e33bb7a2-1920-46cf-ab2a-3ab0dd787b0f",
      "name": "Prepage columns for Google Sheets",
      "type": "n8n-nodes-base.set",
      "position": [
        -144,
        512
      ]
    },
    {
      "id": "c5a50579-d94d-4a21-b706-bee6e5dee2d0",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1120,
        -112
      ],
      "parameters": {
        "width": 432,
        "height": 544,
        "content": "This workflow runs once per day and uses the DataForSEO Backlinks API to automatically retrieve newly detected backlinks for your domain or specific URL. Each daily report includes important backlink "
      }
    }
  ],
  "connections": {
    "Aggregate": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append columns": {
      "main": [
        [
          {
            "node": "Set final \"items\" field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Has more pages?": {
      "main": [
        [
          {
            "node": "Set \"items\" field",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Filter (has new backlinks)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split out items": {
      "main": [
        [
          {
            "node": "Prepare data for Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Initialize \"items\" field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get new backlinks": {
      "main": [
        [
          {
            "node": "Merge \"items\" with DFS response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set \"items\" field": {
      "main": [
        [
          {
            "node": "Get new backlinks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create spreadsheet": {
      "main": [
        [
          {
            "node": "Prepage columns for Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append row in sheet": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set final \"items\" field": {
      "main": [
        [
          {
            "node": "Split out items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Initialize \"items\" field": {
      "main": [
        [
          {
            "node": "Set \"items\" field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter (has new backlinks)": {
      "main": [
        [
          {
            "node": "Create spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare data for Google Sheets": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge \"items\" with DFS response": {
      "main": [
        [
          {
            "node": "Has more pages?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepage columns for Google Sheets": {
      "main": [
        [
          {
            "node": "Append columns",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}