AI生成LinkedIn帖子含人工审批
高级
这是一个Social Media, Multimodal AI领域的自动化工作流，包含 19 个节点。主要使用 Code, Merge, Filter, HttpRequest, GoogleSheets 等节点。 使用GPT-4、GoToHuman和Blotato的AI生成LinkedIn帖子含人工审批
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (19)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "efb474b59b0341d7791932605bd9ff04a6c7ed9941fdd53dc4a2e4b99a6f9439",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "cebd910c-6c4b-4ff4-95d8-a9bd7f2e6bf0",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
-40
],
"parameters": {
"color": 5,
"width": 1200,
"height": 1140,
"content": "## ✅ 步骤2 — 使用OpenAI生成标题"
},
"typeVersion": 1
},
{
"id": "b8a2624c-e353-47af-b2c7-81d74155499d",
"name": "工具：注入创意",
"type": "@n8n/n8n-nodes-langchain.toolThink",
"position": [
800,
760
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e2be1cd1-158f-4599-ae5c-fbc0a39eb64e",
"name": "解析器：从想法中提取 JSON",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
980,
760
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"Caption\": \"\"\n }\n]\n"
},
"typeVersion": 1.2
},
{
"id": "f7456d62-8055-4d03-abc0-f4d633ca8e82",
"name": "openai",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
620,
780
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1",
"cachedResultName": "gpt-4.1"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "ghJTvay8CvwXDsXz",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "f962953e-7f69-454d-a904-c9813db3a6c4",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-580,
-40
],
"parameters": {
"width": 980,
"height": 1140,
"content": "## ✅ 步骤1 — 从Google Sheets获取今日主题"
},
"typeVersion": 1
},
{
"id": "c539e883-f18d-49f3-980f-3b743145274a",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1640,
-40
],
"parameters": {
"color": 3,
"width": 320,
"height": 1140,
"content": "### 1. 设置GoToHuman"
},
"typeVersion": 1
},
{
"id": "e39e9b93-f95e-4227-808f-031f30b4f579",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1980,
-40
],
"parameters": {
"color": 4,
"width": 380,
"height": 1140,
"content": "## ✅ 步骤4 — 通过Blotato发布到LinkedIn"
},
"typeVersion": 1
},
{
"id": "5e73c568-4158-422c-b045-c208a5dc018b",
"name": "每日触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-420,
480
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "f9c4b8af-412d-4057-825b-9c07f3bf96be",
"name": "测试",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-460,
740
],
"parameters": {},
"typeVersion": 1
},
{
"id": "719914a6-a513-4cb7-9e73-c04a68be4239",
"name": "获取今日想法",
"type": "n8n-nodes-base.googleSheets",
"position": [
-120,
540
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154/edit?usp=drivesdk",
"cachedResultName": "SampleTopics"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "WsgMg14OYooIdvn7",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "5f200d10-1bf3-4325-945f-1f49e22a77ce",
"name": "输出今日日期",
"type": "n8n-nodes-base.code",
"position": [
40,
660
],
"parameters": {
"jsCode": "const today = new Date();\ntoday.setHours(0, 0, 0, 0); // Normalize to start of day\n\nreturn [\n {\n json: {\n today: today.toISOString().split('T')[0] // e.g., \"2025-07-30\"\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "7885628d-316a-4c9d-b6b2-0a476c289b03",
"name": "仅保留今日想法",
"type": "n8n-nodes-base.merge",
"position": [
180,
440
],
"parameters": {
"mode": "combine",
"options": {},
"advanced": true,
"mergeByFields": {
"values": [
{
"field1": "Date",
"field2": "today"
}
]
}
},
"typeVersion": 3.2
},
{
"id": "e1be8e6f-cf27-4afd-b817-819ec952de4d",
"name": "AI代理：为LinkedIn创建标题",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
680,
500
],
"parameters": {
"text": "=Idea: {{ $json.idea }}",
"options": {
"systemMessage": "=your job is to expand on the idea and turn it into a social media post that will capture users attention. keep it to two sentances using emoji's\n\nOutupt like this. \n\n[\n {\n \"Caption\": \"\"\n }\n]"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.9
},
{
"id": "f138a0e6-aec9-4030-9567-c3b18e388270",
"name": "在Google Sheets中标记完成",
"type": "n8n-nodes-base.googleSheets",
"position": [
1320,
440
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Get Today's Idea').item.json.Date }}",
"complete": "Yes"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "idea",
"type": "string",
"display": true,
"required": false,
"displayName": "idea",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "caption",
"type": "string",
"display": true,
"required": false,
"displayName": "caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "complete",
"type": "string",
"display": true,
"required": false,
"displayName": "complete",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Date"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154/edit?usp=drivesdk",
"cachedResultName": "SampleTopics"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "WsgMg14OYooIdvn7",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "148a16f9-7bc9-4bf2-8676-520c1fedce07",
"name": "保存标题到Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1320,
700
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Get Today's Idea').item.json.Date }}",
"caption": "={{ $json.output[0].Caption }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "idea",
"type": "string",
"display": true,
"required": false,
"displayName": "idea",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "caption",
"type": "string",
"display": true,
"required": false,
"displayName": "caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "complete",
"type": "string",
"display": true,
"required": false,
"displayName": "complete",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "STATUS",
"type": "string",
"display": true,
"required": false,
"displayName": "STATUS",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Date"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oC3dbRkGF_bSIKuFKtSJsYS-ZypT2uk7jPsAni8y154/edit?usp=drivesdk",
"cachedResultName": "SampleTopics"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "WsgMg14OYooIdvn7",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "78f79c4f-067d-4388-8a53-7b298d15c342",
"name": "请求人工审批",
"type": "@gotohuman/n8n-nodes-gotohuman.gotoHuman",
"position": [
1680,
420
],
"webhookId": "6d42cd89-8e27-4747-8636-87d6adcd9f77",
"parameters": {
"fields": {
"value": {
"text": "={{ $json.caption }}"
},
"schema": [
{
"id": "text",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "text (text)",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"text"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"additionalFields": {},
"reviewTemplateID": {
"__rl": true,
"mode": "list",
"value": "RoUEcfHxQX17pM8Roj7i",
"cachedResultName": "My Review Step (RoUEcfHxQX17pM8Roj7i)"
}
},
"credentials": {
"gotoHumanApi": {
"id": "DDAwJMAARwFCF0fA",
"name": "gotoHuman account"
}
},
"typeVersion": 1
},
{
"id": "0e72f635-22b8-432a-b90f-4d9c0ad7a94f",
"name": "仅在批准时保留",
"type": "n8n-nodes-base.filter",
"position": [
1820,
720
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "4966b55f-f10b-415a-bc81-f8fedfc60573",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.response }}",
"rightValue": "approved"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c433a60f-b108-42fe-9eb0-78bd280ab68c",
"name": "发布到LinkedIn",
"type": "n8n-nodes-base.httpRequest",
"position": [
2140,
700
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={\n \"post\": {\n \"accountId\": \"your account id\",\n \"target\": {\n \"targetType\": \"linkedin\"\n },\n \"content\": {\n \"text\": \"{{ $('Ask Human for approval').item.json.responseValues.text.value }}\",\n \"platform\": \"linkedin\",\n \"mediaUrls\": []\n }\n }\n}\n",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "blotato-api-key",
"value": "your api key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "91e7834b-4280-40e4-aad1-4015c21ef33a",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-580,
-280
],
"parameters": {
"color": 6,
"width": 2940,
"height": 200,
"content": "# 🤖 使用OpenAI、GoToHuman和Blotato自动发布LinkedIn帖子"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Test": {
"main": [
[
{
"node": "Get Today's Idea",
"type": "main",
"index": 0
},
{
"node": "Output Today's Date",
"type": "main",
"index": 0
}
]
]
},
"openai": {
"ai_languageModel": [
[
{
"node": "AI Agent: Create caption for linkedin",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Daily Trigger": {
"main": [
[
{
"node": "Get Today's Idea",
"type": "main",
"index": 0
}
]
]
},
"Get Today's Idea": {
"main": [
[
{
"node": "Keep only todays idea",
"type": "main",
"index": 0
}
]
]
},
"Output Today's Date": {
"main": [
[
{
"node": "Keep only todays idea",
"type": "main",
"index": 1
}
]
]
},
"Keep only if approved": {
"main": [
[
{
"node": "Post to Linkedin",
"type": "main",
"index": 0
}
]
]
},
"Keep only todays idea": {
"main": [
[
{
"node": "AI Agent: Create caption for linkedin",
"type": "main",
"index": 0
}
]
]
},
"Ask Human for approval": {
"main": [
[
{
"node": "Keep only if approved",
"type": "main",
"index": 0
}
]
]
},
"Tool: Inject Creativity": {
"ai_tool": [
[
{
"node": "AI Agent: Create caption for linkedin",
"type": "ai_tool",
"index": 0
}
]
]
},
"Save caption to google sheets": {
"main": [
[
{
"node": "Ask Human for approval",
"type": "main",
"index": 0
}
]
]
},
"Parser: Extract JSON from Idea": {
"ai_outputParser": [
[
{
"node": "AI Agent: Create caption for linkedin",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"AI Agent: Create caption for linkedin": {
"main": [
[
{
"node": "Save caption to google sheets",
"type": "main",
"index": 0
},
{
"node": "Mark complete in google sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 社交媒体, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
播客笔记记录器
使用GPT和Gemini结合性能数据创建高转化率Meta广告脚本
Set
Code
Merge
+7
24 节点Robert Breen
文档提取
播客笔记记录器
使用GPT和Gemini结合性能数据创建高转化率Meta广告脚本
Set
Code
Merge
+8
16 节点Robert Breen
潜在客户开发
使用 Apify + GPT-4o-mini 从标签分析生成 Instagram 标题
使用 Apify + GPT-4o-mini 从标签分析生成 Instagram 标题
Set
Code
Merge
+8
17 节点Robert Breen
内容创作
使用Google Sheets、GPT-4o和电子邮件生成营销活动ROI报告
使用Google Sheets、GPT-4o和电子邮件生成营销活动ROI报告
Code
Merge
Aggregate
+7
16 节点Robert Breen
AI 摘要总结
使用GPT-4洞察和PDF.co从Google Sheets生成营销报告
使用GPT-4洞察和PDF.co从Google Sheets生成营销报告
Code
Merge
Aggregate
+8
15 节点Robert Breen
文档提取
内容生成器 v3
AI驱动博客自动化：使用GPT-4生成并发布SEO文章至WordPress和Twitter
If
Set
Code
+25
144 节点Jay Emp0
内容创作
工作流信息
难度等级
高级
节点数量19
分类2
节点类型13
作者
Robert Breen
@rbreenProfessional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.
外部链接
在 n8n.io 查看 →
分享此工作流