使用RapidAPI和Google Sheets进行SEO关键词难度与SERP分析
中级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 Code, FormTrigger, HttpRequest, GoogleSheets 等节点。 使用RapidAPI和Google Sheets进行SEO关键词难度与SERP分析
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "b72a5043-e59a-4669-ac5e-bacdd601fb90",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
0,
0
],
"webhookId": "d0dd8007-d6b2-4961-b2e0-a4bccc0b5824",
"parameters": {
"options": {},
"formTitle": "Keyword Difficulty Checker",
"formFields": {
"values": [
{
"fieldLabel": "keyword",
"requiredField": true
},
{
"fieldLabel": "country",
"requiredField": true
}
]
},
"formDescription": "Keyword Difficulty Checker"
},
"typeVersion": 2.2
},
{
"id": "2a1320b2-cc2a-42c9-9402-63f71aba61a4",
"name": "重新格式化 1",
"type": "n8n-nodes-base.code",
"position": [
520,
-140
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.keywordDifficulty;"
},
"typeVersion": 2
},
{
"id": "303d9dce-ae05-4f9b-9248-e03f5a6cfc39",
"name": "重新格式化 2",
"type": "n8n-nodes-base.code",
"position": [
480,
220
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.serpResults;"
},
"typeVersion": 2
},
{
"id": "305741d2-278c-41b1-9b42-fe3a9a00fcfc",
"name": "关键词难度检查器",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
0
],
"parameters": {
"url": "https://keyword-difficulty-checker1.p.rapidapi.com/keywordDifficulty.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "keyword",
"value": "={{ $json.keyword }}"
},
{
"name": "country",
"value": "={{ $json.country }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "keyword-difficulty-checker1.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "91b005e6-8d01-4b32-9210-621f8b68638f",
"name": "SERP 结果",
"type": "n8n-nodes-base.googleSheets",
"position": [
800,
220
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"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": "1BL8gZNhmaiZVThuEIFFra0XNQnnNrkxTsgEKeRoRHFM",
"cachedResultUrl": "",
"cachedResultName": "backlinks"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "d9839383-542c-4365-b521-fa8950093197",
"name": "关键词难度检查器1",
"type": "n8n-nodes-base.googleSheets",
"position": [
800,
-140
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keywordDifficultyIndex",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keywordDifficultyIndex",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"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": "25aa2e00-fb5f-484e-8fa8-c032d390969b",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1140,
-340
],
"parameters": {
"width": 1000,
"height": 960,
"content": "# 📊 用于 SEO 分析的关键词难度检查器工作流"
},
"typeVersion": 1
},
{
"id": "d44aa91c-852e-40c4-9cab-40c7a507fffd",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-120
],
"parameters": {
"height": 320,
"content": "📝 表单提交时"
},
"typeVersion": 1
},
{
"id": "91e6c05b-eb6e-484f-b80b-8ae8d121ef45",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-120
],
"parameters": {
"height": 320,
"content": "🌐 关键词难度检查器"
},
"typeVersion": 1
},
{
"id": "f37486d8-5fe7-49b6-8093-d7aa7fedc468",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-240
],
"parameters": {
"height": 280,
"content": "📦 重新格式化 1"
},
"typeVersion": 1
},
{
"id": "9acfc662-2677-4b74-b5d9-5cd982be140f",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
-240
],
"parameters": {
"height": 280,
"content": "📊 关键词难度检查器1"
},
"typeVersion": 1
},
{
"id": "c8e846c0-5127-4c52-b235-f354b748ddc3",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
80
],
"parameters": {
"height": 300,
"content": "📦 重新格式化 2"
},
"typeVersion": 1
},
{
"id": "88c0a09f-829d-4c61-b143-26ffa2fdaf0e",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
80
],
"parameters": {
"height": 300,
"content": "📄 SERP 结果"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Reformat 1": {
"main": [
[
{
"node": "Keyword Difficulty Checker1",
"type": "main",
"index": 0
}
]
]
},
"Reformat 2": {
"main": [
[
{
"node": "SERP Results ",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Keyword Difficulty Checker",
"type": "main",
"index": 0
}
]
]
},
"Keyword Difficulty Checker": {
"main": [
[
{
"node": "Reformat 1",
"type": "main",
"index": 0
},
{
"node": "Reformat 2",
"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
市场调研
从Semrush自动导出反向链接数据至Google Sheets（通过RapidAPI）
从Semrush自动导出反向链接数据至Google Sheets（通过RapidAPI）
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
市场调研
