从Semrush自动导出反向链接数据至Google Sheets（通过RapidAPI）
中级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 Code, FormTrigger, HttpRequest, GoogleSheets 等节点。 从Semrush自动导出反向链接数据至Google Sheets（通过RapidAPI）
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "9137421c-a5a6-47e0-816c-4c9707c77d75",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
0,
0
],
"webhookId": "5c31527e-396a-4263-bfa2-0b8d893060e4",
"parameters": {
"options": {},
"formTitle": "Semrush Backlink Checker",
"formFields": {
"values": [
{
"fieldLabel": "website",
"requiredField": true
}
]
},
"formDescription": "Semrush Backlink Checker"
},
"typeVersion": 2.2
},
{
"id": "885fee0f-647f-4eb3-80b3-7e37d15c9bd7",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
0
],
"parameters": {
"url": "https://semrush-backlink-checker.p.rapidapi.com/backlink.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "website",
"value": "={{ $json.website }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "semrush-backlink-checker.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "05e9b4d1-a348-48d2-8f9d-3b8243b183f3",
"name": "重新格式化 1",
"type": "n8n-nodes-base.code",
"position": [
480,
0
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.backlinksOverview;"
},
"typeVersion": 2
},
{
"id": "56aa5555-0460-453b-9518-36a82cf1eb97",
"name": "重新格式化 2",
"type": "n8n-nodes-base.code",
"position": [
400,
300
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.backlinks;"
},
"typeVersion": 2
},
{
"id": "53bb9a7e-069b-4398-8cad-444a5d41f8f2",
"name": "反向链接概览",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
0
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 4590546,
"cachedResultUrl": "",
"cachedResultName": "backlink overflow"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "backlinks"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "c4eb2b7d-d586-4300-b427-44c3c7027178",
"name": "反向链接",
"type": "n8n-nodes-base.googleSheets",
"position": [
700,
300
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "targetUrl",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "targetUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sourceUrl",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sourceUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sourceTitle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sourceTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pageAscore",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pageAscore",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lastSeen",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "lastSeen",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "internalNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "internalNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "firstSeen",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "firstSeen",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "externalNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "externalNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "anchor",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "anchor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nofollow",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "nofollow",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "backlinks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "backlinks"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "8a3c938c-b6bf-4bbb-bfa3-22b9d30ef2d2",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-820,
-140
],
"parameters": {
"width": 680,
"height": 780,
"content": "# 🚀 使用 n8n 和 Google Sheets 实现 Semrush 反向链接检查器自动化"
},
"typeVersion": 1
},
{
"id": "543c484a-e96e-4ee6-ae3c-dcb9343c17e5",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-140
],
"parameters": {
"height": 300,
"content": "**表单提交时** – 当用户通过自定义表单提交网站 URL 时启动工作流。"
},
"typeVersion": 1
},
{
"id": "b9ccc855-61e1-43c2-a948-b67a12dd518a",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-140
],
"parameters": {
"height": 300,
"content": "**HTTP 请求** – 使用 POST 方法将提交的 URL 发送到 Semrush 反向链接检查器 API，包含请求头和请求体数据。"
},
"typeVersion": 1
},
{
"id": "a2efe122-287c-45a0-8706-b83f8e9b66b0",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-140
],
"parameters": {
"height": 300,
"content": "**重新格式化 1** – 从 API 响应的 JSON 中提取 `backlinksOverview` 对象。"
},
"typeVersion": 1
},
{
"id": "a959e928-e4b8-41b7-a5d4-a41502962113",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
360,
200
],
"parameters": {
"height": 280,
"content": "**重新格式化 2** – 从 API 响应的 JSON 中提取 `backlinks` 列表（详细数据）。"
},
"typeVersion": 1
},
{
"id": "5eb05e85-9c3b-41b1-9cf9-3afbcd411c5d",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-140
],
"parameters": {
"height": 300,
"content": "**反向链接概览** – 将反向链接概览指标追加到指定 Google Sheets 文档中的“backlink overflow”工作表。"
},
"typeVersion": 1
},
{
"id": "72bcc8b0-6dc1-4802-a558-1ccb5695de9c",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
220
],
"parameters": {
"height": 260,
"content": "**反向链接** – 将单个反向链接条目（例如来源 URL、锚文本、分数）追加到同一 Google Sheet 中的“backlinks”工作表。"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Reformat 1": {
"main": [
[
{
"node": "Backlink overview",
"type": "main",
"index": 0
}
]
]
},
"Reformat 2": {
"main": [
[
{
"node": "Backlinks ",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Reformat 1",
"type": "main",
"index": 0
},
{
"node": "Reformat 2",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 市场调研, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用RapidAPI和Google Sheets报告分析竞争对手关键词
使用RapidAPI和Google Sheets报告分析竞争对手关键词
Code
Form Trigger
Http Request
+2
9 节点Evoort Solutions
市场调研
自动化页面SEO分析与记录，使用RapidAPI和Google表格
自动化页面SEO分析与记录，使用RapidAPI和Google表格
Set
Code
Form Trigger
+3
33 节点Evoort Solutions
市场调研
基于RapidAPI和Google表格的自动化SEO关键词分析
通过RapidAPI和Google表格实现自动化SEO关键词分析
Set
Code
Form Trigger
+3
21 节点Evoort Solutions
市场调研
使用RapidAPI和Google Sheets进行SEO关键词难度与SERP分析
使用RapidAPI和Google Sheets进行SEO关键词难度与SERP分析
Code
Form Trigger
Http Request
+2
13 节点Evoort Solutions
市场调研
按国家和语言追踪 YouTube 趋势
使用 RapidAPI 和 Google Sheets 按国家和语言追踪 YouTube 趋势
Code
Form Trigger
Http Request
+2
9 节点Evoort Solutions
市场调研
使用RapidAPI提取YouTube频道元数据到Google Docs
使用RapidAPI提取YouTube频道元数据到Google Docs
Code
Google Docs
Form Trigger
+2
9 节点Evoort Solutions
市场调研
