使用RapidAPI和Google Sheets的SERP关键词排名检查器
高级
这是一个Market Research, Miscellaneous, Multimodal AI领域的自动化工作流，包含 17 个节点。主要使用 If, Set, Wait, FormTrigger, HttpRequest 等节点。 使用RapidAPI和Google Sheets的SERP关键词排名检查器
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "d70c3059-3f69-43da-8551-1e5fc00755a1",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
-820,
-40
],
"webhookId": "ee9357a6-6e89-4606-9e8a-40c31a474016",
"parameters": {
"options": {},
"formTitle": "SERP Keyword Ranking Checker",
"formFields": {
"values": [
{
"fieldLabel": "keyword",
"placeholder": "e.g. labubu",
"requiredField": true
},
{
"fieldLabel": "Country",
"placeholder": "e.g. us",
"requiredField": true
}
]
},
"formDescription": "Enter your keyword for research the market."
},
"typeVersion": 2.2
},
{
"id": "9fa5e35f-6519-4107-8fa5-d62b9ed1b043",
"name": "全局存储",
"type": "n8n-nodes-base.set",
"position": [
-520,
-40
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "10714a4e-2be6-4167-aef5-afe30eebdc2b",
"name": "keyword",
"type": "string",
"value": "={{ $json.keyword }}"
},
{
"id": "6d160d8b-ab11-4f0a-a484-2e3f8f7f3033",
"name": "country",
"type": "string",
"value": "={{ $json.Country }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3b582bb8-9930-47d1-a07e-a5971c5c06c2",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
180,
-20
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3ec0a058-9e37-4363-a4da-b7937144be13",
"operator": {
"type": "array",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.data.semrushAPI.serpResults }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "4e5c4b34-02d0-4dab-9b17-51e0a2b4d9df",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
960,
-400
],
"parameters": {
"columns": {
"value": {
"Country": "={{ $('Global Storage').item.json.country }}",
"Keyword": "={{ $('Global Storage').item.json.keyword }}",
"Json data": "={{ $json.data.semrushAPI.serpResults }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Json data",
"type": "string",
"display": true,
"required": false,
"displayName": "Json data",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.6
},
{
"id": "fc7a635f-1c97-4844-ac37-5d689cf2d6dd",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
540,
140
],
"webhookId": "9934772d-2ed5-4521-bf30-dea8156deb5d",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "f0ffdaa0-2409-4506-a348-1932f210ba6a",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1000,
140
],
"parameters": {
"columns": {
"value": {
"Country": "={{ $('Global Storage').item.json.country }}",
"Keyword": "={{ $('Global Storage').item.json.keyword }}",
"Json data": "=No result found. Please try another keyword..."
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Json data",
"type": "string",
"display": true,
"required": false,
"displayName": "Json data",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.6
},
{
"id": "47463c0d-1eaa-4460-8ec8-b95a7a17f898",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
-180
],
"parameters": {
"height": 300,
"content": "### 1. 🟢 **表单提交时**"
},
"typeVersion": 1
},
{
"id": "58784227-c465-4d57-9dc9-a1b40b7fc2c3",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-580,
-180
],
"parameters": {
"height": 300,
"content": "### 2. 📦 **全局存储**"
},
"typeVersion": 1
},
{
"id": "4e382014-0405-4289-ba2e-41d3e58ca803",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-280,
-220
],
"parameters": {
"width": 300,
"height": 360,
"content": "### 3. 🌐 **SERP 关键词排名检查器**"
},
"typeVersion": 1
},
{
"id": "dff6f500-2ed2-4196-84d2-aefaf634ba1a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
-220
],
"parameters": {
"width": 300,
"height": 340,
"content": "### 4. ⚖️ **条件检查**"
},
"typeVersion": 1
},
{
"id": "673c5c34-42f4-4f07-b224-bc8de78048c3",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-40
],
"parameters": {
"width": 340,
"height": 320,
"content": "### 7. ⏳ **等待节点（5 秒间隔）**"
},
"typeVersion": 1
},
{
"id": "03234bef-6b97-4d00-b9a9-a9655420bf85",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-440
],
"parameters": {
"width": 340,
"height": 320,
"content": "### 5. ⏳ **等待节点（5 秒间隔）**"
},
"typeVersion": 1
},
{
"id": "ed8ccf20-02e0-4ab5-babb-c3ae1753b944",
"name": "等待1",
"type": "n8n-nodes-base.wait",
"position": [
560,
-260
],
"webhookId": "9934772d-2ed5-4521-bf30-dea8156deb5d",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "3289f067-2f24-4a69-b914-bad51769d3a9",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
-200
],
"parameters": {
"width": 400,
"height": 500,
"content": "### 8. 📊 **Google Sheets - 插入\"未找到结果\"记录**"
},
"typeVersion": 1
},
{
"id": "64aa2d6a-4a17-4c3a-953a-23d05c8692cf",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
-740
],
"parameters": {
"width": 400,
"height": 500,
"content": "### 6. 📊 **Google Sheets - 从响应体插入记录**"
},
"typeVersion": 1
},
{
"id": "d0986719-64ab-41bc-b553-8f48cffa1c01",
"name": "SERP 关键词排名检查器",
"type": "n8n-nodes-base.httpRequest",
"position": [
-180,
-40
],
"parameters": {
"url": "https://rapidapi.com/PrineshPatel/api/serp-keyword-ranking-checker",
"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": "serp-keyword-ranking-checker.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "f9c591c5-4210-42e2-986e-00f7ff08b229",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-620,
-840
],
"parameters": {
"width": 800,
"height": 540,
"content": "# 🔍 使用 RapidAPI 和 Google Sheets 的 SERP 关键词排名检查器"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Global Storage": {
"main": [
[
{
"node": "SERP Keyword Ranking Checker",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Global Storage",
"type": "main",
"index": 0
}
]
]
},
"SERP Keyword Ranking Checker": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, 杂项, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用RapidAPI和Google Sheets进行SEO竞争对手分析
使用RapidAPI和Google Sheets进行SEO竞争对手分析
If
Set
Wait
+4
15 节点Evoort Solutions
市场调研
无水印TikTok视频下载至Google Drive并自动记录到表格
将无水印TikTok视频下载到Google Drive，并自动在表格中记录日志
If
Wait
Form Trigger
+4
19 节点Evoort Solutions
内容创作
表单触发的Instagram视频下载到Google Drive并记录到表格
表单触发的Instagram视频下载到Google Drive并记录到表格
If
Wait
Form Trigger
+4
19 节点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
市场调研
使用背景移除AI处理图像并在Google表格中跟踪结果
使用背景移除AI处理图像并在Google表格中跟踪结果
If
Wait
Form Trigger
+4
17 节点Evoort Solutions
内容创作
