使用GPT-4o-mini的技术SEO审计与多格式报告（Sheets-Email）
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 45 个节点。主要使用 Set, Xml, Code, Html, Gmail 等节点。 使用GPT-4o-mini的技术SEO审计与多格式报告（Sheets/Email）
前置要求
- •Google 账号和 Gmail API 凭证
- •HTTP Webhook 端点（n8n 会自动生成）
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (45)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "8a80c29c7b31662c1620f54d32e4b278d8e292907f82f13f4d9417196de2f737"
},
"nodes": [
{
"id": "405c9eb3-4935-4bce-8535-c7145eb923ee",
"name": "迭代页面",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-940,
940
],
"parameters": {},
"typeVersion": 3
},
{
"id": "71c3059f-eb20-4534-8b20-7142436821d0",
"name": "拆分输出2",
"type": "n8n-nodes-base.splitOut",
"onError": "continueErrorOutput",
"position": [
-920,
560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "abb16e31-affb-4e2f-91c6-827c8058c3fd",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
-640,
1060
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "cacaf3cb-35de-4f4c-8163-65006045af76",
"name": "OpenAI1",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-260,
1060
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "12882dff-b5a1-4a36-b036-afc2a5c2f0b7",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
80,
1060
],
"parameters": {},
"typeVersion": 2
},
{
"id": "32f6dd34-7f01-46f2-8532-e06dd6d0eddd",
"name": "语言",
"type": "n8n-nodes-base.set",
"position": [
-760,
100
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "cf5111ad-fac8-412b-a81b-80d4b7d63001",
"name": "映射站点地图",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
160,
100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "d354a2e4-adfb-4f65-b990-686bbab717e2",
"name": "XML1",
"type": "n8n-nodes-base.xml",
"position": [
340,
160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2e3d7ca5-99c2-473f-ba1b-aa8f92c08414",
"name": "Split Out8",
"type": "n8n-nodes-base.splitOut",
"position": [
-440,
860
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d05b2a0b-7f4c-4a50-9f7b-477b6c31b017",
"name": "转换为 HTML",
"type": "n8n-nodes-base.code",
"position": [
-160,
860
],
"parameters": {},
"typeVersion": 2
},
{
"id": "fc902b64-326b-46a1-8c3d-4aa19f3df7d1",
"name": "HTML 转 JSON",
"type": "n8n-nodes-base.code",
"position": [
240,
940
],
"parameters": {},
"typeVersion": 2
},
{
"id": "12f847db-9a8c-4f23-8ed9-e5d8b0397c90",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
640,
940
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "6e51c3c6-684d-4a9a-862b-8736474b6a15",
"name": "拆分输出10",
"type": "n8n-nodes-base.splitOut",
"position": [
440,
940
],
"parameters": {},
"typeVersion": 1
},
{
"id": "edd2b88d-0cd0-434f-a980-466903dd560d",
"name": "HTML 格式查看器",
"type": "n8n-nodes-base.html",
"position": [
240,
760
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6a3ed4a5-6fe8-407c-aa6e-ac46ac5baee4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b74286f1-7f13-4896-8d56-268b3daf7be2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1420,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fc7afe86-bcd5-4c5f-aadf-4069987e4604",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7f868c33-62e2-48cc-a110-778aca100647",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
940
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "95bc1147-ef3f-4233-9948-0b0e15cb4ad4",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c1d154d1-e0df-42e6-bdb6-e3e795377109",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b251939f-59b6-4157-b8ba-53864044214b",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1760,
560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0b84fe7a-40d6-451a-958b-047751c29b86",
"name": "删除重复网站",
"type": "n8n-nodes-base.removeDuplicates",
"notes": "En caso de haber duplicados o sitemap mal hecho",
"position": [
-300,
560
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0e04ec90-f9d9-499e-822b-c7468689f119",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
640
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e266450e-0efa-4736-a0dc-8d1601739144",
"name": "响应Webhook",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
460,
760
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "0e26ee0e-537a-48a3-a714-f51c3764fac5",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"notes": "using: pag=example.com\n\nReal example:\nhttps://yourspace.app.n8n.cloud/webhook-test/bbdf9cca-e5f4-4bae-afb1-a893ffb51b18?pag=onlineseoscan.com",
"position": [
-1220,
180
],
"webhookId": "bbdf9cca-e5f4-4bae-afb1-a893ffb51b18",
"parameters": {},
"typeVersion": 2
},
{
"id": "08724753-a7f0-42b4-98a8-27218351d045",
"name": "手动",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1220,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "761f8aec-0d4b-4f13-8f09-944b3cc2eb1b",
"name": "UA轮换1",
"type": "n8n-nodes-base.code",
"position": [
-580,
100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "2276dc45-424d-402c-91f9-ca2407b02c5f",
"name": "网页 URL",
"type": "n8n-nodes-base.set",
"position": [
-1020,
0
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b4b162cd-89f3-4714-b1d3-b4978dcf294c",
"name": "方法检测",
"type": "n8n-nodes-base.code",
"position": [
-400,
100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f6281ede-c275-41c2-a07e-4f63db8af903",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8301d1c6-eb47-475f-a52a-20ee9cae1f2a",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1620,
320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9ce090a3-d88f-4dc3-bd14-b1e83176806c",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c9cebdbc-439c-483c-a6b3-48ee40e23017",
"name": "便利贴11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1580,
-280
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ef1e4f68-7fec-4a6f-a29f-777746bf3035",
"name": "便利贴12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2800,
-300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "394ef001-cee7-4ab7-81cb-1ece312c5215",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2800,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45a80d37-d6a3-44c5-ad8e-a34eb68c9810",
"name": "请求错误",
"type": "n8n-nodes-base.stopAndError",
"position": [
-20,
-40
],
"parameters": {},
"typeVersion": 1
},
{
"id": "91e46b5c-bb1f-402c-b1cb-bd82cf6ef11d",
"name": "站点地图错误",
"type": "n8n-nodes-base.stopAndError",
"position": [
340,
0
],
"parameters": {},
"executeOnce": false,
"typeVersion": 1
},
{
"id": "93ebaaa2-a7fb-4e54-9de8-98a745ce08b7",
"name": "请求robots文件",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
-220,
100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "dbb51e35-fb38-468f-8a63-8aa35e6d4abc",
"name": "提取站点地图URL",
"type": "n8n-nodes-base.code",
"position": [
-20,
100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "638b530d-3e1e-402f-8fab-0da1b649cc0c",
"name": "请求错误1",
"type": "n8n-nodes-base.stopAndError",
"position": [
-620,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6df241e2-ea7e-43ba-bc9a-51e6e6828b84",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ebfcc63c-ec98-4563-9d66-a9bfb391e151",
"name": "过滤 URL",
"type": "n8n-nodes-base.filter",
"position": [
-720,
560
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "45065db2-c50a-4c82-a35b-1bea939cd791",
"name": "过滤内部 URL",
"type": "n8n-nodes-base.filter",
"notes": "Filter sitemap.xml, usa ese filtro para excluir urls del sitemap",
"position": [
-500,
560
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "202e2e8f-a6c7-4f8b-80c2-5dffabc93d4c",
"name": "发送结果",
"type": "n8n-nodes-base.gmail",
"position": [
240,
580
],
"webhookId": "f620297a-43b1-4be4-925d-2ce10c2f3864",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "0d871973-a01f-48d7-a26e-503a059321be",
"name": "获取网页内容",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
-440,
1060
],
"parameters": {},
"typeVersion": 4.2
}
],
"pinData": {},
"connections": {
"Code": {
"main": [
[
{
"node": "Iterar Páginas",
"type": "main",
"index": 0
}
]
]
},
"XML1": {
"main": [
[
{
"node": "Split Out2",
"type": "main",
"index": 0
}
]
]
},
"MANUAL": {
"main": [
[
{
"node": "URL WEB",
"type": "main",
"index": 0
}
]
]
},
"OpenAI1": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"To html": {
"main": [
[
{
"node": "Send Results",
"type": "main",
"index": 0
},
{
"node": "Html to JSON",
"type": "main",
"index": 0
},
{
"node": "HTML format viewer",
"type": "main",
"index": 0
}
]
]
},
"URL WEB": {
"main": [
[
{
"node": "LANGUAGE",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "LANGUAGE",
"type": "main",
"index": 0
}
]
]
},
"LANGUAGE": {
"main": [
[
{
"node": "UA Rotativo1",
"type": "main",
"index": 0
}
]
]
},
"Filter URL": {
"main": [
[
{
"node": "Filter URL Intern",
"type": "main",
"index": 0
}
]
]
},
"Req robots": {
"main": [
[
{
"node": "extract sitemap url",
"type": "main",
"index": 0
}
],
[
{
"node": "Req Error",
"type": "main",
"index": 0
}
]
]
},
"Split Out2": {
"main": [
[
{
"node": "Filter URL",
"type": "main",
"index": 0
}
],
[
{
"node": "Req Error1",
"type": "main",
"index": 0
}
]
]
},
"Split Out8": {
"main": [
[
{
"node": "To html",
"type": "main",
"index": 0
}
]
]
},
"Split Out10": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Obtener Contenido Web",
"type": "main",
"index": 0
}
]
]
},
"Html to JSON": {
"main": [
[
{
"node": "Split Out10",
"type": "main",
"index": 0
}
]
]
},
"UA Rotativo1": {
"main": [
[
{
"node": "Method detect",
"type": "main",
"index": 0
}
]
]
},
"Method detect": {
"main": [
[
{
"node": "Req robots",
"type": "main",
"index": 0
}
]
]
},
"Maping Sitemap": {
"main": [
[
{
"node": "XML1",
"type": "main",
"index": 0
}
],
[
{
"node": "Sitemap Error",
"type": "main",
"index": 0
}
]
]
},
"Iterar Páginas": {
"main": [
[
{
"node": "Split Out8",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Filter URL Intern": {
"main": [
[
{
"node": "Eliminar Webs Duplicadas",
"type": "main",
"index": 0
}
]
]
},
"HTML format viewer": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
},
"extract sitemap url": {
"main": [
[
{
"node": "Maping Sitemap",
"type": "main",
"index": 0
}
]
]
},
"Obtener Contenido Web": {
"main": [
[
{
"node": "OpenAI1",
"type": "main",
"index": 0
}
]
]
},
"Eliminar Webs Duplicadas": {
"main": [
[
{
"node": "Iterar Páginas",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用GPT-4o AI分析和多格式报告运行完整技术SEO审计
使用GPT-4o AI分析和多格式报告运行完整技术SEO审计
Set
Xml
Code
+14
45 节点Oriol Seguí Rotllant
人工智能
使用GPT 5 Nano和Google Sheets的网站SEO常见问题生成器
使用GPT 5 Nano和Google Sheets的网站SEO常见问题生成器
Set
Xml
Code
+11
35 节点Oriol Seguí
内容创作
使用GPT-5 nano和Yoast SEO自动化WordPress SEO优化
使用GPT-5 nano和Yoast SEO自动化WordPress SEO优化
Set
Code
Gmail
+11
35 节点Oriol Seguí
杂项
基于 YouTube 视频的自主博客发布
使用 ChatGPT、Sheets、Apify、Pexels 和 WordPress 从 YouTube 视频自主发布博客
If
Set
Code
+18
80 节点Oriol Seguí
内容创作
AI驱动YouTube产品评论自动分析
基于Apify和GPT的AI驱动YouTube产品评论自动分析
Set
Code
Gmail
+10
25 节点Oriol Seguí
市场调研
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
