使用 AI 创建 LinkedIn 贡献并在 Slack 上通知用户
高级
这是一个AI, Marketing领域的自动化工作流，包含 33 个节点。主要使用 Set, Code, Html, Merge, Slack 等节点，结合人工智能技术实现智能自动化。 使用 AI 创建 LinkedIn 贡献并在 Slack 上通知用户
前置要求
- •Slack Bot Token 或 Webhook URL
- •Airtable API Key
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (33)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "38d37c49298b42c645e6a7693766d7c3522b24e54454034f955422b5d7af611c"
},
"nodes": [
{
"id": "dd9e2f9c-225a-4b6b-9904-293206a477e4",
"name": "从 Google 搜索获取建议文章",
"type": "n8n-nodes-base.httpRequest",
"position": [
1040,
360
],
"parameters": {
"url": "=https://www.google.com/search?q=site%3Alinkedin.com%2Fadvice+{{ $json.Topic }}",
"options": {
"batching": {
"batch": {
"batchSize": 25
}
}
}
},
"typeVersion": 4.2
},
{
"id": "0e2bcaeb-65a0-400a-a15e-0840723d8144",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
320
],
"parameters": {
"color": 2,
"width": 621.7044818991839,
"height": 566.8592254014303,
"content": ""
},
"typeVersion": 1
},
{
"id": "68eefc93-6c82-4687-bb4d-52345e5a5094",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
520,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "af3fdd03-d28a-4f49-b213-8202b1d154df",
"name": "合并数据并保留唯一的 Google 搜索结果",
"type": "n8n-nodes-base.merge",
"position": [
1700,
200
],
"parameters": {
"mode": "combine",
"options": {},
"joinMode": "keepNonMatches",
"mergeByFields": {
"values": [
{
"field1": "URL",
"field2": "matches"
}
]
},
"outputDataFrom": "input2"
},
"typeVersion": 2.1
},
{
"id": "632c54cc-b1d7-4034-93bf-82dd206761f0",
"name": "提取 LinkedIn 建议文章的链接",
"type": "n8n-nodes-base.code",
"position": [
1240,
360
],
"parameters": {
"jsCode": "// n8n Code node script\nconst text = $json.data;\n\n// Define the regex pattern\nconst regexPattern = /https:\\/\\/www\\.linkedin\\.com\\/advice\\/[^%&\\s\"']+/g;\n\n// Execute the regex pattern on the text\nconst matches = text.match(regexPattern);\n\n// Output the matches\nreturn {\n matches: matches || []\n};\n\n\n"
},
"typeVersion": 2
},
{
"id": "81f0a962-fef8-4a46-a709-21cc2db02e55",
"name": "拆分所有 LinkedIn 建议文章的链接",
"type": "n8n-nodes-base.splitOut",
"position": [
1440,
360
],
"parameters": {
"options": {},
"fieldToSplitOut": "matches"
},
"typeVersion": 1
},
{
"id": "65e4efa0-c746-4e77-9ccb-01c8afc5860c",
"name": "每周一上午 08:00 触发计划",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
520,
280
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
1
],
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1.2
},
{
"id": "86fe3695-c1fd-4154-b1ba-f0737406da4a",
"name": "LinkedIn 贡献撰写器",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
2360,
200
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "GPT-4O-MINI"
},
"options": {
"temperature": 0.7
},
"messages": {
"values": [
{
"content": "=Read the following collaborative article and provide your own helpful collaboration. The article has various topics that each need to be answered. Write me a paragraph of helpful advice for each topic and format your response as outlined in the template below.\n\n-------------\nARTICLE TITLE\n{{ $json.ArticleTitle }}\n\nTOPICS WITHIN THE LINKEDIN ARTICLE:\n{{ $json.ArticleTopics }}\n\nOTHER CONTRIBUTIONS TO THE LINKEDIN ARTICLE:\n{{ $json.ArticleContributions }}\n-------------\n\nYour advice must be unique and something that no one else has recommended before on the article, or in any of the topics. The response needs to be raw and genuine to elicit conversation and engagement.\n\nFormat your output in text and follow the template below. Only populate the template with as many topics as were provided in the original request \n\ni.e: if there were only 4 topics in the original request then only provide 4 pieces of advice:\n\nOUTPUT TEMPLATE\n\n1. [Topic #1 from Article]\n[Advice for Topic]\n\n2. [Topic #2 from Article]\n[Advice for Topic]\n\n3. [Topic #3 from Article]\n[Advice for Topic]\n\n4. [Topic #4 from Article]\n[Advice for Topic]\n\n5. [Topic #5 from Article]\n[Advice for Topic]\n\n6. [Topic #6 from Article]\n[Advice for Topic]"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "t5MoHQt5nn0nWWnw",
"name": "OpenAi Account (darryn@optimus01.co.za)"
}
},
"typeVersion": 1.4
},
{
"id": "aaeba3e6-2d74-463a-8ba7-9f84826fee1b",
"name": "将新的 LinkedIn 贡献发布到 NocoDB（创建行）",
"type": "n8n-nodes-base.nocoDb",
"position": [
3020,
200
],
"parameters": {
"table": "mpagw9n92ran52o",
"fieldsUi": {
"fieldValues": [
{
"fieldName": "Post Title",
"fieldValue": "={{ $('HTML extract LinkedIn article & other users contributions').item.json.ArticleTitle }}"
},
{
"fieldName": "URL",
"fieldValue": "={{ $('Merge data and keep unique google search results').item.json.matches }}"
},
{
"fieldName": "Contribution",
"fieldValue": "={{ $('LinkedIn Contribution Writer').item.json.message.content }}"
},
{
"fieldName": "Topic",
"fieldValue": "Lead Generation"
},
{
"fieldName": "Person",
"fieldValue": "Cassie"
}
]
},
"operation": "create",
"projectId": "psdqqm1bzphkodc",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "5PYJKB4ihzHtKLqx",
"name": "NocoDB Account (darryn@optimus01.co.za)"
}
},
"typeVersion": 3
},
{
"id": "4d6bca6e-2392-48c1-906f-ff5f439f4897",
"name": "将新的 LinkedIn 贡献发布到 Slack 频道",
"type": "n8n-nodes-base.slack",
"position": [
2740,
200
],
"parameters": {
"text": "=↓ 📝 ARTICLE:\n{{ $('HTML extract LinkedIn article & other users contributions').item.json.ArticleTitle }}\n{{ $('Merge data and keep unique google search results').item.json.matches }}\n\n↓ 💡 ADVICE:\n{{ $json.message.content }}\n------------------------------------------------------",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "C07CFN279HT",
"cachedResultName": "cass-linkedin-advice"
},
"otherOptions": {
"mrkdwn": true,
"unfurl_links": true,
"includeLinkToWorkflow": false
},
"authentication": "oAuth2"
},
"credentials": {
"slackOAuth2Api": {
"id": "xkCA23zAF89RcovP",
"name": "Slack Account (OAuth) (darryn@optimus01.co.za)"
}
},
"typeVersion": 2.2
},
{
"id": "ffc7984b-7199-421a-9fe1-8ffe2aa8e7b3",
"name": "从数据库 NocoDB 获取所有 LinkedIn 贡献（获取行）",
"type": "n8n-nodes-base.nocoDb",
"position": [
1240,
80
],
"parameters": {
"table": "mpagw9n92ran52o",
"options": {},
"operation": "getAll",
"projectId": "psdqqm1bzphkodc",
"returnAll": true,
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "5PYJKB4ihzHtKLqx",
"name": "NocoDB Account (darryn@optimus01.co.za)"
}
},
"typeVersion": 3
},
{
"id": "a9cd9135-e6d8-4350-861d-87af50413297",
"name": "HTML 提取 LinkedIn 文章和其他用户的贡献",
"type": "n8n-nodes-base.html",
"position": [
2160,
200
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "ArticleTitle",
"cssSelector": ".pulse-title"
},
{
"key": "ArticleTopics",
"cssSelector": ".article-main__content"
},
{
"key": "ArticleContributions",
"cssSelector": ".contribution__text"
}
]
}
},
"typeVersion": 1
},
{
"id": "5496fe68-6c77-4520-9479-141a4a20643f",
"name": "HTTP 请求获取 LinkedIn 建议文章",
"type": "n8n-nodes-base.httpRequest",
"position": [
1960,
200
],
"parameters": {
"url": "={{ $json.matches }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "b7235009-6bbb-4701-aeb4-c287b2782a88",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-365,
-33
],
"parameters": {
"color": 7,
"width": 366.75796434038665,
"height": 473.77664315100793,
"content": "## 此工作流的功能"
},
"typeVersion": 1
},
{
"id": "6aff94a1-1a65-4d24-ab87-b8ff72ea33b5",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-33
],
"parameters": {
"color": 6,
"width": 396.6384066163515,
"height": 282.5799404564392,
"content": "### 获取更多类似模板 👇"
},
"typeVersion": 1
},
{
"id": "89d13f57-4a7d-4071-8089-c28b5708c122",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-364,
460
],
"parameters": {
"width": 366.36771813959956,
"height": 329.9474713935157,
"content": "## 设置"
},
"typeVersion": 1
},
{
"id": "11ca526c-2512-4c66-8dbf-0f9cdec13d9f",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
-200
],
"parameters": {
"color": 7,
"width": 812.3060553462686,
"height": 1198.0013690558965,
"content": "## 使用 AI 成为 LinkedIn 顶级声音"
},
"typeVersion": 1
},
{
"id": "9536318f-46a5-4ef4-bffc-395d3d2d1af8",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
-364,
810
],
"parameters": {
"color": 7,
"width": 781.0904623817446,
"height": 169.84805961144036,
"content": "## 如何自定义此工作流"
},
"typeVersion": 1
},
{
"id": "5fab6cb9-5191-46a1-81ef-10b330f11b8b",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
1086,
-200
],
"parameters": {
"color": 6,
"width": 419.095339329518,
"height": 463.432215862633,
"content": "## 从数据库 NocoDB 获取所有 LinkedIn 贡献（获取行）"
},
"typeVersion": 1
},
{
"id": "0c2e26c9-be23-4755-81db-dd5167b84f52",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1620,
-60
],
"parameters": {
"color": 7,
"width": 253.48029435813578,
"height": 446.9376941946034,
"content": "## 合并数据并保留唯一的 Google 搜索结果"
},
"typeVersion": 1
},
{
"id": "f086bb56-9cff-4dc0-a345-868eca20b12c",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1895.9759156157297,
160
],
"parameters": {
"color": 5,
"width": 426.673961735047,
"height": 550.9285363859362,
"content": ""
},
"typeVersion": 1
},
{
"id": "3d44a074-55a5-4eb3-b18a-40564f452646",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2674,
-56
],
"parameters": {
"color": 3,
"width": 242.07228127555214,
"height": 451.5087489779234,
"content": "## 将新的 LinkedIn 贡献发布到 Slack 频道"
},
"typeVersion": 1
},
{
"id": "cb052b4e-51a8-45be-8684-bd46f48b8017",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2940,
-55
],
"parameters": {
"color": 6,
"width": 280.61885357253936,
"height": 570.1315791275019,
"content": "## 将新的 LinkedIn 贡献发布到 NocoDB（创建行）"
},
"typeVersion": 1
},
{
"id": "d1bbbc22-4913-4558-8bea-faa437c27e0b",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
2951,
399
],
"parameters": {
"color": 7,
"width": 259.5924775143092,
"height": 104.96722916838547,
"content": "### `NocoDB` 可以替换为其他服务，如 `Airtable` 或 `Google Sheets`"
},
"typeVersion": 1
},
{
"id": "343da68f-09a7-4602-91e9-3ee47e23a936",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1100,
-40
],
"parameters": {
"color": 7,
"width": 392.21847914963246,
"height": 80,
"content": "### `NocoDB` 可以替换为其他服务，如 `Airtable` 或 `Google Sheets`"
},
"typeVersion": 1
},
{
"id": "ed17e693-da43-49b9-bc4b-cae8a8503ee8",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
2344,
-56
],
"parameters": {
"width": 309.45427591228105,
"height": 447.75689268844843,
"content": "## LinkedIn 贡献撰写器"
},
"typeVersion": 1
},
{
"id": "653d839f-ea48-4e3c-a4a8-09dbeea59ed6",
"name": "Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
80,
627
],
"parameters": {
"options": {},
"resource": "base",
"authentication": "airtableOAuth2Api"
},
"credentials": {
"airtableOAuth2Api": {
"id": "goKNRHmMmQG5kexN",
"name": "Airtable Account (darryn@optimus01.co.za)"
}
},
"typeVersion": 2.1
},
{
"id": "4b4ba215-5a51-45dc-81ba-80b789ffe269",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
260,
627
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 966510578,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1C7R_Xb5pfWlctEtgpOrXTz2O1I59VOBNIQJb2mWDWiI/edit#gid=966510578",
"cachedResultName": "Appointments (Smile)"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1C7R_Xb5pfWlctEtgpOrXTz2O1I59VOBNIQJb2mWDWiI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1C7R_Xb5pfWlctEtgpOrXTz2O1I59VOBNIQJb2mWDWiI/edit?usp=drivesdk",
"cachedResultName": "Orthodontist - Dr. Choma"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "G62pZQANOhZoAYVs",
"name": "Google Sheets Account (darryn@optimus01.co.za)"
}
},
"typeVersion": 4.5
},
{
"id": "b98516e8-897f-4bf1-aa1a-1783f6b2d957",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
21,
270
],
"parameters": {
"color": 7,
"width": 394.73627201205596,
"height": 521.5579232475401,
"content": "## 可互换的工具"
},
"typeVersion": 1
},
{
"id": "22849372-db4d-44ab-aea2-224d4c6bfd77",
"name": "从数据库 NocoDB 获取所有 LinkedIn 贡献（获取行）1",
"type": "n8n-nodes-base.nocoDb",
"position": [
160,
347
],
"parameters": {
"table": "mpagw9n92ran52o",
"options": {},
"operation": "getAll",
"projectId": "psdqqm1bzphkodc",
"returnAll": true,
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "5PYJKB4ihzHtKLqx",
"name": "NocoDB Account (darryn@optimus01.co.za)"
}
},
"typeVersion": 3
},
{
"id": "0af1eb81-9592-4d5d-a628-18f7895e5401",
"name": "设置 Google 搜索主题",
"type": "n8n-nodes-base.set",
"position": [
800,
360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "cf3ef4d0-2688-4fe1-9801-a8519bd293f7",
"name": "Topic",
"type": "string",
"value": "Paid Advertising"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "493d93d3-d426-4d8d-9b18-ec5855ee891a",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
740,
320
],
"parameters": {
"color": 7,
"width": 221.13234187060237,
"height": 399.35935838473415,
"content": ""
},
"typeVersion": 1
},
{
"id": "e8b12df1-32b5-4f8f-b3d0-9fc68366f9a8",
"name": "便签 16",
"type": "n8n-nodes-base.stickyNote",
"position": [
738.8518697906181,
732.2671893604936
],
"parameters": {
"color": 4,
"width": 223.88348808302658,
"height": 80,
"content": "## 👆 在此编辑字段"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Set Topic for Google search": {
"main": [
[
{
"node": "Get advice articles from a Google search",
"type": "main",
"index": 0
}
]
]
},
"LinkedIn Contribution Writer": {
"main": [
[
{
"node": "Post new LinkedIn contributions to Slack channel",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Get all LinkedIn contributions from database NocoDB (GetRows)",
"type": "main",
"index": 0
},
{
"node": "Set Topic for Google search",
"type": "main",
"index": 0
}
]
]
},
"Get advice articles from a Google search": {
"main": [
[
{
"node": "Extract Article links for LinkedIn advice articles",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger Every Monday, @ 08:00am": {
"main": [
[
{
"node": "Get all LinkedIn contributions from database NocoDB (GetRows)",
"type": "main",
"index": 0
},
{
"node": "Set Topic for Google search",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request to get LinkedIn advice articles": {
"main": [
[
{
"node": "HTML extract LinkedIn article & other users contributions",
"type": "main",
"index": 0
}
]
]
},
"Merge data and keep unique google search results": {
"main": [
[
{
"node": "HTTP Request to get LinkedIn advice articles",
"type": "main",
"index": 0
}
]
]
},
"Post new LinkedIn contributions to Slack channel": {
"main": [
[
{
"node": "Post new LinkedIn contributions to NocoDB (CreateRows)",
"type": "main",
"index": 0
}
]
]
},
"Split Out all links for LinkedIn advice articles": {
"main": [
[
{
"node": "Merge data and keep unique google search results",
"type": "main",
"index": 1
}
]
]
},
"Extract Article links for LinkedIn advice articles": {
"main": [
[
{
"node": "Split Out all links for LinkedIn advice articles",
"type": "main",
"index": 0
}
]
]
},
"HTML extract LinkedIn article & other users contributions": {
"main": [
[
{
"node": "LinkedIn Contribution Writer",
"type": "main",
"index": 0
}
]
]
},
"Get all LinkedIn contributions from database NocoDB (GetRows)": {
"main": [
[
{
"node": "Merge data and keep unique google search results",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
WordPress 内容生成器 v3
WordPress 内容生成器 v3
If
Set
Code
+21
102 节点Alex Kim
人工智能
WordPress终极内容生成器 v2 - AlexK1919
WordPress终极内容生成器
If
Set
Code
+17
61 节点Alex Kim
人工智能
自动化博客撰写与社交媒体推广代理
使用GPT-4、Perplexity和WordPress自动化SEO博客创建+社交媒体
Set
Code
Gmail
+21
79 节点LukaszB
设计
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
使用GPT-4o AI分析和多格式报告运行完整技术SEO审计
使用GPT-4o AI分析和多格式报告运行完整技术SEO审计
Set
Xml
Code
+14
45 节点Oriol Seguí Rotllant
人工智能
WordPress博客自动化专业版（SEO主题）v2
WordPress自动博客专业版 - SEO主题内容自动化机器
If
Set
Xml
+21
63 节点Daniel Ng
人工智能
