{
  "name": "Find SEO keyword opportunities with SE Ranking, AI search, and Google Sheets",
  "nodes": [
    {
      "id": "52205087-2642-4f64-9b96-eff1285202db",
      "name": "Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        448,
        -544
      ],
      "parameters": {
        "width": 736,
        "height": 888,
        "content": "## Find competitor keyword opportunities with SE Ranking and AI search\n\n## Who is this for\n- SEO agencies tracking competitors\n- Content teams finding gaps\n- Marketing teams planning strategy\n\n## What"
      }
    },
    {
      "id": "ed215442-6cde-46e1-be77-48a1a8d4c9da",
      "name": "When clicking 'Execute workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        672,
        800
      ]
    },
    {
      "id": "293c1790-aafa-43fb-b5db-624f2050e9df",
      "name": "Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        848,
        800
      ]
    },
    {
      "id": "781b85da-ff6e-47cd-886e-23a7a5c651af",
      "name": "Get your domain overview",
      "type": "@seranking/n8n-nodes-seranking.seRanking",
      "position": [
        2496,
        -160
      ]
    },
    {
      "id": "2cc8ddc1-80de-430a-90b5-e5984cfa3849",
      "name": "Auto-discover top competitors",
      "type": "@seranking/n8n-nodes-seranking.seRanking",
      "position": [
        1072,
        496
      ]
    },
    {
      "id": "f594a47f-db0e-4cdb-b97b-ea89d8a78f28",
      "name": "Extract competitor domains",
      "type": "n8n-nodes-base.code",
      "position": [
        1264,
        496
      ]
    },
    {
      "id": "5ce8cd73-ee9b-446d-b8e0-4c6b3275b4be",
      "name": "Wait before gap analysis",
      "type": "n8n-nodes-base.wait",
      "position": [
        1472,
        496
      ]
    },
    {
      "id": "cdab3d2b-f9e2-4474-9028-71ec1f86fae1",
      "name": "Get keyword gaps",
      "type": "@seranking/n8n-nodes-seranking.seRanking",
      "position": [
        1664,
        496
      ]
    },
    {
      "id": "3d5fedd4-5631-412f-ad50-b2a6a13a86fc",
      "name": "Filter & score keyword gaps",
      "type": "n8n-nodes-base.code",
      "position": [
        1824,
        496
      ]
    },
    {
      "id": "0f7365ce-43b7-45db-9027-ead456063ba9",
      "name": "Wait before lost keywords",
      "type": "n8n-nodes-base.wait",
      "position": [
        2272,
        704
      ]
    },
    {
      "id": "d9de553b-2927-46d3-8306-5af0a1e761a6",
      "name": "Get your lost keywords",
      "type": "@seranking/n8n-nodes-seranking.seRanking",
      "position": [
        2464,
        704
      ]
    },
    {
      "id": "56b1775c-08f6-4ba0-9a1c-035f644fa509",
      "name": "Format lost keywords",
      "type": "n8n-nodes-base.code",
      "position": [
        2672,
        704
      ]
    },
    {
      "id": "f1864efd-5d86-43d7-9fb7-8685856eed3f",
      "name": "Loop through keywords",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2224,
        496
      ]
    },
    {
      "id": "b73d4d7a-7fe3-4dcb-92b7-9325d3edbac0",
      "name": "Get similar keywords",
      "type": "@seranking/n8n-nodes-seranking.seRanking",
      "position": [
        2448,
        320
      ]
    },
    {
      "id": "12e43616-9a1f-4c32-9455-879f52316d2d",
      "name": "Get related keywords",
      "type": "@seranking/n8n-nodes-seranking.seRanking",
      "position": [
        2448,
        480
      ]
    },
    {
      "id": "02f714a9-3bb9-41b2-9c41-1f002ff0d0b2",
      "name": "Merge similar & related",
      "type": "n8n-nodes-base.merge",
      "position": [
        2656,
        400
      ]
    },
    {
      "id": "ba980e54-88e6-4a75-adcc-37f0b54fef75",
      "name": "Format topic expansion",
      "type": "n8n-nodes-base.code",
      "position": [
        2432,
        176
      ]
    },
    {
      "id": "cfd0e620-d3aa-4456-9ad5-776ce39cd41c",
      "name": "Wait before AI leaderboard",
      "type": "n8n-nodes-base.wait",
      "position": [
        2352,
        1152
      ]
    },
    {
      "id": "c9ca72e7-c6d5-4854-b5dc-0784f93b018c",
      "name": "Extract your AI visibility",
      "type": "n8n-nodes-base.code",
      "position": [
        2752,
        1152
      ]
    },
    {
      "id": "115eedd5-6dee-474b-884c-03c242d698a7",
      "name": "Final scoring with AI context",
      "type": "n8n-nodes-base.code",
      "position": [
        3632,
        528
      ]
    },
    {
      "id": "5caa3fd6-e142-45b2-9829-e762b4a2c5e0",
      "name": "Export to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3824,
        528
      ]
    },
    {
      "id": "ed2158f4-48bf-4e87-9c67-47a20e194fc3",
      "name": "Extract top gap keywords",
      "type": "n8n-nodes-base.code",
      "position": [
        2032,
        496
      ]
    },
    {
      "id": "725bd029-7f9d-4095-8ef1-cad4a4ab5477",
      "name": "Get AI search leaderboard",
      "type": "@seranking/n8n-nodes-seranking.seRanking",
      "position": [
        2528,
        1184
      ]
    },
    {
      "id": "63fcc165-ce63-4865-9e96-576069e5cfb3",
      "name": "Merge domain & topics",
      "type": "n8n-nodes-base.merge",
      "position": [
        3200,
        256
      ]
    },
    {
      "id": "92d9346f-2f47-482b-9f87-79d8a4b55744",
      "name": "Merge lost & AI",
      "type": "n8n-nodes-base.merge",
      "position": [
        3216,
        512
      ]
    },
    {
      "id": "f57c1e94-d777-4e7e-ab27-db2de6aae88d",
      "name": "Merge all data",
      "type": "n8n-nodes-base.merge",
      "position": [
        3424,
        400
      ]
    },
    {
      "id": "f99e2104-cfd3-4c1d-8fb4-eeafb2dcb6a4",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2176,
        -304
      ],
      "parameters": {
        "width": 384,
        "height": 112,
        "content": "### Domain Overview\nGet your baseline metrics (keywords, traffic, value)"
      }
    },
    {
      "id": "bbee334b-fcd4-4c82-94fe-d3edf84d8acd",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1488,
        304
      ],
      "parameters": {
        "width": 608,
        "height": 144,
        "content": "### Competitor Discovery & Gap Analysis\nAuto-discover top 5 competitors, analyze keyword gaps, expand topics with related keywords"
      }
    },
    {
      "id": "ebe576ee-8b92-4134-9666-bf9d0dfc8762",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2272,
        864
      ],
      "parameters": {
        "width": 448,
        "height": 112,
        "content": "### Lost Keywords\nFind quick wins from keywords you recently lost rankings for"
      }
    },
    {
      "id": "2aee4a65-7275-414b-9a6e-db96e0768a05",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2384,
        1376
      ],
      "parameters": {
        "width": 464,
        "height": 112,
        "content": "### AI Search Visibility\nTrack presence across ChatGPT, Perplexity, Gemini, AI Overview"
      }
    }
  ],
  "connections": {
    "Configuration": {
      "main": [
        [
          {
            "node": "Get your domain overview",
            "type": "main",
            "index": 0
          },
          {
            "node": "Auto-discover top competitors",
            "type": "main",
            "index": 0
          },
          {
            "node": "Wait before lost keywords",
            "type": "main",
            "index": 0
          },
          {
            "node": "Wait before AI leaderboard",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge all data": {
      "main": [
        [
          {
            "node": "Final scoring with AI context",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge lost & AI": {
      "main": [
        [
          {
            "node": "Merge all data",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Get keyword gaps": {
      "main": [
        [
          {
            "node": "Filter & score keyword gaps",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format lost keywords": {
      "main": [
        [
          {
            "node": "Merge lost & AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get related keywords": {
      "main": [
        [
          {
            "node": "Merge similar & related",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Get similar keywords": {
      "main": [
        [
          {
            "node": "Merge similar & related",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop through keywords": {
      "main": [
        [
          {
            "node": "Format topic expansion",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get similar keywords",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get related keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge domain & topics": {
      "main": [
        [
          {
            "node": "Merge all data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format topic expansion": {
      "main": [
        [
          {
            "node": "Merge domain & topics",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Get your lost keywords": {
      "main": [
        [
          {
            "node": "Format lost keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge similar & related": {
      "main": [
        [
          {
            "node": "Loop through keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract top gap keywords": {
      "main": [
        [
          {
            "node": "Loop through keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get your domain overview": {
      "main": [
        [
          {
            "node": "Merge domain & topics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait before gap analysis": {
      "main": [
        [
          {
            "node": "Get keyword gaps",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get AI search leaderboard": {
      "main": [
        [
          {
            "node": "Extract your AI visibility",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait before lost keywords": {
      "main": [
        [
          {
            "node": "Get your lost keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract competitor domains": {
      "main": [
        [
          {
            "node": "Wait before gap analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract your AI visibility": {
      "main": [
        [
          {
            "node": "Merge lost & AI",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Wait before AI leaderboard": {
      "main": [
        [
          {
            "node": "Get AI search leaderboard",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter & score keyword gaps": {
      "main": [
        [
          {
            "node": "Extract top gap keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Auto-discover top competitors": {
      "main": [
        [
          {
            "node": "Extract competitor domains",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Final scoring with AI context": {
      "main": [
        [
          {
            "node": "Export to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking 'Execute workflow'": {
      "main": [
        [
          {
            "node": "Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}