使用Gemini AI和Elementor为多个客户生成并安排SEO博客文章
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 39 个节点。主要使用 If, N8n, Set, Code, FormTrigger 等节点。 使用Gemini AI和Elementor为多个客户生成并安排SEO博客文章
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (39)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "76af76d4-cfae-4342-b527-309d1d9c43de",
"name": "简单记忆",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
1712,
496
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "3fddc873-7483-46ef-bc5a-6729bf7ec581",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1600,
304
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.7
},
{
"id": "398bb877-34a6-4204-bdf3-719423b322bd",
"name": "修改提示",
"type": "n8n-nodes-base.code",
"position": [
1264,
304
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e1702723-4ff9-4f80-8405-8bac5ee7ee09",
"name": "WordpressAuth",
"type": "n8n-nodes-base.code",
"position": [
2224,
304
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d500686b-7914-4325-851d-b889fd1f50f4",
"name": "WordpressData",
"type": "n8n-nodes-base.set",
"position": [
2848,
304
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "fad8390e-595d-4492-848e-be1b4e5ee87c",
"name": "n8n | 获取工作流",
"type": "n8n-nodes-base.n8n",
"position": [
976,
1568
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e6ad5757-a0a2-452b-bd6f-410f7a2d3504",
"name": "n8n | 更新",
"type": "n8n-nodes-base.n8n",
"position": [
1472,
1568
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d0fd2146-6acc-4313-9362-54e079c9c6a2",
"name": "Google Sheets 触发器",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-48,
1568
],
"parameters": {},
"typeVersion": 1
},
{
"id": "56c46e19-f360-4927-a825-3d49a7feaf89",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
1088
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "359f2a11-f22a-40e0-affa-34b3e3776bf1",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
1360
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "739281f0-c304-4bd5-86e6-3521a4523a13",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
1360
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "9fadbbed-1cd8-4e87-b1cf-603e7aefd1fd",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
1360
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "c819521e-9deb-4923-ba74-a560dcd75e42",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
896,
1360
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "61a08fa6-fb14-425c-9b0f-fa652af43b33",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1152,
1360
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "7821b092-da0c-417e-832a-1b058937b3a2",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1408,
1360
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "ca1cf371-9b5a-4670-b7a8-e46eff285bb3",
"name": "写入 JSON",
"type": "n8n-nodes-base.code",
"position": [
720,
1568
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1b90ec10-75ec-4963-bab7-72db6cebf757",
"name": "替换值",
"type": "n8n-nodes-base.set",
"position": [
1232,
1568
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1c058130-ff9e-4c5a-a739-a76fe26c2f9c",
"name": "格式化为 'values'",
"type": "n8n-nodes-base.set",
"position": [
432,
1568
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "bbfc9f00-98bc-4118-9f13-1492bb69158f",
"name": "获取所有值",
"type": "n8n-nodes-base.googleSheets",
"position": [
160,
1568
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "67c51a03-2763-4c50-8b1e-78fd15e18230",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
1552,
496
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8cb6e4d2-2762-40eb-8967-26bdb9b5df55",
"name": "表单提交时1",
"type": "n8n-nodes-base.formTrigger",
"position": [
576,
1152
],
"webhookId": "4e898d0d-43f3-480b-8fc2-f35251cebec9",
"parameters": {},
"typeVersion": 2.2
},
{
"id": "48c0e618-0645-4099-b533-e65c3dfb9f98",
"name": "HTML 转 Elementor 格式",
"type": "n8n-nodes-base.code",
"position": [
1984,
304
],
"parameters": {},
"typeVersion": 2
},
{
"id": "aca038d9-b416-4b2b-ba62-68ca6f03eaff",
"name": "客户端",
"type": "n8n-nodes-base.googleSheets",
"position": [
1424,
304
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "c7eb2ac1-3226-46f8-90eb-2befcadc86a7",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
384,
0
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c63be428-d078-40ab-8b6d-bdd2019c46f8",
"name": "获取表中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
592,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "01cc9f4c-5e9c-4ff5-8410-563fa0c80325",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
800,
0
],
"parameters": {},
"typeVersion": 3
},
{
"id": "5e74dcba-e57d-4ad0-8e0b-3500e7005ce9",
"name": "映射数据",
"type": "n8n-nodes-base.set",
"position": [
1088,
304
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4f149537-c127-4a10-8912-182cb9150e4b",
"name": "在表格中追加行",
"type": "n8n-nodes-base.googleSheets",
"position": [
3264,
304
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "333b161a-d742-4073-91d7-70e367796d56",
"name": "在表格中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
3712,
624
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "e774a082-b4ff-4e7e-86d1-7906121ab422",
"name": "如果已安排",
"type": "n8n-nodes-base.if",
"position": [
3488,
304
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "88e448a8-401e-4622-a84c-cfbcf56a83bb",
"name": "生成图片",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
2432,
304
],
"parameters": {},
"executeOnce": true,
"typeVersion": 1
},
{
"id": "6049ed30-217f-4542-9d5b-0d151ecbc904",
"name": "发布博客",
"type": "n8n-nodes-base.httpRequest",
"position": [
3056,
304
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "fdd3b1c5-55fd-40f1-b919-62a3abb59373",
"name": "上传图像",
"type": "n8n-nodes-base.httpRequest",
"position": [
2640,
304
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "fe79ec34-7944-4882-8b33-c71fa1a88a7a",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
2384,
128
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "04dcfe84-2239-467b-a7b5-76ec7bb4d8e6",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
2800,
128
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "cb79d548-24a4-47af-827e-f7d4ecf3f76c",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1232,
128
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "597eed4e-68c5-4e4d-ace5-77a82cd38ac9",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
-128
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "10e63d44-fc54-4778-ac57-5aa6cf563245",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
3696,
512
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "2936ab9d-ccdc-48c8-9ffc-10422b46bcae",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-416,
-128
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Client": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "HTML to Elementor Format",
"type": "main",
"index": 0
}
]
]
},
"Map Data": {
"main": [
[
{
"node": "Modify Prompt",
"type": "main",
"index": 0
}
]
]
},
"Post Blog": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Write JSON": {
"main": [
[
{
"node": "n8n | get wf",
"type": "main",
"index": 0
}
]
]
},
"If Scheduled": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Upload Image": {
"main": [
[
{
"node": "WordpressData",
"type": "main",
"index": 0
}
]
]
},
"n8n | get wf": {
"main": [
[
{
"node": "Replace values",
"type": "main",
"index": 0
}
]
]
},
"Modify Prompt": {
"main": [
[
{
"node": "Client",
"type": "main",
"index": 0
}
]
]
},
"Simple Memory": {
"ai_memory": [
[
{
"node": "AI Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"WordpressAuth": {
"main": [
[
{
"node": "Generate an image",
"type": "main",
"index": 0
}
]
]
},
"WordpressData": {
"main": [
[
{
"node": "Post Blog",
"type": "main",
"index": 0
}
]
]
},
"Get all values": {
"main": [
[
{
"node": "Format to 'values'",
"type": "main",
"index": 0
}
]
]
},
"Replace values": {
"main": [
[
{
"node": "n8n | update",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Map Data",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Generate an image": {
"main": [
[
{
"node": "Upload Image",
"type": "main",
"index": 0
}
]
]
},
"Format to 'values'": {
"main": [
[
{
"node": "Write JSON",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "If Scheduled",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"On form submission1": {
"main": [
[
{
"node": "Map Data",
"type": "main",
"index": 0
}
]
]
},
"Update row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Get all values",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"HTML to Elementor Format": {
"main": [
[
{
"node": "WordpressAuth",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
博客发布器 – 完整的AI驱动内容研究、创作、优化与发布自动化
使用 Gemini、Ideogram AI 和 WordPress 自动化博客创建与发布
If
Set
Code
+9
35 节点Incrementors
内容创作
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
基于 YouTube 视频的自主博客发布
使用 ChatGPT、Sheets、Apify、Pexels 和 WordPress 从 YouTube 视频自主发布博客
If
Set
Code
+18
80 节点Oriol Seguí
内容创作
批量SEO内容生成与带AI图片的Webflow草稿创建（模板）
使用GPT、Gemini图片和Webflow草稿创建进行批量SEO内容生成
If
Set
Code
+18
54 节点Dahiana
内容创作
1. 播放列表详情设置机器人副本
使用 Suno、GPT-4、Runway 和 Creatomate 创建 AI 生成的 YouTube 音乐播放列表
If
Set
Code
+22
203 节点Joseph
内容创作
基于Gemini AI、Supabase和Nano-Banana的端到端博客创建自动化
使用Gemini AI、Supabase和Nano-Banana实现端到端博客创建自动化
If
Set
Code
+16
51 节点Muhammad Asadullah
内容创作
工作流信息
难度等级
高级
节点数量39
分类2
节点类型15
作者
Zain Khan
@zainI partner with businesses to streamline processes and accelerate growth through intelligent AI automation and Web/mobile Development. Leveraging deep expertise in GPT-4, LangChain, and n8n, I develop AI-powered agents and sophisticated LLM pipelines.
外部链接
在 n8n.io 查看 →
分享此工作流