n8n - DataforSEO - 所有操作
高级
这是一个Market Research领域的自动化工作流，包含 39 个节点。主要使用 If, Set, Filter, Switch, SplitOut 等节点。 使用DataForSEO和Google Sheets自动化SEO关键词和SERP分析
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "IJ8L1LgxmncCxrN6",
"meta": {
"instanceId": "c24388df44432e8ff2c4acecd7ab0dd2faec628bd83c70beb384cea105f7a50a",
"templateCredsSetupCompleted": true
},
"name": "n8n - DataforSEO - 所有操作",
"tags": [
{
"id": "RhAmCaLYc9EkF42I",
"name": "n8n",
"createdAt": "2025-08-24T08:04:35.027Z",
"updatedAt": "2025-08-24T08:04:35.027Z"
}
],
"nodes": [
{
"id": "a8b86cae-fc03-433b-bca7-be4137f40b9b",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
-180,
-160
],
"webhookId": "e6d701fb-6b69-4949-bce8-ed178a439a13",
"parameters": {
"options": {
"customCss": "/* Grok UI — Dark, neon accents, soft glow */\n:root {\n /* Typography */\n --font-family: 'Inter', system-ui, -apple-system, Segoe UI, Roboto, Helvetica, Arial, 'Apple Color Emoji', 'Segoe UI Emoji';\n --font-weight-normal: 500;\n --font-weight-bold: 700;\n --font-size-body: 13px;\n --font-size-label: 13px;\n --font-size-test-notice: 12px;\n --font-size-input: 14px;\n --font-size-header: 22px;\n --font-size-paragraph: 14px;\n --font-size-link: 13px;\n --font-size-error: 12px;\n --font-size-html-h1: 28px;\n --font-size-html-h2: 22px;\n --font-size-html-h3: 18px;\n --font-size-html-h4: 16px;\n --font-size-html-h5: 13px;\n --font-size-html-h6: 12px;\n --font-size-subheader: 13px;\n\n /* Colors — Grok vibes */\n --color-background: #0b0e14; /* page bg */\n --color-test-notice-text: #f5d48a;\n --color-test-notice-bg: #1a1410;\n --color-test-notice-border: #4a3a22;\n\n --color-card-bg: #11131a; /* card bg */\n --color-card-border: #1f2430; /* card border */\n --color-card-shadow: rgba(155, 135, 245, 0.12);\n\n --color-link: #b8a6ff; /* links */\n --color-header: #eceff4; /* headings */\n --color-label: #c9ced8; /* form labels */\n --color-input-border: #2a3040; /* inputs */\n --color-input-text: #e6e9f0;\n --color-focus-border: #9b87f5; /* focus ring color */\n\n /* Accent + actions */\n --color-submit-btn-bg: linear-gradient(90deg, #6d5cff 0%, #b83aff 100%);\n --color-submit-btn-text: #0b0e14;\n --color-clear-button-bg: #2a3040;\n\n /* Status */\n --color-error: #ff5c7c;\n --color-required: #ff84d8;\n\n /* Content */\n --color-html-text: #c9ced8;\n --color-html-link: #b8a6ff;\n --color-header-subtext: #9aa3b2;\n\n /* Radii */\n --border-radius-card: 14px;\n --border-radius-input: 12px;\n --border-radius-clear-btn: 50%;\n --card-border-radius: 14px;\n\n /* Spacing */\n --padding-container-top: 28px;\n --padding-card: 24px;\n --padding-test-notice-vertical: 10px;\n --padding-test-notice-horizontal: 16px;\n --margin-bottom-card: 16px;\n --padding-form-input: 12px;\n --card-padding: 24px;\n --card-margin-bottom: 16px;\n\n /* Dimensions */\n --container-width: 520px; /* slightly wider for breathing room */\n --submit-btn-height: 46px;\n --checkbox-size: 18px;\n\n /* Effects */\n --box-shadow-card: 0 16px 48px 0 var(--color-card-shadow);\n --opacity-placeholder: 0.55;\n\n /* Extra Grok-y helpers */\n --gradient-accent: linear-gradient(90deg, #6d5cff 0%, #b83aff 100%);\n --focus-ring: 0 0 0 3px rgba(155, 135, 245, 0.35);\n}\n\n/* ===== Optional: polish the default n8n form elements ===== */\n\n/* Page / container */\nbody {\n background: var(--color-background);\n color: var(--color-html-text);\n font-family: var(--font-family);\n font-weight: var(--font-weight-normal);\n}\n\n/* Cards */\n.card,\n.n8n-form-card {\n background: var(--color-card-bg);\n border: 1px solid var(--color-card-border);\n border-radius: var(--card-border-radius);\n box-shadow: var(--box-shadow-card);\n}\n\n/* Headings */\nh1, h2, h3, h4, h5, h6 {\n color: var(--color-header);\n letter-spacing: 0.1px;\n}\n\n/* Labels */\nlabel {\n color: var(--color-label);\n font-weight: 600;\n}\n\n/* Inputs */\ninput[type=\"text\"],\ninput[type=\"email\"],\ninput[type=\"number\"],\ninput[type=\"url\"],\ninput[type=\"tel\"],\ntextarea,\nselect {\n background: #0f1218;\n color: var(--color-input-text);\n border: 1px solid var(--color-input-border);\n border-radius: var(--border-radius-input);\n padding: var(--padding-form-input);\n outline: none;\n transition: border-color 120ms ease, box-shadow 120ms ease, background 120ms ease;\n}\n\ninput::placeholder,\ntextarea::placeholder {\n opacity: var(--opacity-placeholder);\n}\n\n/* Focus glow */\ninput:focus,\ntextarea:focus,\nselect:focus {\n border-color: var(--color-focus-border);\n box-shadow: var(--focus-ring);\n}\n\n/* Checkboxes / radios */\ninput[type=\"checkbox\"],\ninput[type=\"radio\"] {\n width: var(--checkbox-size);\n height: var(--checkbox-size);\n accent-color: #9b87f5;\n border-radius: 6px;\n}\n\n/* Submit button */\nbutton[type=\"submit\"],\n.n8n-form-submit {\n background: var(--gradient-accent);\n color: var(--color-submit-btn-text);\n height: var(--submit-btn-height);\n border: 0;\n border-radius: 12px;\n font-weight: 700;\n letter-spacing: 0.2px;\n cursor: pointer;\n transition: transform 80ms ease, filter 120ms ease;\n}\nbutton[type=\"submit\"]:hover,\n.n8n-form-submit:hover {\n filter: brightness(1.06);\n}\nbutton[type=\"submit\"]:active,\n.n8n-form-submit:active {\n transform: translateY(1px);\n}\n\n/* Secondary / clear button */\n.n8n-form-clear,\nbutton[type=\"button\"] {\n background: var(--color-clear-button-bg);\n color: #d4d7de;\n border: 1px solid var(--color-input-border);\n border-radius: 12px;\n}\n\n/* Links */\na {\n color: var(--color-html-link);\n text-decoration: none;\n}\na:hover {\n text-decoration: underline;\n}\n\n/* Test notice / banner */\n.notice,\n.n8n-form-test-notice {\n color: var(--color-test-notice-text);\n background: var(--color-test-notice-bg);\n border: 1px solid var(--color-test-notice-border);\n border-radius: 10px;\n padding: var(--padding-test-notice-vertical) var(--padding-test-notice-horizontal);\n}\n\n/* Error states */\n.error,\ninput.error,\ntextarea.error,\nselect.error {\n border-color: var(--color-error) !important;\n box-shadow: 0 0 0 3px rgba(255, 92, 124, 0.25) !important;\n}\n.error-text {\n color: var(--color-error);\n font-size: var(--font-size-error);\n}\n\n/* Subtext */\n.form-subtext,\n.helper-text {\n color: var(--color-header-subtext);\n}\n\n/* Container width */\n.form-container,\n.n8n-form-container {\n max-width: var(--container-width);\n}\n",
"buttonLabel": "👉 Get Related Keywords"
},
"formTitle": "SEO Related Keyword Finder🚀",
"formFields": {
"values": [
{
"fieldLabel": "keyword",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "location_name",
"fieldOptions": {
"values": [
{
"option": "United States"
},
{
"option": "Algeria"
},
{
"option": "Angola"
},
{
"option": "Argentina"
},
{
"option": "Australia"
},
{
"option": "Austria"
},
{
"option": "Azerbaijan"
},
{
"option": "Bahrain"
},
{
"option": "Bangladesh"
},
{
"option": "Belgium"
},
{
"option": "Bolivia"
},
{
"option": "Bosnia and Herzegovina"
},
{
"option": "Brazil"
},
{
"option": "Bulgaria"
},
{
"option": "Burkina Faso"
},
{
"option": "Cambodia"
},
{
"option": "Cameroon"
},
{
"option": "Canada"
},
{
"option": "Chile"
},
{
"option": "Colombia"
},
{
"option": "Costa Rica"
},
{
"option": "Cote d'Ivoire"
},
{
"option": "Croatia"
},
{
"option": "Cyprus"
},
{
"option": "Czechia"
},
{
"option": "Denmark"
},
{
"option": "Ecuador"
},
{
"option": "Egypt"
},
{
"option": "El Salvador"
},
{
"option": "Estonia"
},
{
"option": "Finland"
},
{
"option": "France"
},
{
"option": "Germany"
},
{
"option": "Ghana"
},
{
"option": "Greece"
},
{
"option": "Guatemala"
},
{
"option": "Hong Kong"
},
{
"option": "Hungary"
},
{
"option": "India"
},
{
"option": "Indonesia"
},
{
"option": "Ireland"
},
{
"option": "Israel"
},
{
"option": "Italy"
},
{
"option": "Japan"
},
{
"option": "Jordan"
},
{
"option": "Kazakhstan"
},
{
"option": "Kenya"
},
{
"option": "Latvia"
},
{
"option": "Lithuania"
},
{
"option": "Malaysia"
},
{
"option": "Malta"
},
{
"option": "Mexico"
},
{
"option": "Moldova"
},
{
"option": "Monaco"
},
{
"option": "Morocco"
},
{
"option": "Myanmar (Burma)"
},
{
"option": "Netherlands"
},
{
"option": "New Zealand"
},
{
"option": "Nicaragua"
},
{
"option": "Nigeria"
},
{
"option": "North Macedonia"
},
{
"option": "Norway"
},
{
"option": "Pakistan"
},
{
"option": "Panama"
},
{
"option": "Paraguay"
},
{
"option": "Peru"
},
{
"option": "Philippines"
},
{
"option": "Poland"
},
{
"option": "Portugal"
},
{
"option": "Romania"
},
{
"option": "Saudi Arabia"
},
{
"option": "Senegal"
},
{
"option": "Serbia"
},
{
"option": "Singapore"
},
{
"option": "Slovakia"
},
{
"option": "Slovenia"
},
{
"option": "South Africa"
},
{
"option": "South Korea"
},
{
"option": "Spain"
},
{
"option": "Sri Lanka"
},
{
"option": "Sweden"
},
{
"option": "Switzerland"
},
{
"option": "Taiwan"
},
{
"option": "Thailand"
},
{
"option": "Tunisia"
},
{
"option": "Turkiye"
},
{
"option": "Ukraine"
},
{
"option": "United Arab Emirates"
},
{
"option": "United Kingdom"
},
{
"option": "Albania"
},
{
"option": "Uruguay"
},
{
"option": "Venezuela"
},
{
"option": "Vietnam"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "language_name",
"fieldOptions": {
"values": [
{
"option": "English"
},
{
"option": "Albanian"
},
{
"option": "Arabic"
},
{
"option": "Armenian"
},
{
"option": "Azeri"
},
{
"option": "Bengali"
},
{
"option": "Bosnian"
},
{
"option": "Bulgarian"
},
{
"option": "Chinese (Simplified)"
},
{
"option": "Chinese (Traditional)"
},
{
"option": "Croatian"
},
{
"option": "Czech"
},
{
"option": "Danish"
},
{
"option": "Dutch"
},
{
"option": "Estonian"
},
{
"option": "Finnish"
},
{
"option": "French"
},
{
"option": "German"
},
{
"option": "Greek"
},
{
"option": "Hebrew"
},
{
"option": "Hindi"
},
{
"option": "Hungarian"
},
{
"option": "Indonesian"
},
{
"option": "Italian"
},
{
"option": "Japanese"
},
{
"option": "Korean"
},
{
"option": "Latvian"
},
{
"option": "Lithuanian"
},
{
"option": "Macedonian"
},
{
"option": "Malay"
},
{
"option": "Norwegian"
},
{
"option": "Polish"
},
{
"option": "Portuguese"
},
{
"option": "Romanian"
},
{
"option": "Russian"
},
{
"option": "Serbian"
},
{
"option": "Slovak"
},
{
"option": "Slovenian"
},
{
"option": "Spanish"
},
{
"option": "Swedish"
},
{
"option": "Tagalog"
},
{
"option": "Thai"
},
{
"option": "Turkish"
},
{
"option": "Ukrainian"
},
{
"option": "Urdu"
},
{
"option": "Vietnamese"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Operation",
"fieldOptions": {
"values": [
{
"option": "related keywords🔑"
},
{
"option": "keyword suggestion💡"
},
{
"option": "get autocomplete🧩"
},
{
"option": "get subtopics📚"
},
{
"option": "people also ask🔍"
}
]
}
}
]
},
"formDescription": "✏️ Enter your target keyword\n📍 Choose the location\n🌐 Select the language"
},
"typeVersion": 2.2
},
{
"id": "75613162-339b-4792-9c21-300a84cd07eb",
"name": "相关关键词",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
-560
],
"parameters": {
"url": "https://api.dataforseo.com/v3/dataforseo_labs/google/related_keywords/live",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"jsonBody": "=[\n {\n \"keyword\": \"{{ $('Switch').item.json.keyword }}\",\n \"location_name\":\"{{ $('Switch').item.json.location_name }}\",\n \"language_name\":\"{{ $('Switch').item.json.language_name }}\",\n \"depth\": 3,\n \"include_seed_keyword\": false,\n \"include_serp_info\": true,\n \"ignore_synonyms\": false,\n \"include_clickstream_data\": false,\n \"replace_with_core_keyword\": false,\n \"limit\": 100\n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "IYTigP4HlUf6384U",
"name": "Data for SEO"
}
},
"typeVersion": 4.2
},
{
"id": "00881b6b-944e-448d-8786-2960602d9ad8",
"name": "Google Calendar MCP",
"type": "n8n-nodes-base.switch",
"position": [
760,
-200
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "related",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f1d6e4b2-6191-41a1-ad33-e1af098a2c0d",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "related keywords🔑"
}
]
},
"renameOutput": true
},
{
"outputKey": "sugges",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "04f77653-ef1b-46bd-a607-9e7af4185e08",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "keyword suggestion💡"
}
]
},
"renameOutput": true
},
{
"outputKey": "auto",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "32ed49a3-7107-45b3-b631-e9656f3ade19",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "get autocomplete🧩"
}
]
},
"renameOutput": true
},
{
"outputKey": "subtopic",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7c5cede4-f3e0-4015-bb6e-cb2abbac8bad",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "get subtopics📚"
}
]
},
"renameOutput": true
},
{
"outputKey": "also ask",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e5e713e3-dedf-4590-9b72-cc2414ce60d5",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "people also ask🔍"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "435d55c0-4f2a-434c-a4d0-b73625c14e34",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
300,
-160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "687cf18b-3f44-49bf-b984-8f080ccf0801",
"name": "operation",
"type": "string",
"value": "={{ $json.Operation }}"
},
{
"id": "88dc839b-684f-4dd4-b3df-5c17e0df7042",
"name": "keyword",
"type": "string",
"value": "={{ $json.keyword }}"
},
{
"id": "da2f072b-9e53-4ba8-80f4-2dc38be52aad",
"name": "location_name",
"type": "string",
"value": "={{ $json.location_name }}"
},
{
"id": "e69eaa8f-f71d-43d7-8152-6903a8867162",
"name": "language_name",
"type": "string",
"value": "={{ $json.language_name }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "f57d30ea-999a-47ad-807b-8dcfe562a9e2",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
2100,
-560
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "aef9fa8d-dd76-4d16-a2a6-708fb5e9ab43",
"name": "related keyword",
"type": "string",
"value": "= {{ $json.keyword_data.keyword }}"
},
{
"id": "9b6c6833-9a17-40a4-97cd-8c28168bb9c3",
"name": "keyword",
"type": "string",
"value": "={{ $('Switch').item.json.keyword }}"
},
{
"id": "809a4151-ab92-40e6-a8d2-4ed1a96a49aa",
"name": "keyword difficulty",
"type": "string",
"value": "={{ $json.keyword_data.keyword_properties.keyword_difficulty }}"
},
{
"id": "12caa5c0-3ffb-4bed-b2af-f139dbf15a9c",
"name": "search intent",
"type": "string",
"value": "={{ $json.keyword_data.search_intent_info.main_intent }}"
},
{
"id": "5d33a8a9-778b-40a6-9efb-acb8204c58fe",
"name": "last update",
"type": "string",
"value": "={{ $json.keyword_data.keyword_info.last_updated_time }}"
},
{
"id": "1a0d83e5-4651-4cc9-b282-1b58acd4bff2",
"name": "SERP Analysis",
"type": "string",
"value": "={{ $json.keyword_data.serp_info.serp_item_types.join(\",\") }}"
},
{
"id": "129ac304-872b-4772-bfd1-6382e6b8b71d",
"name": "search volume",
"type": "string",
"value": "={{ $json.keyword_data.keyword_info.search_volume }}"
},
{
"id": "1cf80f1f-dcec-4452-baa5-c5580d8aad24",
"name": "CPC",
"type": "string",
"value": "={{ $json.keyword_data.keyword_info.cpc }}"
},
{
"id": "de3fe02d-8f6b-4b52-807a-ca727f089a32",
"name": "compitition",
"type": "string",
"value": "={{ $json.keyword_data.keyword_info.competition_level }}"
},
{
"id": "1663de4d-4a53-4a0e-96bd-c437ad888e41",
"name": "type",
"type": "string",
"value": "related_keyword"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "419d2fee-2e8c-4e0a-abfe-2bc1f2ca3533",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
-560
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].items"
},
"typeVersion": 1
},
{
"id": "ff5790ac-3a24-4993-81db-9ac794a0c976",
"name": "分离输出1",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
-360
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].items"
},
"typeVersion": 1
},
{
"id": "63a738b1-cb97-4390-a767-86b4ce1197f9",
"name": "分离输出2",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
-160
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].items"
},
"typeVersion": 1
},
{
"id": "9e3c5450-9321-4983-b6d8-8a5698e08aab",
"name": "分离3",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
60
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].sub_topics"
},
"typeVersion": 1
},
{
"id": "c820bb1c-5f2c-4f9e-bf05-730a608b7797",
"name": "分离输出4",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
280
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].items"
},
"typeVersion": 1
},
{
"id": "a7ad86d2-5a6f-4078-b94a-9fd28e9cfe6e",
"name": "关键词建议",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
-360
],
"parameters": {
"url": "https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_suggestions/live",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"jsonBody": "=[\n {\n \"keyword\": \"{{ $('Switch').item.json.keyword }}\",\n \"location_name\":\"{{ $('Switch').item.json.location_name }}\",\n \"language_name\":\"{{ $('Switch').item.json.language_name }}\",\n \"depth\": 3,\n \"include_seed_keyword\": false,\n \"include_serp_info\": false,\n \"ignore_synonyms\": false,\n \"include_clickstream_data\": false,\n \"replace_with_core_keyword\": false,\n \"limit\": 100\n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "IYTigP4HlUf6384U",
"name": "Data for SEO"
}
},
"typeVersion": 4.2
},
{
"id": "abc58e82-a4b4-4db1-b02a-2b3b30a9ed83",
"name": "关键词建议表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-360
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#70193D"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "833ea8c4-6d65-4cee-bd28-14b9d884c7d8",
"name": "获取自动完成",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
-160
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/google/autocomplete/live/advanced",
"method": "POST",
"options": {},
"jsonBody": "=[\n {\n \"keyword\": \"{{ $('Switch').item.json.keyword }}\",\n \"location_name\":\"{{ $('Switch').item.json.location_name }}\",\n \"language_name\":\"{{ $('Switch').item.json.language_name }}\",\n \"client\": \"gws-wiz-serp\"\n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "IYTigP4HlUf6384U",
"name": "Data for SEO"
}
},
"typeVersion": 4.2
},
{
"id": "e4b9cc5a-a120-4b7c-a31b-0462ad0511e6",
"name": "获取子主题",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
60
],
"parameters": {
"url": "https://api.dataforseo.com/v3/content_generation/generate_sub_topics/live",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"jsonBody": "=[\n {\n \"topic\":\"{{ $('Switch').item.json.keyword }}\"\n \n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "IYTigP4HlUf6384U",
"name": "Data for SEO"
}
},
"typeVersion": 4.2
},
{
"id": "9a78b5a9-5ebc-4fe5-8c45-d1448219870b",
"name": "人们还问",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
280
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/google/organic/live/advanced",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"jsonBody": "=[\n {\n \"keyword\": \"{{ $('Switch').item.json.keyword }}\",\n \"location_name\":\"{{ $('Switch').item.json.location_name }}\",\n \"language_name\":\"{{ $('Switch').item.json.language_name }}\",\n \"depth\": 20,\n \"people_also_ask_click_depth\": 1\n \n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "IYTigP4HlUf6384U",
"name": "Data for SEO"
}
},
"typeVersion": 4.2
},
{
"id": "34e47468-0c60-427f-812e-bf093c317a71",
"name": "获取自动完成表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-160
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#26AFF4"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "b12faf3e-2f1c-41d3-9e1d-cabd95c94be3",
"name": "获取子主题表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
60
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#26F490"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "7078dcd3-3220-48a4-b0b1-f9b2df41a5c9",
"name": "人们还问表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
280
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#E1EB22"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "eabf4c58-85e2-4f73-85ed-107ff42fa330",
"name": "编辑字段4",
"type": "n8n-nodes-base.set",
"position": [
2100,
-160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bcfd6063-5f17-481e-90a4-ffb6c90e03f4",
"name": "primary keyword",
"type": "string",
"value": "={{ $('Switch').item.json.keyword }}"
},
{
"id": "82f4e7ef-214e-474f-87d8-e23bbffa02b0",
"name": "type",
"type": "string",
"value": "={{ $json.type }}"
},
{
"id": "6a3ca04d-af0a-474f-bfa6-386f302062b8",
"name": "get autocomplete",
"type": "string",
"value": "={{ $json.suggestion }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "22e11d3b-ad30-40fb-beb5-869fa32908ae",
"name": "编辑字段6",
"type": "n8n-nodes-base.set",
"position": [
2100,
60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bcfd6063-5f17-481e-90a4-ffb6c90e03f4",
"name": "primary keyword",
"type": "string",
"value": "={{ $('Switch').item.json.keyword }}"
},
{
"id": "82f4e7ef-214e-474f-87d8-e23bbffa02b0",
"name": "type",
"type": "string",
"value": "sub_topics"
},
{
"id": "6a3ca04d-af0a-474f-bfa6-386f302062b8",
"name": "sub topics",
"type": "string",
"value": "={{ $json[\"tasks[0].result[0].sub_topics\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "fdd8e7c2-97ce-4988-8f64-6601aabc7b03",
"name": "分离输出6",
"type": "n8n-nodes-base.splitOut",
"position": [
2340,
280
],
"parameters": {
"options": {},
"fieldToSplitOut": "items"
},
"typeVersion": 1
},
{
"id": "7adbf13a-efeb-4acd-897a-a107ef29955f",
"name": "编辑字段5",
"type": "n8n-nodes-base.set",
"position": [
2580,
280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "15852b78-13ef-49f3-a695-700ba72282d9",
"name": "tittle",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "34b819c3-5a0d-4a2a-b693-f02ad480b528",
"name": "type",
"type": "string",
"value": "={{ $json.type }}"
},
{
"id": "33e0aaeb-8351-4a50-bae0-2432f2e02d26",
"name": "discription",
"type": "string",
"value": "={{ $json.expanded_element[0].description }}"
},
{
"id": "15c90345-0326-474a-a667-2132ddcd0164",
"name": "url",
"type": "string",
"value": "={{ $json.expanded_element[0].url }}"
},
{
"id": "643bfc5a-1db3-410f-b0c4-4207c2ba8435",
"name": "domain name",
"type": "string",
"value": "={{ $json.expanded_element[0].domain }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "b03df472-0028-433a-a291-0b02e6d6b27a",
"name": "编辑字段2",
"type": "n8n-nodes-base.set",
"position": [
2100,
-360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "9b6c6833-9a17-40a4-97cd-8c28168bb9c3",
"name": "keyword",
"type": "string",
"value": "={{ $('Switch').item.json.keyword }}"
},
{
"id": "12caa5c0-3ffb-4bed-b2af-f139dbf15a9c",
"name": "search intent",
"type": "string",
"value": "={{ $json.search_intent_info.main_intent }}"
},
{
"id": "aef9fa8d-dd76-4d16-a2a6-708fb5e9ab43",
"name": "suggested keyword",
"type": "string",
"value": "= {{ $json.keyword }}"
},
{
"id": "5d33a8a9-778b-40a6-9efb-acb8204c58fe",
"name": "last update",
"type": "string",
"value": "= {{ $json.keyword_info.last_updated_time }}"
},
{
"id": "129ac304-872b-4772-bfd1-6382e6b8b71d",
"name": "search volume",
"type": "string",
"value": "={{ $json.keyword_info.search_volume }} "
},
{
"id": "1cf80f1f-dcec-4452-baa5-c5580d8aad24",
"name": "CPC",
"type": "string",
"value": "= {{ $json.keyword_info.cpc }}"
},
{
"id": "de3fe02d-8f6b-4b52-807a-ca727f089a32",
"name": "compitition",
"type": "string",
"value": "= {{ $json.keyword_info.competition }}"
},
{
"id": "1663de4d-4a53-4a0e-96bd-c437ad888e41",
"name": "type",
"type": "string",
"value": "suggested_keyword"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3852d7d0-238b-4799-879e-43414387233c",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
-360
],
"parameters": {
"color": 5,
"height": 460,
"content": "## 获取关键词"
},
"typeVersion": 1
},
{
"id": "228fe28f-4fcb-41c5-926d-d2d64fd6b8a0",
"name": "将操作添加到Google Sheets主表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
540,
-160
],
"parameters": {
"columns": {
"value": {
"Time": "={{ $('On form submission').item.json.submittedAt }}",
"keyword": "={{ $json.keyword }}",
"operation": "={{ $json.operation }}",
"language_name": "={{ $json.language_name }}",
"location_name": "={{ $json.location_name }}"
},
"schema": [
{
"id": "operation",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "operation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "location_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "language_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "language_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Time",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit#gid=0",
"cachedResultName": "summary"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "758a8e17-34da-482b-a678-e16b9d4a28c3",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-360
],
"parameters": {
"color": 5,
"height": 460,
"content": "## 切换"
},
"typeVersion": 1
},
{
"id": "b7bc7d6a-31f3-4689-ac6a-589afae253fc",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1140,
-760
],
"parameters": {
"color": 5,
"width": 260,
"height": 1240,
"content": "## 创建工作表"
},
"typeVersion": 1
},
{
"id": "b728b3a8-72bf-4950-a74f-45a5567a4fda",
"name": "相关关键词表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-560
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#9426F4"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "28eccb35-34b2-4c7b-8d36-456a5577843d",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1460,
-760
],
"parameters": {
"color": 5,
"width": 260,
"height": 1240,
"content": "## DataforSEO API请求"
},
"typeVersion": 1
},
{
"id": "fae6c44e-7069-4278-b756-14f859847574",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
-760
],
"parameters": {
"color": 5,
"width": 260,
"height": 1240,
"content": "## 从API调用获取数据"
},
"typeVersion": 1
},
{
"id": "35249966-22b2-4123-9806-055bbb2f6bdd",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2280,
-760
],
"parameters": {
"color": 5,
"width": 260,
"height": 1000,
"content": "## 将数据附加到工作表"
},
"typeVersion": 1
},
{
"id": "42475196-e399-4bc2-b258-fbd26daf545c",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2740,
120
],
"parameters": {
"color": 5,
"width": 260,
"height": 420,
"content": "## 将数据附加到工作表"
},
"typeVersion": 1
},
{
"id": "0d121e1e-19f1-4574-87de-4b22c8d15026",
"name": "过滤人们还问",
"type": "n8n-nodes-base.filter",
"position": [
2100,
280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "50240059-95d3-4242-a151-68f70a13819f",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.type }}",
"rightValue": "people_also_ask"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6ba0d98b-6115-48e4-8550-9554c737f869",
"name": "检查字段是否非空",
"type": "n8n-nodes-base.if",
"position": [
60,
-160
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c002e63c-5c1a-4487-9698-8debcdc55348",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.keyword }}",
"rightValue": ""
},
{
"id": "9d012e48-3243-4f9d-8dc6-c66d90c6b3e3",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.location_name }}",
"rightValue": ""
},
{
"id": "63d75301-d0df-4870-8d28-447264c7317f",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.language_name }}",
"rightValue": ""
},
{
"id": "1fab5942-ef6f-437d-9127-11d14d594644",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Operation }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "e07e4b2a-ada3-41ce-baf5-faa8f3467720",
"name": "添加到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
-560
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('related keyword sheet').item.json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "2df32bdd-390c-4e2d-8353-8a76acaf93a2",
"name": "添加到表格1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
-360
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('keyword suggestion sheet').item.json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "d65cacaa-71c7-4bc1-8e7c-fcc44606837b",
"name": "添加到表格2",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
-160
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "related keyword",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "related keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword difficulty",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "keyword difficulty",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "search intent",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "search intent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last update",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "last update",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SERP Analysis",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "SERP Analysis",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "search volume",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "search volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "compitition",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "compitition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('get autocomplete sheet').item.json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "6052e855-ba5b-4e05-870c-e667a31ee8bc",
"name": "添加到表格3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
60
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('get subtopics sheet').item.json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
},
{
"id": "f48efe65-7dd8-4821-bdd7-0b058f85840e",
"name": "添加到表格4",
"type": "n8n-nodes-base.googleSheets",
"position": [
2820,
280
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('people also ask sheet').item.json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder🚀 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "A3ebjIB2M27srsju",
"name": "Nima40"
}
},
"typeVersion": 4.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "199c0a3f-e2d2-494a-b84e-ccc0f779464f",
"connections": {
"Switch": {
"main": [
[
{
"node": "related keyword sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "keyword suggestion sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "get autocomplete sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "get subtopics sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "people also ask sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Split Out1": {
"main": [
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Split Out2": {
"main": [
[
{
"node": "Edit Fields4",
"type": "main",
"index": 0
}
]
]
},
"Split Out3": {
"main": [
[
{
"node": "Edit Fields6",
"type": "main",
"index": 0
}
]
]
},
"Split Out4": {
"main": [
[
{
"node": "Filter people also ask",
"type": "main",
"index": 0
}
]
]
},
"Split Out6": {
"main": [
[
{
"node": "Edit Fields5",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Add operation to main sheet in Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Add to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Add to Sheet1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields4": {
"main": [
[
{
"node": "Add to Sheet2",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields5": {
"main": [
[
{
"node": "Add to Sheet4",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields6": {
"main": [
[
{
"node": "Add to Sheet3",
"type": "main",
"index": 0
}
]
]
},
"Add to Sheet4": {
"main": [
[]
]
},
"get subtopics": {
"main": [
[
{
"node": "Split Out3",
"type": "main",
"index": 0
}
]
]
},
"people also ask": {
"main": [
[
{
"node": "Split Out4",
"type": "main",
"index": 0
}
]
]
},
"related keyword": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"get autocomplete": {
"main": [
[
{
"node": "Split Out2",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Check If fields not empty",
"type": "main",
"index": 0
}
]
]
},
"keyword suggestion": {
"main": [
[
{
"node": "Split Out1",
"type": "main",
"index": 0
}
]
]
},
"get subtopics sheet": {
"main": [
[
{
"node": "get subtopics",
"type": "main",
"index": 0
}
]
]
},
"people also ask sheet": {
"main": [
[
{
"node": "people also ask",
"type": "main",
"index": 0
}
]
]
},
"related keyword sheet": {
"main": [
[
{
"node": "related keyword",
"type": "main",
"index": 0
}
]
]
},
"Filter people also ask": {
"main": [
[
{
"node": "Split Out6",
"type": "main",
"index": 0
}
]
]
},
"get autocomplete sheet": {
"main": [
[
{
"node": "get autocomplete",
"type": "main",
"index": 0
}
]
]
},
"keyword suggestion sheet": {
"main": [
[
{
"node": "keyword suggestion",
"type": "main",
"index": 0
}
]
]
},
"Check If fields not empty": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Add operation to main sheet in Google Sheets": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
01 使用AI媒体买家分析Facebook广告表现并将洞察发送到Google Sheets
使用Gemini AI分析Facebook广告并将洞察发送到Google Sheets
If
Set
Code
+13
34 节点JJ Tham
市场调研
我的工作流79
使用Google Sheets和MailerSend构建完整的电子邮件CRM系统
If
Set
Wait
+6
34 节点Nima Salimi
社交媒体
我的工作流11
通过RapidAPI批量导出亚马逊产品评论到Google Sheets
If
Set
Code
+7
11 节点Hunyao
市场调研
工作流信息
难度等级
高级
节点数量39
分类1
节点类型9
作者
Nima Salimi
@salimi- Marketing Automation Specialist - Marketing Workflow Architect - Optimizing Marketing Processes
外部链接
在 n8n.io 查看 →
分享此工作流