使用 Google Search Console 检测关键词蚕食和竞争页面

• •无特殊前置要求，导入即可使用

{
  "meta": {
    "instanceId": "370f0437fbf8d71caf7e9230e115239afcf5012c55ac368aa9dee29869df4a6b",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "d552d0a9-902d-4f5e-8910-8ade5a5511f9",
      "name": "工作流描述",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        -272
      ],
      "parameters": {
        "width": 760,
        "height": 460,
        "content": "## 🔎 查找查询蚕食（Google Search Console）"
      },
      "typeVersion": 1
    },
    {
      "id": "04e6147e-7496-4596-a9e8-20c3e59ac1b2",
      "name": "手动开始",
      "type": "n8n-nodes-base.start",
      "position": [
        768,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c71d3c12-f095-4aac-affa-ed5196b5759e",
      "name": "查询搜索分析",
      "type": "n8n-nodes-google-search-console.googleSearchConsole",
      "position": [
        1008,
        240
      ],
      "parameters": {
        "siteUrl": "sc-domain:example.com",
        "rowLimit": 10000,
        "operation": "getPageInsights",
        "dimensions": [
          "query",
          "page"
        ],
        "dateRangeMode": "last12mo"
      },
      "typeVersion": 1
    },
    {
      "id": "d9b96eac-bad1-4a41-9df4-4673076e24dd",
      "name": "按查询汇总",
      "type": "n8n-nodes-base.summarize",
      "position": [
        1280,
        240
      ],
      "parameters": {
        "options": {},
        "fieldsToSplitBy": "query",
        "fieldsToSummarize": {
          "values": [
            {
              "field": "query"
            },
            {
              "field": "page",
              "aggregation": "append"
            },
            {
              "field": "clicks",
              "aggregation": "append"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "c7c50db0-8706-4f65-985a-262ab0a644e9",
      "name": "过滤蚕食查询",
      "type": "n8n-nodes-base.filter",
      "position": [
        1520,
        240
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.count_query }}",
              "rightValue": 1
            },
            {
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.appended_clicks[1] }}",
              "rightValue": 0
            }
          ]
        }
      },
      "typeVersion": 2.2
    }
  ],
  "pinData": {},
  "connections": {
    "Manual Start": {
      "main": [
        [
          {
            "node": "Query Search Analytics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize by Query": {
      "main": [
        [
          {
            "node": "Filter Cannibal Queries",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Query Search Analytics": {
      "main": [
        [
          {
            "node": "Summarize by Query",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}