8
n8n 中文网amn8n.com

使用Bright Data、Google Sheets和Gmail追踪Google搜索排名

中级

这是一个Marketing领域的自动化工作流，包含 11 个节点。主要使用 Code, Gmail, HttpRequest, GoogleSheets, ManualTrigger 等节点。 使用Bright Data、Google Sheets和Gmail追踪Google搜索排名

前置要求
  • •Google 账号和 Gmail API 凭证
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (11)

Code
Gmail
StickyNote
HttpRequest
GoogleSheets
ManualTrigger
SplitInBatches
ScheduleTrigger

分类

营销
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "b3b467644dfa8e0c6797928cc6d8bf68d9415ef612f9ba2a0d45772e9aff0f75",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "65c5da22-3579-48d7-a37d-899c956a4b3a",
      "name": "当点击\"测试工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1600,
        575
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8279787b-d056-4a46-aca3-2888416f46cf",
      "name": "定时触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1600,
        240
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 24
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "5d17fa71-520a-45bf-82b4-ebb5025085c5",
      "name": "制作邮件模板",
      "type": "n8n-nodes-base.code",
      "position": [
        -720,
        40
      ],
      "parameters": {
        "jsCode": "const simplifiedResults = items.map(item => {\n  return {\n    json: {\n      Keyword: item.json.Keyword,\n      rank: item.json.rank\n    }\n  };\n});\n\n// Start the HTML table\nlet emailContent = \"<table border='1' cellpadding='5' cellspacing='0' style='border-collapse: collapse;'>\";\n\n// Add table header\nemailContent += \"<tr><th>Keyword</th><th>Rank</th></tr>\";\n\n// Add table rows for each result\nsimplifiedResults.forEach(result => {\n  emailContent += `<tr><td>${result.json.Keyword}</td><td>${result.json.rank}</td></tr>`;\n});\n\n// Close the table tag\nemailContent += \"</table>\";\n\n// Return the email content with the table\nreturn [\n  {\n    json: {\n      emailBody: emailContent\n    }\n  }\n];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "f689b1b7-553f-4a88-ae8f-94de4bd6701a",
      "name": "读取关键词",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1380,
        240
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1441108147,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fvWyTep-kTTyStxqKjgh3qlnH3uAC4c75uLMJQp8s6A/edit#gid=1441108147",
          "cachedResultName": "Keyword"
        },
        "documentId": "={{ $credentials.googleSheetDocId }}"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "YBSRE682i2VDBuXC",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "3fb77ecb-4f3c-4e87-9ffb-70d5e38bb3ff",
      "name": "转换关键词",
      "type": "n8n-nodes-base.code",
      "position": [
        -1160,
        240
      ],
      "parameters": {
        "jsCode": "// Get all rows from input\nconst items = $input.all();\n\n// Transform each row's 'Keyword' field\nreturn items.map(item => {\n  const keyword = item.json.Keyword || '';\n  const transformedKeyword = keyword.replaceAll(' ', '+');\n\n  return {\n    json: {\n      ...item.json,  // keep original data\n      transformedKeyword\n    }\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "fe63d679-a349-4ce2-8d0b-9122da534aa8",
      "name": "循环处理关键词",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -940,
        240
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "2ad0d400-d52b-4401-8f65-c79d7b329c32",
      "name": "获取排名",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -720,
        240
      ],
      "parameters": {
        "url": "https://api.brightdata.com/request",
        "method": "POST",
        "options": {},
        "jsonBody": "={\"zone\": \"serp_n8n\",\"url\": \"https://www.google.com/search?q={{ $json.transformedKeyword }}&gl=US\", \n  \"format\": \"raw\"} ",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{$credentials.brightDataApiKey}}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "99acbc30-b1d8-4c16-819a-20b4a186a56d",
      "name": "排名查找器",
      "type": "n8n-nodes-base.code",
      "position": [
        -500,
        240
      ],
      "parameters": {
        "jsCode": "const html = $input.first().json.data;\nconst targetDomain = $('Reading Keywords').first().json.Domain; \n\n\nconst regex = /<a[^>]+href=\"(http[^\"]+)\"[^>]*>/g;\nlet match;\nlet links = [];\nwhile ((match = regex.exec(html)) !== null) {\n  const url = match[1];\n  if (\n    url.startsWith(\"http\") &&\n    !url.includes(\"google.com\") &&\n    !url.includes(\"/search?\") &&\n    !url.includes(\"webcache\")\n  ) {\n    links.push(url);\n  }\n}\n\n// Deduplicate and trim links\nlinks = [...new Set(links.map(link => link.trim()))];\n\n// Try to find the rank (position) of your target domain\nlet rank = null;\nlet foundUrl = null;\nfor (let i = 0; i < links.length; i++) {\n  if (links[i].includes(targetDomain)) {\n    rank = i + 1; // 1-based position\n    foundUrl = links[i];\n    break;\n  }\n}\n\n// Get current date and time\nconst now = new Date();\nconst dateTime = now.toLocaleString(); // e.g., \"5/19/2025, 2:30:00 PM\"\n\n// Output result\nreturn [\n  {\n    json: {\n      row: $('Loop over Keywords').first().json.row_number,\n      rank: rank || \"Not Ranked\",\n      url: foundUrl || \"N/A\",\n      totalResultsChecked: links.length,\n      found: !!foundUrl,\n      checkedAt: dateTime\n    }\n  }\n];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "eec8fa1e-c0c7-48a5-b7e4-9e5d9be3a52f",
      "name": "发布排名结果",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -280,
        315
      ],
      "parameters": {
        "columns": {
          "value": {
            "url": "={{ $json.url }}",
            "rank": "={{ $json.rank }}",
            "found": "={{ $json.found }}",
            "Domain": "={{ $('Reading Keywords').item.json.Domain }}",
            "Keyword": "={{ $('Reading Keywords').item.json.Keyword }}",
            "checkedAt": "={{ $json.checkedAt }}",
            "totalResultsChecked": "={{ $json.totalResultsChecked }}"
          },
          "schema": [
            {
              "id": "Keyword",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Keyword",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Domain",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "rank",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "rank",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "totalResultsChecked",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "totalResultsChecked",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "found",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "found",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "checkedAt",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "checkedAt",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Results"
        },
        "documentId": "={{ $credentials.googleSheetDocId }}"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "YBSRE682i2VDBuXC",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5,
      "alwaysOutputData": true
    },
    {
      "id": "86b5345d-6a6c-4c5b-9ca2-312ab627f69e",
      "name": "发送邮件消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -500,
        40
      ],
      "webhookId": "71c2feef-d8c3-414b-8cab-d70082ab2df4",
      "parameters": {
        "sendTo": "={{ $credentials.recipientEmail }}",
        "message": "={{ $json.emailBody }}",
        "options": {},
        "subject": "Ranked"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "9C4Tnt40p6JpYjIr",
          "name": "Gmail account"
        }
      },
      "executeOnce": true,
      "typeVersion": 2.1
    },
    {
      "id": "2aa430ee-b967-461e-9b20-97d34a1e5775",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2480,
        -360
      ],
      "parameters": {
        "width": 780,
        "height": 1740,
        "content": "# n8n 工作流说明与设置指南"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Rank Finder": {
      "main": [
        [
          {
            "node": "Post Rank Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Getting Ranks": {
      "main": [
        [
          {
            "node": "Rank Finder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Reading Keywords": {
      "main": [
        [
          {
            "node": "Transforming Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Reading Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post Rank Results": {
      "main": [
        [
          {
            "node": "Loop over Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop over Keywords": {
      "main": [
        [
          {
            "node": "Making Email Template",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Getting Ranks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Making Email Template": {
      "main": [
        [
          {
            "node": "Sending Email Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sending Email Message": {
      "main": [
        []
      ]
    },
    "Transforming Keywords": {
      "main": [
        [
          {
            "node": "Loop over Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Reading Keywords",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 营销

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

BrightData每周对比
使用Bright Data、GPT-4.1和Google Workspace的自动化网站变更监控
If
Set
Code
+15
35 节点Daniel Shashko
人工智能
使用GPT-4o、Google Sheets和邮件的自动品牌提及追踪器
使用GPT-4o、Google Sheets和邮件的自动品牌提及追踪器
Code
Email Send
Http Request
+3
14 节点Daniel Shashko
人工智能
自动化新闻到简报AI代理v13
AI新闻研究团队：24/7简报自动化，含Perplexity引用
Set
Code
Gmail
+15
37 节点Derek Cheung
产品
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
If
Set
Code
+21
40 节点Immanuel
人工智能
自动化博客撰写与社交媒体推广代理
使用GPT-4、Perplexity和WordPress自动化SEO博客创建+社交媒体
Set
Code
Gmail
+21
79 节点LukaszB
设计
竞争价格监控与警报（Bright Data、Sheets 和 Slack）
使用 Bright Data、Sheets 和 Slack 进行竞争价格监控与警报
If
Set
Code
+9
29 节点Daniel Shashko
市场调研
工作流信息
难度等级
中级
节点数量11
分类1
节点类型8
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Daniel Shashko

Daniel Shashko

@tomax

AI automation specialist and a marketing enthusiast. More than 6 years of experience in SEO/GEO. Senior SEO at Bright Data.

外部链接
在 n8n.io 查看 →

分享此工作流