自动化网站关键词SEO追踪器
高级
这是一个Marketing领域的自动化工作流，包含 25 个节点。主要使用 Set, Code, Gmail, Switch, WhatsApp 等节点。 在Google搜索结果中跟踪SEO关键词位置（Google Sheets + SerpAPI集成）
前置要求
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (25)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "5OVS6Bo8q2fhZjDC",
"meta": {
"instanceId": "b3c467df4053d13fe31cc98f3c66fa1d16300ba750506bfd019a0913cec71ea3",
"templateCredsSetupCompleted": true
},
"name": "自动化网站关键词SEO追踪器",
"tags": [],
"nodes": [
{
"id": "f28674c5-4159-4625-9d3f-9131ffdb420a",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1160,
1080
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6f4ae15a-464e-4f45-af0e-b2a5382185af",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cecac1ac-a3d8-4606-b95c-5f4d7ffd40b8",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
360,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7df3db45-e6db-4040-a9a1-b195f2e71ef8",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
660
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6dce41f8-9489-49e5-8b13-955af918e981",
"name": "映射自然搜索结果数组",
"type": "n8n-nodes-base.set",
"position": [
-300,
180
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "06c29c8b-fe87-4fc6-81ae-f74cf6cd3daf",
"name": "Google搜索结果请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
-540,
180
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f8b88a80-3325-4777-9d92-658ac80f6f35",
"name": "设置关键词",
"type": "n8n-nodes-base.code",
"position": [
-760,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4a965b72-7c58-44df-ab55-3f2748d2fa07",
"name": "网站URL位置查找器",
"type": "n8n-nodes-base.code",
"position": [
-80,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8e145c1b-2b5a-44b2-b04d-a4ebce555d0d",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1440,
400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fa779385-7aca-40db-8650-81d5c16e7fdb",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1060,
-180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6d027192-0ee0-41d3-8336-133551802ebd",
"name": "点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1380,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c528f973-0eee-4f7e-b905-ac09310d9a22",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-720,
1080
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "c13f9537-4104-411a-8b41-cd9b0f3de0f7",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
-940,
1080
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "84c8e8bc-da22-4d4d-a036-e544b879b44b",
"name": "Google Sheets 触发器",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-1380,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "87f4811b-f6f2-4e86-a309-0be8fabb07ba",
"name": "获取行（未检查列）",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
180
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "5e51a61b-f067-4af7-86d9-70eb85a9ea09",
"name": "更新检查状态列（设为已检查）",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
180
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "5920519e-2ad8-4a37-8905-9ca6bf25a7ce",
"name": "WhatsApp开始检查通知",
"type": "n8n-nodes-base.whatsApp",
"position": [
-420,
940
],
"webhookId": "40158389-94c6-41da-83e9-560fe7136e30",
"parameters": {},
"typeVersion": 1
},
{
"id": "d40f5338-c0ed-4fe8-96e7-e47884980308",
"name": "Gmail开始检查通知",
"type": "n8n-nodes-base.gmail",
"position": [
-420,
1200
],
"webhookId": "9094e916-9dfa-43a6-9c3a-507b7f759804",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "65697b95-f66d-4bbb-8cd9-e5014466b07b",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-600,
-180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "46df2de6-0ec3-4d02-a101-eaa74e7a6233",
"name": "通知开关",
"type": "n8n-nodes-base.switch",
"position": [
320,
180
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "d9b43876-cabc-4ac3-b93c-89bc74071a1c",
"name": "发送改进邮件",
"type": "n8n-nodes-base.gmail",
"position": [
480,
480
],
"webhookId": "975b7325-dbdb-4667-b7f3-a0d6f78f0141",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "4ff11769-ceec-48da-a2d0-57ab337b4678",
"name": "发送改进WhatsApp消息",
"type": "n8n-nodes-base.whatsApp",
"position": [
480,
660
],
"webhookId": "dfd7717c-7af2-4311-8e4f-1f85598bb87a",
"parameters": {},
"typeVersion": 1
},
{
"id": "e29fd730-3790-49f5-89b4-d665d850e607",
"name": "发送下降邮件",
"type": "n8n-nodes-base.gmail",
"position": [
940,
140
],
"webhookId": "54feb101-63bc-413c-bb6e-a56b7dc04dfb",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "2bfdf0f7-bb4d-4c10-a9fa-ff579c3ba7f8",
"name": "发送下降WhatsApp消息",
"type": "n8n-nodes-base.whatsApp",
"position": [
940,
320
],
"webhookId": "2ffec798-1222-4988-ac5e-528fe33a2deb",
"parameters": {},
"typeVersion": 1
},
{
"id": "99345bcc-baf8-4f0a-9223-bd4d340d09ad",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
900
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "38fc33fc-c04b-4496-b549-2d3bbc712d6d",
"connections": {
"Google Sheets": {
"main": [
[
{
"node": "WA Start Checks Notification",
"type": "main",
"index": 0
},
{
"node": "GMAIL Start Checks Notification",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets2": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Set Keyword (s)": {
"main": [
[
{
"node": "Google Serp Request",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
},
"Google Serp Request": {
"main": [
[
{
"node": "Map Organic Results Array",
"type": "main",
"index": 0
}
]
]
},
"Notifications Switch": {
"main": [
[],
[
{
"node": "Send Email Dropped",
"type": "main",
"index": 0
},
{
"node": "Send WA Message Dropped",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Email Improved",
"type": "main",
"index": 0
},
{
"node": "Send WA Message Improved",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Get Row (notChecked Column)",
"type": "main",
"index": 0
}
]
]
},
"Web URL Position Finder": {
"main": [
[
{
"node": "Update Check Status Column (to Checked)",
"type": "main",
"index": 0
}
]
]
},
"Map Organic Results Array": {
"main": [
[
{
"node": "Web URL Position Finder",
"type": "main",
"index": 0
}
]
]
},
"Get Row (notChecked Column)": {
"main": [
[
{
"node": "Set Keyword (s)",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Get Row (notChecked Column)",
"type": "main",
"index": 0
}
]
]
},
"Update Check Status Column (to Checked)": {
"main": [
[
{
"node": "Notifications Switch",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
LinkedIn潜在客户抓取与数据丰富副本
使用Apollo.io、LinkedIn API、Mail.so和GPT-3.5生成并丰富LinkedIn潜在客户
If
Set
Code
+8
53 节点Joseph
销售
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
If
Set
Code
+21
40 节点Immanuel
人工智能
使用AI、ElevenLabs和多平台发布创建和审批POV视频
使用AI、ElevenLabs和多平台发布创建和审批POV视频（TikTok/IG/YT）
If
Set
Code
+20
60 节点Immanuel
设计
音乐生成工作流
使用 Suno API、Flux、Runway 和 Creatomate 生成 AI 歌曲和音乐视频
Set
Wait
Merge
+16
60 节点Joseph
其他
YouTube短视频生成器
使用Flux、Runway、Eleven Labs和Creatomate生成AI YouTube短视频
Set
Code
Wait
+11
32 节点Joseph
人工智能
测验短视频生成器
使用Sonnet 3.5、Pinecone和Creatomate生成谜语短视频并发布到YouTube
If
Code
Wait
+13
32 节点Joseph
其他
工作流信息
难度等级
高级
节点数量25
分类1
节点类型11
作者
Joseph
@mjombaAutomation expert specializing in building smart, scalable workflows using tools like n8n, Make, and Airtable. I help businesses save time, reduce manual work, and grow faster with tailored automation solutions. Feel free to reach out at joseph@uppfy.com to discuss your project.
外部链接
在 n8n.io 查看 →
分享此工作流