LinkedIn帖子生成与审批自动化
高级
这是一个AI, Marketing领域的自动化工作流，包含 18 个节点。主要使用 If, Set, Gmail, Switch, LinkedIn 等节点，结合人工智能技术实现智能自动化。 基于OpenAI、Google表格和邮件审批工作流的AI生成LinkedIn帖子
前置要求
- •Google 账号和 Gmail API 凭证
- •LinkedIn API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (18)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "w9YVsuUtlNgXOEAQ",
"meta": {
"instanceId": "58a9e858b82757a75629d435ec0da2448ad5d9e906a9ce3b7dcbb64c90fda9fe",
"templateCredsSetupCompleted": true
},
"name": "LinkedIn帖子生成与审批自动化",
"tags": [
{
"id": "3bzbXbpZW83y48aK",
"name": "content-approval",
"createdAt": "2025-05-13T18:45:19.225Z",
"updatedAt": "2025-05-13T18:45:19.225Z"
},
{
"id": "9SfWdyKRFVbPxrNL",
"name": "post-generator",
"createdAt": "2025-05-13T18:45:09.255Z",
"updatedAt": "2025-05-13T18:45:09.255Z"
},
{
"id": "VWnkUEKQKJB2WmbL",
"name": "linkedin",
"createdAt": "2025-05-13T18:45:04.175Z",
"updatedAt": "2025-05-13T18:45:04.175Z"
}
],
"nodes": [
{
"id": "d0f86395-aeec-4284-a2d5-26db2dfebd53",
"name": "获取图像",
"type": "n8n-nodes-base.httpRequest",
"position": [
1592,
2120
],
"parameters": {
"url": "={{ $('Get Data from Sheets').item.json.Image }}",
"options": {}
},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "b8ca88a6-aaf1-4191-8b75-9a63b746af77",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-260,
2595
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "8e4e294f-56d4-4317-aea8-ea258527f55a",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
268,
2815
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "7OVQwPA6RZRwFmwI",
"name": "OpenAI Account"
}
},
"typeVersion": 1.2
},
{
"id": "d262684e-7671-4602-ba77-4270441a69fb",
"name": "从表格获取数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
-40,
2595
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "Pending",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8/edit?usp=drivesdk",
"cachedResultName": "LinkedIn Post Automation"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Gs7mfT220sbLQ7PS",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "93d3e57f-a22d-4c04-9ccc-7ee655bedbdb",
"name": "生成帖子内容",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
180,
2595
],
"parameters": {
"text": "=# LinkedIn Post Generation\n\n## Post Description:\n{{ $json[\"Post Description\"] }}\n\n## Instructions:\n{{ $json[\"Instructions\"] }}\n\n---\n\n**Task:**\nUsing the information above, generate the content for a LinkedIn post:\n- Use the Description and Instructions to create a new post.\n- Ensure your output is positive, professional, clear, and follows all provided instructions and feedback.\n- Do not include any explanations, just the final post content only, ready to publish on LinkedIn.\n- Limit to 1300 characters.\n- If the user demands to keep the same post as the Post Descrioption (in the instructions), then keep the same post content as provided in the Post Description, and output it.",
"messages": {
"messageValues": [
{
"message": "=You are an expert social media and LinkedIn content writer.\n\nYou will be provided with:\n- A brief post description\n- Specific instructions from the user\n\nPlease follow these steps:\n\n1. Initial Creation:\nIf you are given a post description and instructions, write a polished, professionally worded LinkedIn post suitable for sharing. Strictly follow the instructions and ensure the message is engaging and succinct.\nIf instructed, add a call to action or particular phrase (for example, \"Connect with me\" at the bottom).\n\n2. Formatting:\nKeep the tone positive, inclusive, and professional.\nAdd relevant hashtags in small case.\nLimit the content to within 1300 characters.\nPlace the call to action or special instruction at the end if requested.\nOutput ONLY the final LinkedIn post content. Do NOT include any explanations, markdown, headings, or commentary—just the post text, ready to copy and share on LinkedIn."
}
]
},
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "6ea121f4-661c-4dd4-a0bc-7edb8a0b884a",
"name": "数据格式化1",
"type": "n8n-nodes-base.set",
"position": [
556,
2595
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bded6f56-99e2-4f1a-be41-27a8dd417844",
"name": "Post Content",
"type": "string",
"value": "={{ $json.text }}"
},
{
"id": "c222c42e-b639-4a74-a1b0-7a3e6e141d55",
"name": "Post Description",
"type": "string",
"value": "={{ $('Get Data from Sheets').item.json['Post Description'] }}"
},
{
"id": "14775ff7-e005-4a86-9623-c322365f7d3a",
"name": "Instructions",
"type": "string",
"value": "={{ $('Get Data from Sheets').item.json.Instructions }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "a00ec081-07c0-4f8a-9139-6606a65236ff",
"name": "发送内容确认",
"type": "n8n-nodes-base.gmail",
"position": [
776,
2495
],
"webhookId": "29614d41-05c1-44af-93a6-4831a27f9331",
"parameters": {
"sendTo": "shindearyan179@gmail.com",
"message": "=Generated Post:\n{{ $json['Post Content'] }}\n\n----------\n\nPost Description:\n{{ $json['Post Description'] }}\n\n----------\n\nInstructions:\n{{ $json.Instructions }}",
"options": {},
"subject": "Approval for LinkedIn Post",
"operation": "sendAndWait",
"formFields": {
"values": [
{
"fieldType": "dropdown",
"fieldLabel": "Confirm Content?",
"fieldOptions": {
"values": [
{
"option": "Yes"
},
{
"option": "No"
},
{
"option": "Cancel"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Any Changes?"
}
]
},
"responseType": "customForm"
},
"credentials": {
"gmailOAuth2": {
"id": "n47Kn2N5BwXYv6eA",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "5a1e8061-ef79-4974-888d-8670e60a1b0c",
"name": "内容确认逻辑",
"type": "n8n-nodes-base.switch",
"position": [
996,
2495
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Yes",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "99ec185e-80ac-451d-bb69-662f84a7cf52",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.data['Confirm Content?'] }}",
"rightValue": "Yes"
}
]
},
"renameOutput": true
},
{
"outputKey": "No",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "77031007-a912-4b9b-9cca-846c57ffaec8",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.data['Confirm Content?'] }}",
"rightValue": "No"
}
]
},
"renameOutput": true
},
{
"outputKey": "Cancel",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e94de530-6451-48aa-892c-924a9c41cfb0",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.data['Confirm Content?'] }}",
"rightValue": "Cancel"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "c139fda0-4be1-4ad7-bb28-802b7150365d",
"name": "重新生成帖子内容",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1216,
2670
],
"parameters": {
"text": "=Apply the modification requests on the following LinkedIn post. Besides applying the reqested modifications, return the same linkedin post.\n\nLinkedIn post:\n```\n{{ $('Data Formatting 1').item.json['Post Content'] }}\n```\n\nChange requests:\n{{ $('Send Content Confirmation').item.json.data['Any Changes?'] }}\n\n**Task:**\nUsing the information above, update the LinkedIn post content:\n- Do not include any explanations, just the final post content only (with all the change requests included in the post), ready to publish on LinkedIn.\n- Limit to 1300 characters.\n- If the user demands to keep the same post as the Post Description (in the instructions), then keep the same post content as provided in the Post Description, and output it.",
"promptType": "define"
},
"typeVersion": 1.6
},
{
"id": "b8587578-03a6-4975-8907-667628dc958a",
"name": "如果提供图片",
"type": "n8n-nodes-base.if",
"position": [
1294,
2220
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "9a78220d-35f5-48b6-9ce3-faecaac24b74",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Get Data from Sheets').item.json.Image }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "30bf76c8-8420-4d77-bc2b-8a1c27fbf36a",
"name": "带图片发布",
"type": "n8n-nodes-base.linkedIn",
"position": [
1812,
2120
],
"parameters": {
"text": "={{ $('Data Formatting 1').item.json['Post Content'] }}",
"person": "pM247vR8Se",
"additionalFields": {},
"shareMediaCategory": "IMAGE"
},
"credentials": {
"linkedInOAuth2Api": {
"id": "Fg8i5E17dzZcPtMH",
"name": "LinkedIn account 2"
}
},
"typeVersion": 1
},
{
"id": "62bf9597-3e38-45ec-853c-aa2d77c40bc2",
"name": "无图片发布",
"type": "n8n-nodes-base.linkedIn",
"position": [
1812,
2320
],
"parameters": {
"text": "={{ $('Data Formatting 1').item.json['Post Content'] }}",
"person": "pM247vR8Se",
"additionalFields": {}
},
"credentials": {
"linkedInOAuth2Api": {
"id": "Fg8i5E17dzZcPtMH",
"name": "LinkedIn account 2"
}
},
"typeVersion": 1
},
{
"id": "0ddd307d-5e54-42cf-b65a-25f111fb4bea",
"name": "更新 Google 表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
2032,
2320
],
"parameters": {
"columns": {
"value": {
"Output": "={{ $json.urn }}",
"Status": "=Completed",
"Post Link": "={{ $json.urn }}",
"row_number": "={{ $('Get Data from Sheets').item.json.row_number }}"
},
"schema": [
{
"id": "Post Description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Post Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Instructions",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Instructions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Output",
"type": "string",
"display": true,
"required": false,
"displayName": "Output",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Post Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Post Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8/edit?usp=drivesdk",
"cachedResultName": "LinkedIn Post Automation"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Gs7mfT220sbLQ7PS",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "c4a55beb-8459-4faa-b072-51c500562ae3",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
2480
],
"parameters": {
"width": 420,
"height": 380,
"content": "## 1. 计划与表格数据获取"
},
"typeVersion": 1
},
{
"id": "09dade5b-e26a-4b97-9b8a-a5c807cff937",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-220,
3040
],
"parameters": {
"width": 420,
"height": 240,
"content": "## 2. AI驱动的帖子生成与格式化"
},
"typeVersion": 1
},
{
"id": "f373dfd9-f971-4925-8e74-15201c8a47c4",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
3040
],
"parameters": {
"width": 440,
"height": 240,
"content": "## 3. Gmail审批工作流"
},
"typeVersion": 1
},
{
"id": "66d51a35-262e-469b-bcd8-aca3cf60452c",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1120,
3040
],
"parameters": {
"width": 440,
"height": 240,
"content": "## 4. 审批处理与重新生成"
},
"typeVersion": 1
},
{
"id": "ad4023af-0e8b-4ec1-be1d-9313ec4f5ca7",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1800,
3040
],
"parameters": {
"width": 460,
"height": 320,
"content": "## 5. 图片检查、发布与表格更新"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "65685909-274a-4d41-8f8a-fbba9442597b",
"connections": {
"Get Image": {
"main": [
[
{
"node": "Post With Image",
"type": "main",
"index": 0
}
]
]
},
"Post With Image": {
"main": [
[
{
"node": "Update Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get Data from Sheets",
"type": "main",
"index": 0
}
]
]
},
"Data Formatting 1": {
"main": [
[
{
"node": "Send Content Confirmation",
"type": "main",
"index": 0
}
]
]
},
"If Image Provided": {
"main": [
[
{
"node": "Get Image",
"type": "main",
"index": 0
}
],
[
{
"node": "Post Without Image",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Generate Post Content",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Regenerate Post Content",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Post Without Image": {
"main": [
[
{
"node": "Update Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Get Data from Sheets": {
"main": [
[
{
"node": "Generate Post Content",
"type": "main",
"index": 0
}
]
]
},
"Generate Post Content": {
"main": [
[
{
"node": "Data Formatting 1",
"type": "main",
"index": 0
}
]
]
},
"Regenerate Post Content": {
"main": [
[
{
"node": "Data Formatting 1",
"type": "main",
"index": 0
}
]
]
},
"Send Content Confirmation": {
"main": [
[
{
"node": "Content Confirmation Logic",
"type": "main",
"index": 0
}
]
]
},
"Content Confirmation Logic": {
"main": [
[
{
"node": "If Image Provided",
"type": "main",
"index": 0
}
],
[
{
"node": "Regenerate Post Content",
"type": "main",
"index": 0
}
],
[
{
"node": "Update Google Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用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
设计
自动化新闻到简报AI代理v13
AI新闻研究团队：24/7简报自动化，含Perplexity引用
Set
Code
Gmail
+15
37 节点Derek Cheung
产品
使用AI、ElevenLabs、PIAPI Shotstack/Creatomate生成视频并发布到YouTube
使用AI、ElevenLabs、PIAPI Shotstack/Creatomate生成视频并发布到YouTube
If
Set
Code
+16
79 节点Immanuel
人工智能
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
使用 OpenAI、Google Sheets、Jina AI 和 Slack 的 AI 驱动信息监控
基于AI的信息监控，集成OpenAI、Google Sheets、Jina AI和Slack
If
Set
Code
+10
31 节点Dataki
销售
