自动化页面SEO分析与记录，使用RapidAPI和Google表格
高级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 33 个节点。主要使用 Set, Code, FormTrigger, HttpRequest, GoogleSheets 等节点。 自动化页面SEO分析与记录，使用RapidAPI和Google表格
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "10211c28-4673-429a-ba74-e41f4897dc93",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
-540,
0
],
"webhookId": "db57033b-15eb-42ea-b443-9fd003069d77",
"parameters": {
"options": {},
"formTitle": "OnPage SEO ( WebSite )",
"formFields": {
"values": [
{
"fieldLabel": "website",
"requiredField": true
}
]
},
"formDescription": "OnPage SEO ( WebSite )"
},
"typeVersion": 2.2
},
{
"id": "d540b3a7-fa74-4cbf-a5f1-f2fe90dac4b5",
"name": "全局存储",
"type": "n8n-nodes-base.set",
"position": [
-220,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "10714a4e-2be6-4167-aef5-afe30eebdc2b",
"name": "website",
"type": "string",
"value": "={{ $json.website }}"
},
{
"id": "6d160d8b-ab11-4f0a-a484-2e3f8f7f3033",
"name": "country",
"type": "string",
"value": "={{ $json.country }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "5a516ec6-5571-49e5-9f29-71b0ca5571b9",
"name": "网站流量检查器",
"type": "n8n-nodes-base.httpRequest",
"position": [
120,
-280
],
"parameters": {
"url": "https://seo-on-page.p.rapidapi.com/webtraffic.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": "seo-on-page.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "6fd04a51-99f5-41b8-9e87-4b79458cb64f",
"name": "网站指标 DA PA",
"type": "n8n-nodes-base.httpRequest",
"position": [
180,
20
],
"parameters": {
"url": "https://seo-on-page.p.rapidapi.com/dapa.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": "=seo-on-page.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "fd821ffa-4514-4d5d-b00b-121cd80f4de9",
"name": "顶级反向链接",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
320
],
"parameters": {
"url": "https://seo-on-page.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": "seo-on-page.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "ba321850-215d-4bfc-974d-ca8b05010037",
"name": "竞争对手分析",
"type": "n8n-nodes-base.httpRequest",
"position": [
40,
660
],
"parameters": {
"url": "https://seo-on-page.p.rapidapi.com/competitor.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": "seo-on-page.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "0608f487-09a2-4ace-8180-554a64db14d4",
"name": "重新格式化",
"type": "n8n-nodes-base.code",
"position": [
460,
-280
],
"parameters": {
"jsCode": "\nreturn $input.first().json.data.semrushAPI.trafficSummary[0];"
},
"typeVersion": 2
},
{
"id": "7e562232-bd9e-46e7-b084-6b63fbc45fcc",
"name": "重新格式化 2",
"type": "n8n-nodes-base.code",
"position": [
440,
0
],
"parameters": {
"jsCode": "return $input.first().json.data;"
},
"typeVersion": 2
},
{
"id": "8716e2fc-4e2a-4edf-9ebf-63ed9b985e87",
"name": "DA PA",
"type": "n8n-nodes-base.googleSheets",
"position": [
740,
-20
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "da",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "da",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pa",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pa",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "spam_score",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "spam_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "dr",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "dr",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "org_traffic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "org_traffic",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2000619993,
"cachedResultUrl": "",
"cachedResultName": "DA PA"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "55ddbf28-b730-484b-b53a-1e84924df5b2",
"name": "网站流量",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
-280
],
"parameters": {
"columns": {
"value": {
"users": "={{ $json.users }}",
"visits": "={{ $json.visits }}",
"website": "={{ $json.target }}",
"bounceRate": "={{ $json.bounceRate }}",
"timeOnSite": "={{ $json.timeOnSite }}",
"displayDate": "={{ $json.displayDate }}",
"pagesPerVisit": "={{ $json.pagesPerVisit }}",
"searchOrganic": "={{ $json.searchOrganic }}"
},
"schema": [
{
"id": "website",
"type": "string",
"display": true,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "searchOrganic",
"type": "string",
"display": true,
"required": false,
"displayName": "searchOrganic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pagesPerVisit",
"type": "string",
"display": true,
"required": false,
"displayName": "pagesPerVisit",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "visits",
"type": "string",
"display": true,
"required": false,
"displayName": "visits",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "users",
"type": "string",
"display": true,
"required": false,
"displayName": "users",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timeOnSite",
"type": "string",
"display": true,
"required": false,
"displayName": "timeOnSite",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "bounceRate",
"type": "string",
"display": true,
"required": false,
"displayName": "bounceRate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "displayDate",
"type": "string",
"display": true,
"required": false,
"displayName": "displayDate",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "WebSite Traffic"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "5a800f61-2f0c-4a3e-9cee-79c66b1982cc",
"name": "重新格式化 3",
"type": "n8n-nodes-base.code",
"position": [
540,
360
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.backlinksOverview;"
},
"typeVersion": 2
},
{
"id": "98c5b73e-34cf-4a8b-b850-c80b134c3aef",
"name": "重新格式化 4",
"type": "n8n-nodes-base.code",
"position": [
540,
620
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.backlinks;"
},
"typeVersion": 2
},
{
"id": "d46bdc66-a2ee-4614-b7ba-3862f106231e",
"name": "反向链接概览",
"type": "n8n-nodes-base.googleSheets",
"position": [
980,
300
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "ascore",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ascore",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domainsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domainsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "followsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "formsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "framesNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "framesNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ipclasscNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ipclasscNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "imagesNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "imagesNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ipsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ipsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nofollowsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "nofollowsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sponsoredNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sponsoredNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "textsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "textsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "total",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "total",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "urlsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "urlsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ugcNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ugcNum",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1629296631,
"cachedResultUrl": "",
"cachedResultName": "Backlinks Overview"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "154437d1-0cae-4c9d-9512-4d8b00e84cf4",
"name": "反向链接",
"type": "n8n-nodes-base.googleSheets",
"position": [
1020,
620
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1558472055,
"cachedResultUrl": "",
"cachedResultName": "Backlinks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "f56d9efb-55c9-4751-8acc-fe82974e52d7",
"name": "重新格式化 5",
"type": "n8n-nodes-base.code",
"position": [
320,
820
],
"parameters": {
"jsCode": "const apiData = $input.first().json.data.semrushAPI;\n\nlet allRows = [];\n\n// Loop through each property\nfor (const key in apiData) {\n if (Array.isArray(apiData[key])) {\n // Add the name of the dataset as a field\n apiData[key].forEach(item => {\n allRows.push({ json: { dataset: key, ...item } });\n });\n }\n}\n\nreturn allRows;\n"
},
"typeVersion": 2
},
{
"id": "0bb2eed8-177c-4dae-b195-a3084efaa6da",
"name": "竞争对手分析",
"type": "n8n-nodes-base.googleSheets",
"position": [
680,
860
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "dataset",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "dataset",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "database",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "database",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organicKeywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "organicKeywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organicTraffic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "organicTraffic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "backlinksNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "backlinksNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domainsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domainsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "adwordsKeywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "adwordsKeywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "commonKeywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "commonKeywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "competitorRelevance",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "competitorRelevance",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organicCost",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "organicCost",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "trafficPercent",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "trafficPercent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "traffic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "traffic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "numberOfKeywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "numberOfKeywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "competition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "competition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cpc",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "cpc",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "numberOfResults",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "numberOfResults",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "positionDifference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "positionDifference",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "previousPosition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "previousPosition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "searchVolume",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "searchVolume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "trafficCostPercent",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "trafficCostPercent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "trends",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "trends",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keywordDifficulty",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keywordDifficulty",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1156851816,
"cachedResultUrl": "",
"cachedResultName": "Competitor Analysis"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "af175b68-810b-4bc5-afb2-104158caf45f",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1840,
-180
],
"parameters": {
"width": 940,
"height": 840,
"content": "# 页面 SEO（网站）"
},
"typeVersion": 1
},
{
"id": "255845ab-aad0-4151-ae7b-96b255b6aeca",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-600,
-140
],
"parameters": {
"height": 340,
"content": "**表单提交时** — 显示一个网页表单（字段：`website`）并在提交时触发工作流。"
},
"typeVersion": 1
},
{
"id": "dac1487c-1660-47f4-9849-0b65f5d66bd1",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-280,
-140
],
"parameters": {
"height": 340,
"content": "**全局存储** — 将 `website`（和可选的 `country`）复制到执行 JSON 中以供重用。"
},
"typeVersion": 1
},
{
"id": "453e9e3f-5612-4c0e-ac9f-83c717bcbd14",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
-380
],
"parameters": {
"height": 220,
"content": "**网站流量检查器** — 将 `website` POST 到 `webtraffic.php`（RapidAPI）以获取流量摘要。"
},
"typeVersion": 1
},
{
"id": "78261b9e-c35d-4a23-a1c9-e9a4acb011b6",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-380
],
"parameters": {
"height": 220,
"content": "**重新格式化** — 从流量 API 响应中提取 `data.semrushAPI.trafficSummary[0]`。"
},
"typeVersion": 1
},
{
"id": "a3f76afc-705e-4747-8ab0-8b3193c46f23",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
-360
],
"parameters": {
"height": 220,
"content": "**网站流量** — 将流量指标（访问量、用户数、跳出率等）附加到 **\"网站流量\"** 工作表。"
},
"typeVersion": 1
},
{
"id": "671f2955-762c-4ae9-836b-600dfa08d2f4",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
-80
],
"parameters": {
"height": 220,
"content": "**网站指标 DA PA** — 将 `website` POST 到 `dapa.php`（RapidAPI）以获取 DA、PA、垃圾邮件分数、DR、组织流量。"
},
"typeVersion": 1
},
{
"id": "d46ac965-90ae-43dd-a4e8-78d1d8b815fe",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
-80
],
"parameters": {
"height": 220,
"content": "**重新格式化 2** — 从 DA/PA API 响应中提取 `data` 对象以进行清晰映射"
},
"typeVersion": 1
},
{
"id": "dfdc4b4e-e6ae-43d3-8068-c5dda8a7e7f3",
"name": "## 为什么选择 4o 模型？👆",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-100
],
"parameters": {
"height": 220,
"content": "**DA PA** — 将 DA/PA 及相关字段附加到 **\"DA PA\"** 工作表中。"
},
"typeVersion": 1
},
{
"id": "da105eb1-58c0-4816-8d8d-070e6ddf9791",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
240
],
"parameters": {
"height": 200,
"content": "**顶级反向链接** — 将 `website` POST 到 `backlink.php`（RapidAPI）以检索反向链接数据。"
},
"typeVersion": 1
},
{
"id": "c172b486-0220-42d4-9383-1f6203dcc320",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
260
],
"parameters": {
"height": 220,
"content": "**重新格式化 3** — 提取 `data.semrushAPI.backlinksOverview`（聚合反向链接指标）。"
},
"typeVersion": 1
},
{
"id": "7235fabb-56ec-490f-88a3-b22864c972fe",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
900,
220
],
"parameters": {
"height": 220,
"content": "**反向链接概览** — 将概览指标附加到 **\"反向链接概览\"** 工作表中。"
},
"typeVersion": 1
},
{
"id": "4d1219dd-a333-49b9-8362-9ab7f6685b47",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
520
],
"parameters": {
"height": 220,
"content": "**重新格式化 4** — 提取详细的 `data.semrushAPI.backlinks`（单个反向链接列表）。"
},
"typeVersion": 1
},
{
"id": "1131c491-00b8-4861-bdfc-34c7b7aa8072",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
540
],
"parameters": {
"height": 240,
"content": "**反向链接** — 将每个反向链接行附加到 **\"反向链接\"** 工作表中。"
},
"typeVersion": 1
},
{
"id": "e0039df4-faeb-4478-835f-05275538768a",
"name": "便签 14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
560
],
"parameters": {
"height": 220,
"content": "**竞争对手分析** — 将 `website` POST 到 `competitor.php`（RapidAPI）以获取竞争对手/数据集。"
},
"typeVersion": 1
},
{
"id": "eb9a700c-5d6c-439e-ad97-5dc1105dc613",
"name": "便签 15",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
720
],
"parameters": {
"height": 220,
"content": "**重新格式化 5** — 将 `data.semrushAPI` 下的所有数组数据集扁平化为带有 `dataset` 标签的行。"
},
"typeVersion": 1
},
{
"id": "109ad2cb-00c4-48f4-a4ee-b3776100c7bf",
"name": "便签16",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
780
],
"parameters": {
"height": 200,
"content": "**竞争对手分析** — 将扁平化的竞争对手和关键词行附加到 **\"竞争对手分析\"** 工作表中。"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Re-Format": {
"main": [
[
{
"node": "Website Traffic",
"type": "main",
"index": 0
}
]
]
},
"Re-Format 2": {
"main": [
[
{
"node": "DA PA",
"type": "main",
"index": 0
}
]
]
},
"Re -Format 3": {
"main": [
[
{
"node": "Backlinks Overview",
"type": "main",
"index": 0
}
]
]
},
"Re -Format 4": {
"main": [
[
{
"node": "Backlinks",
"type": "main",
"index": 0
}
]
]
},
"Re -Format 5": {
"main": [
[
{
"node": "Competitor Analysis ",
"type": "main",
"index": 0
}
]
]
},
"Top Baclinks": {
"main": [
[
{
"node": "Re -Format 3",
"type": "main",
"index": 0
},
{
"node": "Re -Format 4",
"type": "main",
"index": 0
}
]
]
},
"Global Storage": {
"main": [
[
{
"node": "Website Traffic Cheker",
"type": "main",
"index": 0
},
{
"node": "Competitors Analysis ",
"type": "main",
"index": 0
},
{
"node": "Website Metrics DA PA",
"type": "main",
"index": 0
},
{
"node": "Top Baclinks",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Global Storage",
"type": "main",
"index": 0
}
]
]
},
"Competitors Analysis ": {
"main": [
[
{
"node": "Re -Format 5",
"type": "main",
"index": 0
}
]
]
},
"Website Metrics DA PA": {
"main": [
[
{
"node": "Re-Format 2",
"type": "main",
"index": 0
}
]
]
},
"Website Traffic Cheker": {
"main": [
[
{
"node": "Re-Format",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于RapidAPI和Google表格的自动化SEO关键词分析
通过RapidAPI和Google表格实现自动化SEO关键词分析
Set
Code
Form Trigger
+3
21 节点Evoort Solutions
市场调研
使用RapidAPI和Google Sheets报告分析竞争对手关键词
使用RapidAPI和Google Sheets报告分析竞争对手关键词
Code
Form Trigger
Http Request
+2
9 节点Evoort Solutions
市场调研
从Semrush自动导出反向链接数据至Google Sheets（通过RapidAPI）
从Semrush自动导出反向链接数据至Google Sheets（通过RapidAPI）
Code
Form Trigger
Http Request
+2
13 节点Evoort Solutions
市场调研
使用RapidAPI和Google Sheets进行SEO竞争对手分析
使用RapidAPI和Google Sheets进行SEO竞争对手分析
If
Set
Wait
+4
15 节点Evoort Solutions
市场调研
使用RapidAPI和Google Sheets进行SEO关键词难度与SERP分析
使用RapidAPI和Google Sheets进行SEO关键词难度与SERP分析
Code
Form Trigger
Http Request
+2
13 节点Evoort Solutions
市场调研
使用RapidAPI和Google Sheets的SERP关键词排名检查器
使用RapidAPI和Google Sheets的SERP关键词排名检查器
If
Set
Wait
+4
17 节点Evoort Solutions
市场调研
