我的子工作流 3
高级
这是一个Marketing领域的自动化工作流，包含 55 个节点。主要使用 Set, Filter, SplitOut, GoogleDrive, HttpRequest 等节点。 使用DataForSEO进行自动化SEO关键词与SERP分析，打造高转化内容
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "vJUoHTm2PsqJRRY0",
"meta": {
"instanceId": "5beb610c1ddaf0be11e46fd8edaf0e265560c93f1638f8638d6a8a7adf44f57e",
"templateCredsSetupCompleted": true
},
"name": "我的子工作流 3",
"tags": [],
"nodes": [
{
"id": "b36cdb0a-9804-4559-9d81-3b03a6f098de",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
180,
720
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c8ce845c-959b-445e-b974-51743a413c43",
"name": "设置主字段",
"type": "n8n-nodes-base.set",
"position": [
1020,
720
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "aa4a4bf0-6017-4b89-8069-556aec11cbcc",
"name": "设置相关关键词字段",
"type": "n8n-nodes-base.set",
"position": [
2700,
-100
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4a01d529-af72-4839-8cbc-6101a6f65963",
"name": "拆分出相关关键词",
"type": "n8n-nodes-base.splitOut",
"position": [
2500,
-100
],
"parameters": {},
"typeVersion": 1
},
{
"id": "95436779-dd32-4cfd-9f87-526ef0f818c9",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "81e1ecec-a5e7-43c7-b8e4-cd2063f53055",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aae6d7dc-8673-40cc-8a08-c72703d78afd",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c3099493-34c5-47b8-bbad-c8a15010d534",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4c3a17df-3fd6-46f0-9b62-cf7cd009ace0",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
4340,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8d7a1074-df18-4127-9338-4667c38bea52",
"name": "Google Sheets 关键词研究模板",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
720
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "700a1485-7061-4a13-a9b5-58a19585658d",
"name": "Google Drive 创建关键词文件夹",
"type": "n8n-nodes-base.googleDrive",
"position": [
660,
720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9a7a078a-dfa3-49b5-9326-1b4eac9aa393",
"name": "Google Drive 复制关键词模板",
"type": "n8n-nodes-base.googleDrive",
"position": [
860,
720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f2232b9d-49d9-4b07-b780-03dbf2817339",
"name": "HTTP 关键词建议",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
260
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "8e21b4d7-b815-4c1b-b3ea-f35c9b2a4b37",
"name": "HTTP 相关关键词",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
-100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "6439a767-ab07-4c28-a3ae-21ba493f8657",
"name": "添加相关关键词到相关关键词表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2920,
-100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "2f40158b-b769-4a7b-bc7c-f48984fbcc5a",
"name": "添加相关关键词到主所有关键词变体表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
-100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "268bf914-05b2-4d56-b32f-5f1940b2c0ae",
"name": "添加关键词到关键词建议表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2940,
260
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "c9565457-b25a-4d68-bb2e-20214f766339",
"name": "添加关键词到主所有关键词表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
260
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "716fda24-7b62-4021-8ad9-37a61bb4f276",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "99ada347-09c8-4cc0-abd7-fba96dc012fa",
"name": "添加关键词到主所有关键词表格1",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "b9ba52a9-1ae9-4ec3-980f-12ff1b44f56d",
"name": "HTTP 关键词想法",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
620
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f77329cf-9135-4e3b-bf4d-9fc8949ba2d5",
"name": "拆分出关键词建议",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "dc8584f6-eada-4d8c-a602-bb85f038c88c",
"name": "设置关键词建议字段",
"type": "n8n-nodes-base.set",
"position": [
2720,
260
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "a4dfe603-fc06-4d99-8216-1ee23813303f",
"name": "拆分出关键词想法",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
620
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5fe90a28-c938-4d37-ae14-9517d6c06a44",
"name": "设置关键词想法字段",
"type": "n8n-nodes-base.set",
"position": [
2720,
620
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "035ac1ab-943b-4221-8912-627d9134e429",
"name": "添加关键词到关键词想法表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2940,
620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "aa17b8f1-e2d3-4a0e-b4c1-15da54671a44",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "56257dbe-cd4e-4fe7-867e-3951c113d171",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "69c76030-00df-4d3d-b06f-38fbd8afce01",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d557c699-e12e-4d97-b1ac-96c056570985",
"name": "拆分出自动完成",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
960
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7f79435c-cfd2-4d97-8b90-1f0889714ec9",
"name": "设置自动完成字段",
"type": "n8n-nodes-base.set",
"position": [
2720,
960
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7c8720b5-b690-4484-bb7f-8c9e92e2ba35",
"name": "便利贴12",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8609079e-cc2f-4c63-b75f-85d647012396",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "266f7a8f-425e-4c34-983c-bd6ffbf32988",
"name": "HTTP 自动完成",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
960
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "26337f73-7aab-46f8-89a6-30d71039f3c8",
"name": "添加自动完成到自动完成表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2940,
960
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "9fb77120-fc89-4bc0-a828-f672355cd6ed",
"name": "拆分出子主题",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
1300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5854a87d-bc8c-47b4-9880-70b5df0f8f11",
"name": "设置子主题字段",
"type": "n8n-nodes-base.set",
"position": [
2720,
1300
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1a16c4e5-7d18-4b4a-a8dc-cb682ace2269",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
1180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "14c28d83-6802-4458-929a-ac1b6bf0c376",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
1180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4347928c-c2d1-487c-8499-a56f3fce7149",
"name": "HTTP 子主题",
"type": "n8n-nodes-base.httpRequest",
"position": [
2280,
1300
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "a2c66ce2-598b-4f52-b703-bf2a5289f0ba",
"name": "添加子主题到子主题表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2940,
1300
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "90802d0d-fd83-4fc6-8f92-542f6a51474e",
"name": "添加子主题到主关键词表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
960
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "7edff654-4cee-4726-8cfe-60652a4ba1f6",
"name": "过滤搜索结果页面",
"type": "n8n-nodes-base.filter",
"position": [
2720,
1620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0506b631-dc32-4e79-8149-8250abe23433",
"name": "过滤\"People Also Ask\"",
"type": "n8n-nodes-base.filter",
"position": [
2720,
1820
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "115ab146-8992-405c-b413-89fee7813ac7",
"name": "设置搜索结果页面字段",
"type": "n8n-nodes-base.set",
"position": [
2920,
1620
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d2e3dec2-e201-46d1-b77a-d0c06cb93c0b",
"name": "拆分出\"People Also Ask\"",
"type": "n8n-nodes-base.splitOut",
"position": [
2920,
1820
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5ee2a485-4b62-4c04-9316-726ffa5b6d4e",
"name": "设置\"People Also Ask\"字段",
"type": "n8n-nodes-base.set",
"position": [
3140,
1820
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "69f9fa86-f0ed-4272-a503-c52818d3e87c",
"name": "便利贴11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
1520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ab453289-7ce5-4cdd-bfd7-c3475385084c",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
3860,
1720
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ac9eb623-61d4-419a-9179-a7efb3498799",
"name": "HTTP 搜索结果页面",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
1820
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7bb43620-1b92-4469-8c40-5fda93621aa1",
"name": "拆分出搜索结果页面和\"People Also Ask\"",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
1820
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c3ca3b7c-7c07-4e03-8d5a-b0df7f92853f",
"name": "添加子主题到主关键词表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
3940,
1300
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "47b89892-7e8f-420b-bd57-a1fc16db6d51",
"name": "添加搜索结果页面到搜索结果页面表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
3140,
1620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "d6bbe89b-b862-4f29-ae8f-6947439470db",
"name": "添加\"People Also Ask\"到\"People Also Ask\"表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
3360,
1820
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "865c02d3-c571-4cf7-b82d-0d6e8d54812b",
"name": "添加\"People Also Ask\"到主关键词变体表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
3900,
1820
],
"parameters": {},
"typeVersion": 4.5
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "41fb75f4-c5ce-4479-97f8-0206bbd382b8",
"connections": {
"Filter PAA": {
"main": [
[
{
"node": "Split Out PAA",
"type": "main",
"index": 0
}
]
]
},
"HTTP SERPs": {
"main": [
[
{
"node": "Split Out SERPs and PAA",
"type": "main",
"index": 0
}
]
]
},
"Filter SERPs": {
"main": [
[
{
"node": "Set SERP Fields",
"type": "main",
"index": 0
}
]
]
},
"Split Out PAA": {
"main": [
[
{
"node": "Set PAA Fields",
"type": "main",
"index": 0
}
]
]
},
"HTTP Subtopics": {
"main": [
[
{
"node": "Split Out Subtopics",
"type": "main",
"index": 0
}
]
]
},
"Set PAA Fields": {
"main": [
[
{
"node": "Add PAA to PAA Sheet",
"type": "main",
"index": 0
}
]
]
},
"Set Main Fields": {
"main": [
[
{
"node": "HTTP Related Keywords",
"type": "main",
"index": 0
},
{
"node": "HTTP Keyword Suggestions",
"type": "main",
"index": 0
},
{
"node": "HTTP Keyword Ideas",
"type": "main",
"index": 0
},
{
"node": "HTTP Autocomplete",
"type": "main",
"index": 0
},
{
"node": "HTTP Subtopics",
"type": "main",
"index": 0
},
{
"node": "HTTP SERPs",
"type": "main",
"index": 0
}
]
]
},
"Set SERP Fields": {
"main": [
[
{
"node": "Add SERPs to SERP Sheet",
"type": "main",
"index": 0
}
]
]
},
"HTTP Autocomplete": {
"main": [
[
{
"node": "Split Out Autocomplete",
"type": "main",
"index": 0
}
]
]
},
"HTTP Keyword Ideas": {
"main": [
[
{
"node": "Split Out KW Ideas",
"type": "main",
"index": 0
}
]
]
},
"Split Out KW Ideas": {
"main": [
[
{
"node": "Set KW Ideas Fields",
"type": "main",
"index": 0
}
]
]
},
"Set KW Ideas Fields": {
"main": [
[
{
"node": "Add KWs to Keyword Ideas Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out Subtopics": {
"main": [
[
{
"node": "Set Subtopics Fields",
"type": "main",
"index": 0
}
]
]
},
"Add PAA to PAA Sheet": {
"main": [
[
{
"node": "Add PAA to Master KW Variations Sheet",
"type": "main",
"index": 0
}
]
]
},
"Set Subtopics Fields": {
"main": [
[
{
"node": "Add Subtopics to Subtopics Sheet",
"type": "main",
"index": 0
}
]
]
},
"HTTP Related Keywords": {
"main": [
[
{
"node": "Split Out Related KWs",
"type": "main",
"index": 0
}
]
]
},
"Set Related KW Fields": {
"main": [
[
{
"node": "Add Related KWs to Related KWs Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out Related KWs": {
"main": [
[
{
"node": "Set Related KW Fields",
"type": "main",
"index": 0
}
]
]
},
"Split Out Autocomplete": {
"main": [
[
{
"node": "Set Autocomplete Fields",
"type": "main",
"index": 0
}
]
]
},
"Set Autocomplete Fields": {
"main": [
[
{
"node": "Add Autocomplete to Autocomplete Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out SERPs and PAA": {
"main": [
[
{
"node": "Filter SERPs",
"type": "main",
"index": 0
},
{
"node": "Filter PAA",
"type": "main",
"index": 0
}
]
]
},
"HTTP Keyword Suggestions": {
"main": [
[
{
"node": "Split Out KW Suggestions",
"type": "main",
"index": 0
}
]
]
},
"Set KW Suggestion Fields": {
"main": [
[
{
"node": "Add KWs to Keyword Suggestions Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out KW Suggestions": {
"main": [
[
{
"node": "Set KW Suggestion Fields",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Copy KW Template": {
"main": [
[
{
"node": "Set Main Fields",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Create KW Folder": {
"main": [
[
{
"node": "Google Drive Copy KW Template",
"type": "main",
"index": 0
}
]
]
},
"Add KWs to Keyword Ideas Sheet": {
"main": [
[
{
"node": "Add KWs to Master All KW Sheet1",
"type": "main",
"index": 0
}
]
]
},
"Add Subtopics to Subtopics Sheet": {
"main": [
[
{
"node": "Add Subtopics to Master KW sheet",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Google Sheets KW Research Template",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets KW Research Template": {
"main": [
[
{
"node": "Google Drive Create KW Folder",
"type": "main",
"index": 0
}
]
]
},
"Add KWs to Keyword Suggestions Sheet": {
"main": [
[
{
"node": "Add KWs to Master All KW Sheet",
"type": "main",
"index": 0
}
]
]
},
"Add Related KWs to Related KWs Sheet": {
"main": [
[
{
"node": "Add Related KWs to Master all KW Variations Sheet",
"type": "main",
"index": 0
}
]
]
},
"Add Autocomplete to Autocomplete Sheet": {
"main": [
[
{
"node": "Add Subtopics to Master KWs Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
AI房地产经纪人：端到端运营自动化（网络、数据、语音）
AI房地产经纪人：端到端运营自动化（网络、数据、语音）
If
Set
Code
+16
45 节点Sam Yassine
销售
## 🤖 **LIGUA033/LOREALCANTARA - 其他生成工作流**
基于AI的Meta广告分析与创建：使用Gemini、GPT-4.1 Mini和广告管理器
If
Set
Wait
+13
61 节点Daniel Setzermann
人工智能
我的工作流5
使用AI邮件个性化的自动化LinkedIn潜在客户生成（未完成）
If
Set
Code
+9
37 节点Matthieu
销售
CSV到HubSpot上传器（动态字段映射与Google Sheets集成）
具有动态字段映射和Google Sheets集成的CSV到HubSpot上传器
If
Set
Code
+10
36 节点PollupAI
人工智能
Overpass 潜在客户生成系统
使用 OpenStreetMap 数据生成商业线索并保存到 Google Sheets
If
Set
Code
+12
27 节点Akram Kadri
销售
工作流信息
难度等级
高级
节点数量55
分类1
节点类型8
作者
Sam Yassine
@samyassineAI Automation Expert | n8n Wizard | Workflow Simplifier I turn complex processes into powerful automations using n8n. Whether you're scaling your business or saving hours of manual work, I've got plug-and-play templates that bring AI and automation together—fast, smart, and easy. Let’s make your systems work for you.
外部链接
在 n8n.io 查看 →
分享此工作流