SEO关键词研究
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 56 个节点。主要使用 Code, Merge, HttpRequest, GoogleSheets, ManualTrigger 等节点。 使用GPT完全自动化博客创建并通过Google Sheets发布到WordPress
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "pVWoKnxJXiEf89Jw",
"meta": {
"instanceId": "50618e78906785f75ac298c8b090bb3bd6406a17352da71ebb8b85e6df90fa3a",
"templateCredsSetupCompleted": true
},
"name": "SEO 关键词研究",
"tags": [],
"nodes": [
{
"id": "84bcbf6d-65cd-45ba-904e-235d62bf2d23",
"name": "手动触发器",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-2000,
520
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3c7d7215-2ff0-44de-b407-ac537add7b81",
"name": "HTTP 搜索量",
"type": "n8n-nodes-base.httpRequest",
"position": [
-420,
-360
],
"parameters": {
"url": "https://api.dataforseo.com/v3/keywords_data/google_ads/search_volume/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keywords\": [\"{{ $json.Keywords }}\"]\n}]\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "98773b36-8135-4f8f-bcf3-746fbbae8561",
"name": "HTTP Google 搜索结果页",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
560
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/google/organic/live/advanced",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keyword\": \"{{ $json.Keywords }}\",\n \"device\": \"desktop\",\n \"depth\": 100,\n \"parse\": true\n}]\n\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "36a176ab-b2ed-4292-8fa6-1c17a66da10a",
"name": "HTTP 关键词建议",
"type": "n8n-nodes-base.httpRequest",
"position": [
-100,
2020
],
"parameters": {
"url": "https://api.dataforseo.com/v3/keywords_data/google_ads/keywords_for_keywords/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keywords\": [\"{{ $json.Keywords }}\"]\n}]\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
}
},
"typeVersion": 4
},
{
"id": "3c028d1f-c767-4039-8b49-36c146be6ee3",
"name": "HTTP 截图",
"type": "n8n-nodes-base.httpRequest",
"position": [
120,
260
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/screenshot",
"method": "POST",
"options": {},
"jsonBody": "=[{\"task_id\":\"{{ $json[\"tasks\"][0][\"id\"] }}\"}]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
}
},
"typeVersion": 4
},
{
"id": "c92d3111-f5c9-4ce0-849a-5bd154fbc589",
"name": "HTTP 本地查找结果",
"type": "n8n-nodes-base.httpRequest",
"position": [
-100,
1720
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/google/local_finder/live/advanced",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keyword\": \"{{ $json[\"tasks\"][0][\"data\"][\"keyword\"] }}\"\n}]\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
}
},
"typeVersion": 4
},
{
"id": "08bfbe4b-85b7-4cf8-9977-e0665ebb7b32",
"name": "HTTP 反向链接",
"type": "n8n-nodes-base.httpRequest",
"position": [
140,
1460
],
"parameters": {
"url": "https://api.dataforseo.com/v3/backlinks/summary/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\"target\":\"{{ $json.top_domain }}\"}]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
}
},
"typeVersion": 4
},
{
"id": "280bea71-108c-4b57-ae13-77d08d2baba4",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1760,
520
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1966727209,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1966727209",
"cachedResultName": "Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "da596be3-6d45-446b-8e81-252647b62fff",
"name": "提取摘要1",
"type": "n8n-nodes-base.code",
"position": [
-100,
-20
],
"parameters": {
"jsCode": "const result = $json[\"tasks\"]?.[0]?.result?.[0] || {};\nconst output = [];\n\nlet hasSnippet = false;\n\nif (result.items) {\n for (const item of result.items) {\n if (item.type === 'featured_snippet') {\n output.push({ json: {\n Keyword: result.keyword,\n \"Snippet Title\": item.title,\n URL: item.url,\n Domain: item.domain,\n \"Snippet Text\": item.description ? item.description.substring(0, 200) : ''\n }});\n hasSnippet = true;\n break;\n }\n }\n}\n\nif (!hasSnippet) {\n output.push({ json: {\n Keyword: result.keyword,\n \"Snippet Title\": '',\n URL: '',\n Domain: '',\n \"Snippet Text\": ''\n }});\n}\n\nreturn output;\n\n"
},
"typeVersion": 2
},
{
"id": "1517df19-4d40-4809-895e-33250ed4f5a7",
"name": "检测搜索结果页特征1",
"type": "n8n-nodes-base.code",
"position": [
-100,
560
],
"parameters": {
"jsCode": "const result = $json[\"tasks\"]?.[0]?.result?.[0];\nconst features = {\n Keyword: result?.keyword || \"\",\n Featured_Snippet: false,\n People_Also_Ask: false,\n Local_Pack: false,\n Video: false,\n Image_Pack: false,\n Top_Stories: false,\n Knowledge_Panel: false,\n Shopping_Ads: false\n};\n\nif (result?.items) {\n for (const item of result.items) {\n const type = item.type?.toLowerCase();\n if (type.includes(\"featured_snippet\")) features.Featured_Snippet = true;\n if (type.includes(\"people_also_ask\")) features.People_Also_Ask = true;\n if (type.includes(\"local\") || type.includes(\"map\")) features.Local_Pack = true;\n if (type.includes(\"video\")) features.Video = true;\n if (type.includes(\"image\")) features.Image_Pack = true;\n if (type.includes(\"top_stories\") || type.includes(\"news\")) features.Top_Stories = true;\n if (type.includes(\"knowledge\")) features.Knowledge_Panel = true;\n if (type.includes(\"shopping\")) features.Shopping_Ads = true;\n }\n}\n\nreturn [{ json: features }];"
},
"typeVersion": 2
},
{
"id": "d8ee89e5-cede-4bcf-ae5c-a907a8e96abb",
"name": "提取自然搜索结果",
"type": "n8n-nodes-base.code",
"position": [
-100,
840
],
"parameters": {
"jsCode": "const result = $json[\"tasks\"][0][\"result\"][0];\nconst output = [];\n\nif (result.items) {\n for (const item of result.items) {\n if (item.type === 'organic') {\n output.push({\n json: {\n Keyword: result.keyword,\n Rank: item.rank_group,\n Position: item.rank_absolute,\n Title: item.title || '',\n URL: item.url || '',\n Domain: item.domain || '',\n Breadcrumb: item.breadcrumb || '',\n Snippet: item.description || ''\n }\n });\n }\n }\n}\n\nreturn output;\n"
},
"typeVersion": 2
},
{
"id": "a5a0b982-ab17-4df8-a2ee-10444d29c1b8",
"name": "提取顶级域名",
"type": "n8n-nodes-base.code",
"position": [
-100,
1460
],
"parameters": {
"jsCode": "const data = $json[\"tasks\"][0][\"result\"][0];\nlet topDomain = null;\nif (data.items) {\n for (const item of data.items) {\n if (item.type === 'organic') {\n topDomain = item.domain;\n break;\n }\n }\n}\nreturn {\n json: {\n Keyword: data.keyword,\n top_domain: topDomain\n }\n};"
},
"typeVersion": 2
},
{
"id": "fd00e659-67aa-4eb3-99e6-9cc5834a8323",
"name": "提取本地结果",
"type": "n8n-nodes-base.code",
"position": [
140,
1720
],
"parameters": {
"jsCode": "const result = $json.tasks?.[0]?.result?.[0];\nconst output = [];\nif (result && result.items) {\n for (const biz of result.items) {\n if (biz.type === 'local_pack' || biz.type === 'map') {\n output.push({ json: {\n Keyword: result.keyword || ($json.Keyword || ''),\n \"Business Name\": biz.title || '',\n Details: biz.description || ''\n } });\n }\n }\n}\nreturn output;"
},
"typeVersion": 2
},
{
"id": "7eee3574-85d4-42a1-a1fb-5b09bdcb6e0d",
"name": "提取建议",
"type": "n8n-nodes-base.code",
"position": [
140,
2020
],
"parameters": {
"jsCode": "const tasks = $json.tasks;\nconst output = [];\n\nif (tasks && tasks[0] && tasks[0].result) {\n const suggestions = tasks[0].result;\n const keyword = tasks[0].data.keywords ? tasks[0].data.keywords[0] : ($json.Keyword || '');\n\n for (const sug of suggestions) {\n output.push({\n Keyword: keyword,\n \"Suggested Keyword\": sug.keyword,\n \"Search Volume\": sug.search_volume || 0,\n CPC: sug.cpc || 0,\n Competition: sug.competition || sug.competition_level || ''\n });\n }\n}\n\nreturn output;"
},
"typeVersion": 2
},
{
"id": "d18e848b-8b59-430e-a84d-80dcd6cb7f58",
"name": "HTTP 相关关键词",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
-340
],
"parameters": {
"url": "https://api.dataforseo.com/v3/dataforseo_labs/google/related_keywords/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keyword\": \"{{ $json.Keywords }}\",\n \"depth\": 1\n}]\n\n\n\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "cc00a7a4-4007-4ea9-bf5d-e167618ae6b9",
"name": "HTTP 关键词创意",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
-60
],
"parameters": {
"url": "https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_ideas/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keywords\": [\"{{ $json.Keywords }}\"],\n \"limit\": 100\n}]\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "b92b2821-8925-461d-98c0-35a634c1ffe5",
"name": "HTTP 子主题",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
260
],
"parameters": {
"url": "https://api.dataforseo.com/v3/content_generation/generate_sub_topics/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\"topic\":\"{{ $json.Keywords }}\",\"max_sub_topics\":10}]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "79a1ec2d-16a6-437c-9cf6-e8151595bc65",
"name": "提取相关关键词",
"type": "n8n-nodes-base.code",
"position": [
-1200,
-340
],
"parameters": {
"jsCode": "const items = $json.tasks[0].result[0].items || [];\nlet allRelated = [];\n\nitems.forEach(item => {\n const mainKeyword = item.keyword_data?.keyword || null;\n const related = item.related_keywords || [];\n\n related.forEach(keyword => {\n allRelated.push({\n MainKeyword: mainKeyword,\n RelatedKeyword: keyword\n });\n });\n});\n\nreturn allRelated;\n\n\n\n\n"
},
"typeVersion": 2
},
{
"id": "8aafd19c-6a17-4379-9df9-f1aa6e8ba03a",
"name": "提取子主题",
"type": "n8n-nodes-base.code",
"position": [
-1200,
260
],
"parameters": {
"jsCode": "const topic = $input.first().json.tasks[0].data.topic || '';\nconst subs = $json.tasks[0].result[0].sub_topics || [];\n\nreturn subs.map((s, idx) => ({\n Keyword: topic,\n Subtopic: s,\n Rank: idx + 1\n}));\n"
},
"typeVersion": 2
},
{
"id": "03fcd370-1d5b-4eda-bf6a-e29ea9418bae",
"name": "提取关键词创意",
"type": "n8n-nodes-base.code",
"position": [
-1200,
-60
],
"parameters": {
"jsCode": "const kw = $json.tasks[0].result[0].seed_keywords?.[0] || $json.Keyword || '';\nconst items = $json.tasks[0].result || [];\nconst out = [];\n\nitems.forEach(res => {\n (res.items || []).forEach(i => {\n out.push({\n Keyword: kw,\n IdeaKeyword: i.keyword,\n SV: i.search_volume || null,\n CPC: i.cpc || null,\n Competition: i.competition || null\n });\n });\n});\n\nreturn out;\n"
},
"typeVersion": 2
},
{
"id": "993936fb-803c-40ff-8f8c-dabfa68a7b45",
"name": "提取搜索量趋势",
"type": "n8n-nodes-base.code",
"position": [
-100,
-360
],
"parameters": {
"jsCode": "const keyword = $json.tasks?.[0]?.result?.[0]?.keyword || '';\nconst monthly = $json.tasks?.[0]?.result?.[0]?.monthly_searches || [];\nconst defaultCpc = $json.tasks?.[0]?.result?.[0]?.cpc || 0;\n\nreturn monthly.map(m => ({\n Keyword: keyword,\n Year: m.year,\n Month: m.month,\n Searches: m.search_volume,\n CPC: m.cpc !== undefined ? m.cpc : defaultCpc\n}));\n"
},
"typeVersion": 2
},
{
"id": "5760dd9e-efce-4e2c-8732-1c851d99f507",
"name": "提取 PAA/PAS",
"type": "n8n-nodes-base.code",
"position": [
-100,
1140
],
"parameters": {
"jsCode": "const kw = $json.keyword || $json.Keyword || ($json.tasks && $json.tasks[0].keyword) || $json.tasks?.[0]?.result?.[0]?.keyword;\nconst topItems = $json.tasks?.[0]?.result?.[0]?.items || [];\nconst out = [];\n\ntopItems.forEach(section => {\n // ✅ PAS: People Also Search op hoofdniveau\n if (section.type === 'people_also_search_element') {\n out.push({\n Type: \"PAS\",\n Keyword: kw,\n Related: section.keyword,\n Rank: section.rank_group || section.rank\n });\n }\n\n // ✅ Geneste PAA: People Also Ask elementen\n if (Array.isArray(section.items)) {\n section.items.forEach(i => {\n if (i.type === 'people_also_ask_element') {\n out.push({\n Type: \"PAA\",\n Keyword: kw,\n Question: i.title\n });\n }\n });\n }\n});\n\nreturn out;\n\n"
},
"typeVersion": 2
},
{
"id": "2fc0d43c-c493-4f80-b9a3-9681ee834af5",
"name": "概览",
"type": "n8n-nodes-base.googleSheets",
"position": [
1380,
700
],
"parameters": {
"columns": {
"value": {
"CPC": "={{ $json.Average_CPC }}",
"#PAA": "={{ $json.PAA_Question }}",
"#Local": "={{ $json.Local_Business_Name }}",
"Keyword": "={{ $json.Keyword }}",
"Competition": "={{ $json.Average_Competition }}",
"Has Snippet": "={{ $json.Has_Snippet }}",
"SERP Features": "={{ $json.SERP_Features }}",
"Screenshot URL": "={{ $json.Screenshot_URL }}",
"Avg Search Volume": "={{ $json.Avg_Search_Volume }}",
"Referring Domains": "={{ $json.Referring_Domains }}",
"Top Organic Domains": "={{ $json.Top_Organic_Domain }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Avg Search Volume",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Avg Search Volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Competition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Competition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Has Snippet",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Has Snippet",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SERP Features",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SERP Features",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Top Organic Domains",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Top Organic Domains",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "#PAA",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "#PAA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "#Local",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "#Local",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Referring Domains",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Referring Domains",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Screenshot URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Screenshot URL",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1357600484,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1357600484",
"cachedResultName": "Overview"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "3f1ec549-8c2e-4e34-8cfa-0dc35937c5d1",
"name": "搜索量趋势",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
-360
],
"parameters": {
"columns": {
"value": {
"CPC": "={{ $json.CPC }}",
"Year": "={{ $json.Year }}",
"Month": "={{ $json.Month }}",
"Keyword": "={{ $json.Keyword }}",
"Searches": "={{ $json.Searches }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Month",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Month",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Searches",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Searches",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"options": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 282690701,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=282690701",
"cachedResultName": "Search Volume Trend"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "6b776b8a-a12d-4e8a-aa74-3a2ad2a2f86c",
"name": "精选摘要",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
-20
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.URL }}",
"Domain": "={{ $json.Domain }}",
"Keyword": "={{ $json.Keyword }}",
"Snippet Text": "={{ $json['Snippet Text'] }}",
"Snippet Title": "={{ $json['Snippet Title'] }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Snippet Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Snippet Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Snippet Text",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Snippet Text",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"options": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1313102974,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1313102974",
"cachedResultName": "Featured Snippets"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "c2e9953d-f96e-4e68-89a1-b01df6b5facb",
"name": "搜索结果页特征",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
560
],
"parameters": {
"columns": {
"value": {
"Video": "={{ $json.Video }}",
"Keyword": "={{ $json.Keyword }}",
"Image_Pack": "={{ $json.Image_Pack }}",
"Local_Pack": "={{ $json.Local_Pack }}",
"Top_Stories": "={{ $json.Top_Stories }}",
"Shopping_Ads": "={{ $json.Shopping_Ads }}",
"Knowledge_Panel": "={{ $json.Knowledge_Panel }}",
"People_Also_Ask": "={{ $json.People_Also_Ask }}",
"Featured_Snippet": "={{ $json.Featured_Snippet }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Featured_Snippet",
"type": "string",
"display": true,
"required": false,
"displayName": "Featured_Snippet",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "People_Also_Ask",
"type": "string",
"display": true,
"required": false,
"displayName": "People_Also_Ask",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Local_Pack",
"type": "string",
"display": true,
"required": false,
"displayName": "Local_Pack",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video",
"type": "string",
"display": true,
"required": false,
"displayName": "Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_Pack",
"type": "string",
"display": true,
"required": false,
"displayName": "Image_Pack",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Top_Stories",
"type": "string",
"display": true,
"required": false,
"displayName": "Top_Stories",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Knowledge_Panel",
"type": "string",
"display": true,
"required": false,
"displayName": "Knowledge_Panel",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shopping_Ads",
"type": "string",
"display": true,
"required": false,
"displayName": "Shopping_Ads",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1323889712,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1323889712",
"cachedResultName": "SERP Features"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "46155321-d041-495f-9742-73129c9d3d80",
"name": "PAA",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
1140
],
"parameters": {
"columns": {
"value": {
"Type": "={{ $json.Type }}",
"Keyword": "={{ $json.Keyword }}",
"Question": "={{ $json.Question }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Question",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Question",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 677237490,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=677237490",
"cachedResultName": "PAA"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "f668078a-529d-4d61-9d88-f536e446a016",
"name": "自然搜索结果",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
840
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.URL }}",
"Rank": "={{ $json.Rank }}",
"Title": "={{ $json.Title }}",
"Domain": "={{ $json.Domain }}",
"Keyword": "={{ $json.Keyword }}",
"Snippet": "={{ $json.Snippet }}",
"Position": "={{ $json.Position }}",
"Breadcrumb": "={{ $json.Breadcrumb }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rank",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Rank",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Breadcrumb",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Breadcrumb",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Snippet",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Snippet",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1797280058,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1797280058",
"cachedResultName": "Organic Results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "74a88edf-29eb-4aad-83bf-c942dde1da56",
"name": "本地结果",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
1720
],
"parameters": {
"columns": {
"value": {
"Details": "={{ $json.Details }}",
"Keyword": "={{ $json.Keyword }}",
"Business Name": "={{ $json['Business Name'] }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Business Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Business Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Details",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Details",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"options": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 550769217,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=550769217",
"cachedResultName": "Local Results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "de5a423e-57dd-4ccf-86c1-14d07853bfd6",
"name": "建议",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
2020
],
"parameters": {
"columns": {
"value": {
"CPC": "={{ $json.CPC }}",
"Keyword": "={{ $json.Keyword }}",
"Competition": "={{ $json.Competition }}",
"Search Volume": "={{ $json['Search Volume'] }}",
"Suggested Keyword": "={{ $json['Suggested Keyword'] }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Suggested Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Suggested Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Search Volume",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Search Volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Competition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Competition",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1378869548,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1378869548",
"cachedResultName": "Suggestions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "aa9378c9-f9b7-42fc-8f1f-8502770ef75a",
"name": "关键词创意",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
-60
],
"parameters": {
"columns": {
"value": {
"SV": "={{ $json.SV }}",
"CPC": "={{ $json.CPC }}",
"Keyword": "={{ $json.Keyword }}",
"Competition": "={{ $json.Competition }}",
"IdeaKeyword": "={{ $json.IdeaKeyword }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IdeaKeyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "IdeaKeyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SV",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SV",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Competition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Competition",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 170448196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=170448196",
"cachedResultName": "Keyword Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "314d309e-b3d0-46b6-a03b-06a33edec4d7",
"name": "子主题",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
260
],
"parameters": {
"columns": {
"value": {
"Rank": "={{ $json.Rank }}",
"Keyword": "={{ $json.Keyword }}",
"Subtopic": "={{ $json.Subtopic }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subtopic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Subtopic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rank",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Rank",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1278595222,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1278595222",
"cachedResultName": "Subtopics"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "303b73bb-db1c-4f85-8095-74fff312eca8",
"name": "反向链接",
"type": "n8n-nodes-base.googleSheets",
"position": [
380,
1460
],
"parameters": {
"columns": {
"value": {
"Domain": "={{ $('Extract Top Domain').item.json.top_domain }}",
"Country": "={{ $json.tasks[0].result[0].info.country }}",
"Keyword": "={{ $('Extract Top Domain').item.json.Keyword }}",
"Platform": "={{ $json.tasks[0].result[0].info.platform_type[0] }}",
"Backlinks": "={{ $json.tasks[0].result[0].backlinks }}",
"Referring Domains": "={{ $json.tasks[0].result[0].referring_main_domains }}",
"Backlinks Spam Score": "={{ $json.tasks[0].result[0].backlinks_spam_score }}"
},
"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": "Backlinks",
"type": "string",
"display": true,
"required": false,
"displayName": "Backlinks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Referring Domains",
"type": "string",
"display": true,
"required": false,
"displayName": "Referring Domains",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Backlinks Spam Score",
"type": "string",
"display": true,
"required": false,
"displayName": "Backlinks Spam Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Platform",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 260185468,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=260185468",
"cachedResultName": "Backlinks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "5d2c6aa2-82a0-4643-8c14-67e6895635e4",
"name": "相关关键词",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
-340
],
"parameters": {
"columns": {
"value": {
"Main Keyword": "={{ $json.MainKeyword }}",
"Related Keyword": "={{ $json.RelatedKeyword }}"
},
"schema": [
{
"id": "Main Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Main Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Related Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Related Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1669673679,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1669673679",
"cachedResultName": "Related Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "71f7cfd2-d7b5-4f03-aa8c-533ddf204e54",
"name": "平均搜索量和每次点击费用",
"type": "n8n-nodes-base.code",
"position": [
340,
-360
],
"parameters": {
"jsCode": "const items = $input.all();\n\nlet totalSearches = 0;\nlet totalCPC = 0;\nlet cpcCount = 0;\n\nfor (const item of items) {\n const searches = item.json.Searches || 0;\n const cpc = item.json.CPC;\n\n totalSearches += searches;\n\n if (typeof cpc === 'number') {\n totalCPC += cpc;\n cpcCount++;\n }\n}\n\nconst avgSearches = totalSearches / items.length;\nconst avgCPC = cpcCount > 0 ? totalCPC / cpcCount : null;\n\nreturn [\n {\n json: {\n Keyword: items[0].json.Keyword,\n AverageSearchVolume: Math.round(avgSearches),\n AverageCPC: avgCPC !== null ? Math.round(avgCPC * 100) / 100 : null,\n DataPoints: items.length\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "076789d9-b429-45d6-a2e7-d16572ff998e",
"name": "是或否",
"type": "n8n-nodes-base.code",
"position": [
340,
-20
],
"parameters": {
"jsCode": "const output = [];\n\nfor (const item of $input.all()) {\n const hasSnippet = item.json[\"Snippet Title\"] && item.json[\"Snippet Title\"].trim() !== \"\";\n \n output.push({\n json: {\n Keyword: item.json.Keyword,\n HasSnippet: hasSnippet ? \"Yes\" : \"No\"\n }\n });\n}\n\nreturn output;\n"
},
"typeVersion": 2
},
{
"id": "b8ded190-d8ce-4a96-91ba-0146174b6027",
"name": "存在哪些特征",
"type": "n8n-nodes-base.code",
"position": [
360,
560
],
"parameters": {
"jsCode": "const item = $input.first().json;\n\nconst serpFeatures = [\n 'Featured_Snippet',\n 'People_Also_Ask',\n 'Local_Pack',\n 'Video',\n 'Image_Pack',\n 'Top_Stories',\n 'Knowledge_Panel',\n 'Shopping_Ads'\n];\n\nconst found = serpFeatures.filter(key => item[key]);\n\nreturn [{\n json: {\n Keyword: item.Keyword,\n Present_SERP_Features: found.join(', ') || 'None'\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "f201fdcc-3d35-425c-894d-4f257a18b42c",
"name": "平均竞争度",
"type": "n8n-nodes-base.code",
"position": [
540,
2020
],
"parameters": {
"jsCode": "const items = $input.all();\nlet total = 0;\nlet count = 0;\n\nconst mapCompetition = {\n LOW: 1,\n MEDIUM: 2,\n HIGH: 3\n};\n\nlet keyword = items[0]?.json?.Keyword || \"UNKNOWN\";\n\nlet avgLabel = \"UNKNOWN\";\n\nfor (const item of items) {\n const raw = item.json.Competition?.toUpperCase();\n const value = mapCompetition[raw];\n if (value) {\n total += value;\n count++;\n }\n}\n\nif (count > 0) {\n const avg = total / count;\n if (avg < 1.5) {\n avgLabel = \"LOW\";\n } else if (avg < 2.5) {\n avgLabel = \"MEDIUM\";\n } else {\n avgLabel = \"HIGH\";\n }\n}\n\nreturn [{\n json: {\n Keyword: keyword,\n Average_Competition: avgLabel\n }\n}];\n\n\n"
},
"typeVersion": 2
},
{
"id": "77720ece-04ae-4d2f-bcd1-254dc0d75cac",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
380,
1140
],
"parameters": {
"jsCode": "const items = $input.all();\n\nif (items.length === 0) {\n return [];\n}\n\n// Neem alleen de eerste item (aangenomen dat het type PAA is)\nconst first = items.find(i => i.json.Type === 'PAA');\n\nreturn [{\n json: {\n Keyword: first?.json.Keyword || \"UNKNOWN\",\n Question: first?.json.Question || \"No question found\"\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "22d63f16-462a-45a1-be11-ad0e727ce2c5",
"name": "代码1",
"type": "n8n-nodes-base.code",
"position": [
540,
1720
],
"parameters": {
"jsCode": "const items = $input.all();\n\nif (items.length === 0) {\n return [];\n}\n\n// Neem alleen de eerste relevante entry\nconst first = items[0].json;\n\nreturn [{\n json: {\n Keyword: first.Keyword || \"UNKNOWN\",\n Business_Name: first[\"Business Name\"] || \"No name found\",\n Details: first.Details || \"No details\"\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
1020,
580
],
"parameters": {
"numberInputs": 8
},
"typeVersion": 3.1
},
{
"id": "f6018e44-9523-4431-b8c0-49d0f22b1170",
"name": "重构数据",
"type": "n8n-nodes-base.code",
"position": [
1200,
700
],
"parameters": {
"jsCode": "const inputs = $input.all();\nconst combined = {};\n\nfor (const item of inputs) {\n Object.assign(combined, item.json);\n}\n\nreturn [{\n json: {\n Keyword: combined.Keyword || null,\n Avg_Search_Volume: combined.AverageSearchVolume || null,\n Average_CPC: combined.AverageCPC || null,\n DataPoints: combined.DataPoints || null,\n Has_Snippet: combined.HasSnippet || null,\n SERP_Features: combined.Present_SERP_Features || null,\n Top_Organic_Domain: combined.Domain || null,\n PAA_Question: combined.Question || null,\n Screenshot_URL: combined.tasks?.[0]?.result?.[0]?.url || null,\n Backlinks: combined.Backlinks || null,\n Referring_Domains: combined['Referring Domains'] || null,\n Spam_Score: combined['Backlinks Spam Score'] || null,\n Country: combined.Country || null,\n Platform: combined.Platform || null,\n Local_Business_Name: combined.Business_Name || null,\n Local_Details: combined.Details || null,\n Average_Competition: combined.Average_Competition || null\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "27efc4e8-ef6f-4244-b5e8-f89ab5d1df18",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
460
],
"parameters": {
"color": 4,
"width": 440,
"height": 220,
"content": "## 获取关键词"
},
"typeVersion": 1
},
{
"id": "b548d12b-16c5-4bde-9c62-096287837150",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
460
],
"parameters": {
"color": 2,
"width": 820,
"height": 580,
"content": "## 创建概览"
},
"typeVersion": 1
},
{
"id": "ecd8d090-1799-44c2-8c85-1385f64b0fb5",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-440
],
"parameters": {
"width": 1340,
"height": 280,
"content": "# 获取平均搜索量和每次点击费用"
},
"typeVersion": 1
},
{
"id": "98dba987-562e-442f-aa6f-f1c9294ec612",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-140
],
"parameters": {
"color": 3,
"width": 1340,
"height": 280,
"content": "# 提取精选摘要"
},
"typeVersion": 1
},
{
"id": "91ddca1e-daec-45f1-b09f-7d226da88a63",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
160
],
"parameters": {
"color": 4,
"width": 1340,
"height": 280,
"content": "# 获取页面截图"
},
"typeVersion": 1
},
{
"id": "de71b3cf-7084-4b6c-abb0-022fd7c6ddd8",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
460
],
"parameters": {
"color": 5,
"width": 1340,
"height": 280,
"content": "# 搜索结果页研究"
},
"typeVersion": 1
},
{
"id": "4515bcd9-2608-4860-bf01-f915fd7e7f7f",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
760
],
"parameters": {
"color": 6,
"width": 1340,
"height": 280,
"content": "# 自然搜索结果"
},
"typeVersion": 1
},
{
"id": "678b247c-03af-4e58-99cf-23c59513439a",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1060
],
"parameters": {
"color": 5,
"width": 1340,
"height": 280,
"content": "# 用户还问了以下问题"
},
"typeVersion": 1
},
{
"id": "a57fef70-86f6-41ab-8037-0e9646f89ad1",
"name": "## 为什么选择 4o 模型？👆",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1360
],
"parameters": {
"color": 2,
"width": 1340,
"height": 280,
"content": "# 获取顶级域名反向链接"
},
"typeVersion": 1
},
{
"id": "64afb7ed-87c0-450b-a3df-2922a5535861",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1660
],
"parameters": {
"color": 3,
"width": 1340,
"height": 280,
"content": "# 本地结果"
},
"typeVersion": 1
},
{
"id": "b6893598-49e9-412a-8b34-710da958f3b4",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1960
],
"parameters": {
"color": 4,
"width": 1340,
"height": 280,
"content": "# 建议关键词"
},
"typeVersion": 1
},
{
"id": "b9e65c87-cc25-4334-a336-bb96f95ba1cf",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
-440
],
"parameters": {
"color": 3,
"width": 1340,
"height": 280,
"content": "# 获取相关关键词"
},
"typeVersion": 1
},
{
"id": "eddd6ee1-1ecd-4096-b9ff-389ad7bca959",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
-140
],
"parameters": {
"color": 5,
"width": 1340,
"height": 280,
"content": "# 获取关键词创意"
},
"typeVersion": 1
},
{
"id": "f1678692-0659-413a-abbf-4c088d90eef2",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
160
],
"parameters": {
"width": 1340,
"height": 280,
"content": "# 提取子主题"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "1c604e43-4648-4d70-b151-c66e63cdaef4",
"connections": {
"PAA": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 4
}
]
]
},
"Code1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 6
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Restructure data",
"type": "main",
"index": 0
}
]
]
},
"Backlinks": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 5
}
]
]
},
"Subtopics": {
"main": [
[]
]
},
"Yes or No": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Suggestions": {
"main": [
[
{
"node": "Average competition",
"type": "main",
"index": 0
}
]
]
},
"Extract Local": {
"main": [
[
{
"node": "Local Results",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "HTTP Google SERP",
"type": "main",
"index": 0
},
{
"node": "HTTP SearchVolume",
"type": "main",
"index": 0
},
{
"node": "HTTP Keyword Suggestions",
"type": "main",
"index": 0
},
{
"node": "HTTP Related Keywords",
"type": "main",
"index": 0
},
{
"node": "HTTP Keyword Ideas",
"type": "main",
"index": 0
},
{
"node": "HTTP Subtopics",
"type": "main",
"index": 0
}
]
]
},
"Local Results": {
"main": [
[
{
"node": "Code1",
"type": "main",
"index": 0
}
]
]
},
"SERP Features": {
"main": [
[
{
"node": "Wich features exist",
"type": "main",
"index": 0
}
]
]
},
"HTTP Backlinks": {
"main": [
[
{
"node": "Backlinks",
"type": "main",
"index": 0
}
]
]
},
"HTTP Subtopics": {
"main": [
[
{
"node": "Extract Subtopics",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Extract Organic": {
"main": [
[
{
"node": "Organic Results",
"type": "main",
"index": 0
}
]
]
},
"Extract PAA/PAS": {
"main": [
[
{
"node": "PAA",
"type": "main",
"index": 0
}
]
]
},
"HTTP Screenshot": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Organic Results": {
"main": [
[]
]
},
"Extract Snippet1": {
"main": [
[
{
"node": "Featured Snippets",
"type": "main",
"index": 0
}
]
]
},
"HTTP Google SERP": {
"main": [
[
{
"node": "HTTP Screenshot",
"type": "main",
"index": 0
},
{
"node": "HTTP Local Finder",
"type": "main",
"index": 0
},
{
"node": "Extract Organic",
"type": "main",
"index": 0
},
{
"node": "Extract Snippet1",
"type": "main",
"index": 0
},
{
"node": "Detect SERP Features1",
"type": "main",
"index": 0
},
{
"node": "Extract Top Domain",
"type": "main",
"index": 0
},
{
"node": "Extract PAA/PAS",
"type": "main",
"index": 0
}
]
]
},
"Related Keywords": {
"main": [
[]
]
},
"Restructure data": {
"main": [
[
{
"node": "Overview",
"type": "main",
"index": 0
}
]
]
},
"Extract Subtopics": {
"main": [
[
{
"node": "Subtopics",
"type": "main",
"index": 0
}
]
]
},
"Featured Snippets": {
"main": [
[
{
"node": "Yes or No",
"type": "main",
"index": 0
}
]
]
},
"HTTP Local Finder": {
"main": [
[
{
"node": "Extract Local",
"type": "main",
"index": 0
}
]
]
},
"HTTP SearchVolume": {
"main": [
[
{
"node": "Extract Volume Trend",
"type": "main",
"index": 0
}
]
]
},
"Extract Top Domain": {
"main": [
[
{
"node": "HTTP Backlinks",
"type": "main",
"index": 0
}
]
]
},
"HTTP Keyword Ideas": {
"main": [
[
{
"node": "Extract Keyword Ideas",
"type": "main",
"index": 0
}
]
]
},
"Average competition": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 7
}
]
]
},
"Extract Suggestions": {
"main": [
[
{
"node": "Suggestions",
"type": "main",
"index": 0
}
]
]
},
"Search Volume Trend": {
"main": [
[
{
"node": "average search volume and CPC",
"type": "main",
"index": 0
}
]
]
},
"Wich features exist": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 3
}
]
]
},
"Extract Volume Trend": {
"main": [
[
{
"node": "Search Volume Trend",
"type": "main",
"index": 0
}
]
]
},
"Detect SERP Features1": {
"main": [
[
{
"node": "SERP Features",
"type": "main",
"index": 0
}
]
]
},
"Extract Keyword Ideas": {
"main": [
[
{
"node": "Keywords Ideas",
"type": "main",
"index": 0
}
]
]
},
"HTTP Related Keywords": {
"main": [
[
{
"node": "Extract Related Keywords",
"type": "main",
"index": 0
}
]
]
},
"Extract Related Keywords": {
"main": [
[
{
"node": "Related Keywords",
"type": "main",
"index": 0
}
]
]
},
"HTTP Keyword Suggestions": {
"main": [
[
{
"node": "Extract Suggestions",
"type": "main",
"index": 0
}
]
]
},
"average search volume and CPC": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
YouTube视频转博客
使用Mistral AI和Gemini图像生成从YouTube视频创建博客文章
Set
Code
Merge
+14
56 节点Zakwan
内容创作
模板HP - 内容排期
使用GPT-4、Apify和Google Sheets自动生成Instagram内容排期
Set
Code
Wait
+9
24 节点keisha kalra
内容创作
对比页面工作流
使用OpenAI和Google Sheets自动生成产品对比页面
Code
Merge
Http Request
+6
50 节点Abrar Sami
内容创作
内容聚合
使用Gemini AI从网站文章自动化社交媒体帖子发布到LinkedIn和X/Twitter
If
Set
Xml
+16
34 节点Vadim
内容创作
使用 OpenAI、ElevenLabs 和 Fal.ai 自动化病毒式内容创作，适用于视频、播客和 ASMR
使用 OpenAI、ElevenLabs 和 Fal.ai 自动化病毒式内容创作，适用于视频、播客和 ASMR
Set
Code
Wait
+16
97 节点Adam Crafts
内容创作
使用OpenAI、ElevenLabs和Hedra创建病毒式婴儿播客YouTube短视频
使用OpenAI、ElevenLabs和Hedra创建病毒式婴儿播客YouTube短视频
Code
Wait
Merge
+12
38 节点Electrabot
内容创作
