{
  "name": "Get new ranked Google AI Overview keywords via email with DataForSEO",
  "nodes": [
    {
      "id": "7c6a4206-8b69-477b-a268-c3cc01ef595c",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        448,
        64
      ]
    },
    {
      "id": "5d68d0af-9f00-4ccd-9e39-bd78bc109689",
      "name": "Get ranked keywords",
      "type": "n8n-nodes-dataforseo.dataForSeoLabsApi",
      "position": [
        656,
        432
      ]
    },
    {
      "id": "3f030536-2965-47e4-bc89-f4415b8af6e0",
      "name": "Get previous keywords",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        64
      ]
    },
    {
      "id": "97efbef3-7ee4-45e0-887f-0e99b23b2c02",
      "name": "Get targets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        944,
        64
      ]
    },
    {
      "id": "fbe1c1e5-1180-431d-9026-6e9fed5e6f01",
      "name": "Append keyword in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        368,
        928
      ]
    },
    {
      "id": "2a093561-3fa1-4b70-89ba-ed45f7f163d0",
      "name": "Run every Monday",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        64
      ]
    },
    {
      "id": "0098aaa3-24b4-4620-8ba5-2167bf99dccf",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        -64
      ],
      "parameters": {
        "width": 608,
        "height": 288,
        "content": "## Get previous keywords and clear the sheet\nCreate a Google Sheets connection and select the spreadsheet where keywords should be saved. The sheet must have the same columns as in [this Example](http"
      }
    },
    {
      "id": "0eee6cf4-74a6-4294-8864-614b0c911ed9",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        -64
      ],
      "parameters": {
        "width": 256,
        "height": 288,
        "content": "## Get targets\nSelect a spreadsheet with your target domains. The spreadsheet must have the same columns as in [this Example](https://docs.google.com/spreadsheets/d/1w8bTZ0hfQ0A0e-GZ3s5oDR8-lWqpepU-FJ"
      }
    },
    {
      "id": "d94a60a8-b450-4ce9-86c1-fe98879c2000",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        192,
        336
      ],
      "parameters": {
        "width": 1248,
        "height": 352,
        "content": "## Get ranked keywords from Google AIO with DataForSEO\nCreate a DataForSEO connection and set up additional parameters if needed."
      }
    },
    {
      "id": "a4e3eadb-a652-4a87-8989-e2f85e1681e0",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        752
      ],
      "parameters": {
        "width": 1296,
        "height": 336,
        "content": "## Save current ranked AIO keywords to the spreadsheet and send new keywords via Email\nSelect the same spreadsheet with your keywords as in the first Google Sheets node.\nCreate a Gmail connection and "
      }
    },
    {
      "id": "311c6b38-45b7-4e51-8034-90c0b8aeb6e4",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -544,
        48
      ],
      "parameters": {
        "width": 432,
        "height": 640,
        "content": "This workflow uses DataForSEO Labs API to automatically find new keywords your domains started ranking for in Google’s AI Overview feature, then saves those keywords into Google Sheets, and sends you "
      }
    },
    {
      "id": "9c6c15d7-c004-4e4a-ab00-bca5fe69b678",
      "name": "Aggregate1",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        592,
        928
      ]
    },
    {
      "id": "f6a6d32f-eb63-4e2f-8008-b17765afc8cc",
      "name": "Clear sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        672,
        64
      ]
    },
    {
      "id": "10fa697b-07da-4270-a0d0-8bed0f905612",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1248,
        928
      ]
    },
    {
      "id": "3254d177-f942-458e-90dc-c6c4387c9c61",
      "name": "Initialize \"items\" field",
      "type": "n8n-nodes-base.set",
      "position": [
        208,
        512
      ]
    },
    {
      "id": "8fbb6c9a-906c-4bce-a6e3-c35a028b1a2c",
      "name": "Set \"items\" field",
      "type": "n8n-nodes-base.set",
      "position": [
        432,
        512
      ]
    },
    {
      "id": "43361e8b-ebff-4fd5-85ef-56d6b249b14c",
      "name": "Merge \"items\" with DFS response",
      "type": "n8n-nodes-base.set",
      "position": [
        864,
        432
      ]
    },
    {
      "id": "017bb51a-20f6-4b61-9347-d265fb17873a",
      "name": "Has more pages?",
      "type": "n8n-nodes-base.if",
      "position": [
        1040,
        512
      ]
    },
    {
      "id": "76e206cd-9371-4c8e-9976-764884723456",
      "name": "Merge \"items\" with last response",
      "type": "n8n-nodes-base.set",
      "position": [
        1296,
        528
      ]
    },
    {
      "id": "c8fb1200-86ca-4607-aad6-8175609156ce",
      "name": "Filter (has new AIO keywords)",
      "type": "n8n-nodes-base.filter",
      "position": [
        1024,
        928
      ]
    },
    {
      "id": "a63efe2e-a17c-4e6a-9bad-6ca656c6ed1a",
      "name": "Find new AIO keywords",
      "type": "n8n-nodes-base.code",
      "position": [
        816,
        928
      ]
    },
    {
      "id": "8b0f4e2a-6ddd-4461-a6b2-9e9005fa31c5",
      "name": "Split out (items)",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        144,
        928
      ]
    },
    {
      "id": "542718fa-4fdf-4f71-9bc1-2ab3cfb5881d",
      "name": "Loop over targets",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -16,
        496
      ]
    }
  ],
  "connections": {
    "Aggregate": {
      "main": [
        [
          {
            "node": "Clear sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate1": {
      "main": [
        [
          {
            "node": "Find new AIO keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clear sheet": {
      "main": [
        [
          {
            "node": "Get targets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get targets": {
      "main": [
        [
          {
            "node": "Loop over targets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Loop over targets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Has more pages?": {
      "main": [
        [
          {
            "node": "Set \"items\" field",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Merge \"items\" with last response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run every Monday": {
      "main": [
        [
          {
            "node": "Get previous keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop over targets": {
      "main": [
        [],
        [
          {
            "node": "Initialize \"items\" field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set \"items\" field": {
      "main": [
        [
          {
            "node": "Get ranked keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split out (items)": {
      "main": [
        [
          {
            "node": "Append keyword in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get ranked keywords": {
      "main": [
        [
          {
            "node": "Merge \"items\" with DFS response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find new AIO keywords": {
      "main": [
        [
          {
            "node": "Filter (has new AIO keywords)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get previous keywords": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append keyword in sheet": {
      "main": [
        [
          {
            "node": "Aggregate1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Initialize \"items\" field": {
      "main": [
        [
          {
            "node": "Set \"items\" field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter (has new AIO keywords)": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge \"items\" with DFS response": {
      "main": [
        [
          {
            "node": "Has more pages?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge \"items\" with last response": {
      "main": [
        [
          {
            "node": "Split out (items)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}