社交预警流程
中级
这是一个Lead Generation领域的自动化工作流，包含 14 个节点。主要使用 If, Set, Slack, Webhook, GoogleSheets 等节点。 使用Trigify、Google Sheets和Slack从社交互动中发现和生成潜在客户
前置要求
- •Slack Bot Token 或 Webhook URL
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google Sheets API 凭证
使用的节点 (14)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "2mnztdp4yL2YfnUZ",
"meta": {
"instanceId": "46c4cce2e89603002c0d6107a8d4394ab0a48e7435c7b6ec71803a5658ecd21f",
"templateCredsSetupCompleted": true
},
"name": "社交预警流程",
"tags": [
{
"id": "VG35LXv8rfSoEd8Z",
"name": "social listening",
"createdAt": "2025-03-28T17:04:59.782Z",
"updatedAt": "2025-03-28T17:04:59.782Z"
}
],
"nodes": [
{
"id": "5df779cd-4b8f-48f1-99eb-7f35857733ff",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-500,
-160
],
"webhookId": "f3245b39-6f22-4a0e-a198-2488da8aa01e",
"parameters": {
"path": "f3245b39-6f22-4a0e-a198-2488da8aa01e",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "18783096-48f5-4997-8a20-de41da5a10c5",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
-280,
-380
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "8d9f73f9-68ac-4a1c-8427-c09ddb10eb95",
"name": "body.linkedin_engagement[0].linkedin_post.post_url",
"type": "string",
"value": "={{ $json.body.linkedin_engagement[0].linkedin_post.post_url }}"
},
{
"id": "eced7491-4821-45d6-a7a8-065656eec0c7",
"name": "body.linkedin_engagement[0].linkedin_post.posted_date",
"type": "string",
"value": "={{ $json.body.linkedin_engagement[0].linkedin_post.posted_date }}"
},
{
"id": "25ec3fb4-4562-49ff-8f53-d3bcfde8cd58",
"name": "body.linkedin_engagement[0].linkedin_post.text",
"type": "string",
"value": "={{ $json.body.linkedin_engagement[0].linkedin_post.text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e8e4aaa0-7749-400a-a7fb-85f3cff44d11",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
-300,
80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "db52c858-cbf0-4755-a376-3d2ab14a0e53",
"name": "body.prospect.first_name",
"type": "string",
"value": "={{ $json.body.prospect.first_name }}"
},
{
"id": "0fcaf40a-3854-42bf-bd7a-741aa9903cf7",
"name": "body.prospect.last_name",
"type": "string",
"value": "={{ $json.body.prospect.last_name }}"
},
{
"id": "1ac42218-3393-4de0-b6f0-484b867573c2",
"name": "body.prospect.job_title",
"type": "string",
"value": "={{ $json.body.prospect.job_title }}"
},
{
"id": "114098e3-374a-4083-80af-a7198fea3039",
"name": "body.prospect.linkedin_url",
"type": "string",
"value": "={{ $json.body.prospect.linkedin_url }}"
},
{
"id": "eca9901b-bffe-4542-ad4e-5b75391a4ef9",
"name": "body.prospect.location_name",
"type": "string",
"value": "={{ $json.body.prospect.location_name }}"
},
{
"id": "ecfc204b-531c-409b-96e0-8b059744553a",
"name": "body.company.name",
"type": "string",
"value": "={{ $json.body.company.name }}"
},
{
"id": "557953fb-ba8e-4499-9caf-190aa3db7601",
"name": "body.company.size",
"type": "string",
"value": "={{ $json.body.company.size }}"
},
{
"id": "f9fd0689-22b3-404e-8dc1-69a8834869af",
"name": "body.company.industry",
"type": "string",
"value": "={{ $json.body.company.industry }}"
},
{
"id": "d5b83eaa-deb6-4aa1-b2f9-b25661c43173",
"name": "body.company.linkedin_url",
"type": "string",
"value": "={{ $json.body.company.linkedin_url }}"
},
{
"id": "ae780ddb-b2b1-45ed-ab13-cef3c2f5c4d4",
"name": "body.company.domain",
"type": "string",
"value": "={{ $json.body.company.domain }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9680c2f0-fcda-4206-8828-1cddf3979ca2",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
400,
-380
],
"parameters": {
"columns": {
"value": {
"Post URL": "={{ $('Edit Fields').item.json.body.linkedin_engagement[0].linkedin_post.post_url }}",
"Post Text": "={{ $('Edit Fields').item.json.body.linkedin_engagement[0].linkedin_post.text }}",
"Posted Date": "={{ $('Edit Fields').item.json.body.linkedin_engagement[0].linkedin_post.posted_date }}"
},
"schema": [
{
"id": "Post URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Post URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Post Text",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Post Text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Posted Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Posted Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Author",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Author",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Post URL"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o/edit?usp=drivesdk",
"cachedResultName": "Social Warming"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "apzBdBEHIORJaEuO",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "554cf89f-d46d-40d0-a9ad-e1d0fad699f2",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-60,
-380
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.body.linkedin_engagement[0].linkedin_post.post_url }}",
"lookupColumn": "Post URL"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o/edit?usp=drivesdk",
"cachedResultName": "Social Warming"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "apzBdBEHIORJaEuO",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "bdcdabb3-3d4d-4570-b9aa-133e9c824aa0",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
160,
-380
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b5ebe86c-282e-4042-816d-28b6ad72b5f2",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json[\"Post URL\"] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "21907ad2-aae0-4d47-8044-525b27500fb1",
"name": "Slack",
"type": "n8n-nodes-base.slack",
"position": [
620,
-380
],
"webhookId": "2bf60991-bae2-4e3e-86c2-02bcdd8a3dc6",
"parameters": {
"text": "Thought Leader Post",
"select": "channel",
"blocksUi": "={\n\t\"blocks\": [\n\t\t{\n\t\t\t\"type\": \"section\",\n\t\t\t\"text\": {\n\t\t\t\t\"type\": \"mrkdwn\",\n\t\t\t\t\"text\": \"🚨 *Thought Leader Alert*\\n\\nOne of your tracked thought leaders just posted new content!\\n\\n*Stay ahead of the conversation*\"\n\t\t\t}\n\t\t},\n\t\t{\n\t\t\t\"type\": \"divider\"\n\t\t},\n\t\t{\n\t\t\t\"type\": \"section\",\n\t\t\t\"text\": {\n\t\t\t\t\"type\": \"mrkdwn\",\n\t\t\t\t\"text\": \"*New LinkedIn Post*\\n:link: <{{ $json['Post URL'] }}|View Original Post>\\n:calendar: Posted: {{ $json['Posted Date'] }}\"\n\t\t\t}\n\t\t},\n\t\t{\n\t\t\t\"type\": \"section\",\n\t\t\t\"text\": {\n\t\t\t\t\"type\": \"mrkdwn\",\n\t\t\t\t\"text\": \"*Post Content:*\\n{{ $json['Post Text'] }}\"\n\t\t\t}\n\t\t},\n\t\t{\n\t\t\t\"type\": \"divider\"\n\t\t},\n\t\t{\n\t\t\t\"type\": \"actions\",\n\t\t\t\"elements\": [\n\t\t\t\t{\n\t\t\t\t\t\"type\": \"button\",\n\t\t\t\t\t\"text\": {\n\t\t\t\t\t\t\"type\": \"plain_text\",\n\t\t\t\t\t\t\"text\": \"View Post\",\n\t\t\t\t\t\t\"emoji\": true\n\t\t\t\t\t},\n\t\t\t\t\t\"value\": \"view_post\",\n\t\t\t\t\t\"url\": \"{{ $json['Post URL'] }}\"\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"type\": \"button\",\n\t\t\t\t\t\"text\": {\n\t\t\t\t\t\t\"type\": \"plain_text\",\n\t\t\t\t\t\t\"text\": \"Engage Now\",\n\t\t\t\t\t\t\"emoji\": true\n\t\t\t\t\t},\n\t\t\t\t\t\"value\": \"engage_now\"\n\t\t\t\t},\n\t\t\t\t{\n\t\t\t\t\t\"type\": \"button\",\n\t\t\t\t\t\"text\": {\n\t\t\t\t\t\t\"type\": \"plain_text\",\n\t\t\t\t\t\t\"text\": \"Save for Later\",\n\t\t\t\t\t\t\"emoji\": true\n\t\t\t\t\t},\n\t\t\t\t\t\"value\": \"save_later\"\n\t\t\t\t}\n\t\t\t]\n\t\t}\n\t]\n}",
"channelId": {
"__rl": true,
"mode": "list",
"value": "C097896SD3P",
"cachedResultName": "comment-strategy"
},
"messageType": "block",
"otherOptions": {
"includeLinkToWorkflow": false
}
},
"credentials": {
"slackApi": {
"id": "EifxhpAZD2NwzdmN",
"name": "Slack account 8"
}
},
"typeVersion": 2.3
},
{
"id": "704638cf-b139-4e54-8e48-898f0ef3cc8c",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
100
],
"parameters": {
"columns": {
"value": {
"Size": "={{ $json.body.company.size }}",
"Domain": "={{ $json.body.company.domain }}",
"Industry": "={{ $json.body.company.industry }}",
"Location": "={{ $json.body.prospect.location_name }}",
"Job Title": "={{ $json.body.prospect.job_title }}",
"Last Name": "={{ $json.body.prospect.last_name }}",
"First Name": "={{ $json.body.prospect.first_name }}",
"Company Name": "={{ $json.body.company.name }}",
"LinkedIn URL": "={{ $json.body.prospect.linkedin_url }}",
"Company LinkedIn URL": "={{ $json.body.company.linkedin_url }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Job Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn URL",
"type": "string",
"display": true,
"required": false,
"displayName": "LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Company Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company LinkedIn URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company LinkedIn URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Size",
"type": "string",
"display": true,
"required": false,
"displayName": "Size",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 671966577,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o/edit#gid=671966577",
"cachedResultName": "Engagers"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1U73FHlwrhp64-ZdPGMRIpUnQe3hbDE7UOBvL0z25G7o/edit?usp=drivesdk",
"cachedResultName": "Social Warming"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "apzBdBEHIORJaEuO",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9b084b47-1783-4b5a-8752-8b137eb4713b",
"name": "条件判断1",
"type": "n8n-nodes-base.if",
"position": [
-80,
80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8e53e613-e5b3-4f7d-a824-ddf3a26ac7ab",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.body.prospect.job_title }}",
"rightValue": "marketing"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a2de7f1e-dff7-4f8b-8e7b-cf88403b9644",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-420
],
"parameters": {
"content": "## 接收来自Trigify.io的新意见领袖帖子提醒"
},
"typeVersion": 1
},
{
"id": "a7f81174-864d-4cbf-bf9e-a232230ffce1",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
20
],
"parameters": {
"width": 260,
"height": 200,
"content": "## 接收来自Trigify.io的意见领袖帖子新互动者提醒"
},
"typeVersion": 1
},
{
"id": "d9780777-69c1-48b6-88ae-0ca1d6a8a3a1",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-140,
20
],
"parameters": {
"color": 5,
"width": 260,
"height": 200,
"content": "根据您的理想客户画像编辑此IF条件"
},
"typeVersion": 1
},
{
"id": "09072558-0f1e-4ab8-8c3b-d873a445a9cb",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-140,
-480
],
"parameters": {
"color": 6,
"width": 700,
"height": 300,
"content": "此操作用于阻止重复帖子被添加到这里"
},
"typeVersion": 1
},
{
"id": "9f198075-800c-4043-a836-dc55a9d7dd9d",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
0
],
"parameters": {
"color": 2,
"width": 320,
"height": 260,
"content": "您可以在此处使用CRM或将此数据发送到外联工具"
},
"typeVersion": 1
}
],
"active": true,
"pinData": {
"Webhook": [
{
"json": {
"body": {
"company": {
"logo": "https://example.com/logo.png",
"name": "Example Company",
"size": "100-500",
"domain": "example.com",
"industry": "Software",
"location": "San Francisco, CA",
"linkedin_url": "https://linkedin.com/company/example-company"
},
"prospect": {
"job_title": "Software Engineer",
"last_name": "Doe",
"first_name": "John",
"linkedin_url": "https://linkedin.com/in/john-doe",
"location_name": "San Francisco, CA",
"enriched_email": [
"example@example.com"
],
"enriched_phone": [
"+1234567890"
]
},
"linkedinUsername": "example",
"linkedin_engagement": [
{
"text": "Great post!",
"type": "comment",
"linkedin_post": {
"text": "Original post content",
"post_url": "https://linkedin.com/post/123",
"posted_date": "2023-01-01"
}
}
]
},
"query": {},
"params": {},
"headers": {
"host": "primary-dev-de79.up.railway.app",
"accept": "*/*",
"svix-id": "msg_30JlxleMV7n6AeKpcgcO3IKQC3b",
"x-real-ip": "54.216.8.72",
"user-agent": "Svix-Webhooks/1.68.0 (sender-9YMgn; +https://www.svix.com/http-sender/)",
"content-type": "application/json",
"content-length": "686",
"svix-signature": "v1,0jF4QiDzBypC/K9GhZuULvyBcjGLlgSkGYFI7lzJqbU=",
"svix-timestamp": "1753353804",
"x-railway-edge": "railway/europe-west4",
"accept-encoding": "gzip",
"x-forwarded-for": "54.216.8.72",
"x-request-start": "1753353805080",
"x-forwarded-host": "primary-dev-de79.up.railway.app",
"x-forwarded-proto": "https",
"x-railway-request-id": "uGVWnFLyTMqXJm8iEFczVw"
},
"webhookUrl": "https://primary-dev-de79.up.railway.app/webhook/f3245b39-6f22-4a0e-a198-2488da8aa01e",
"executionMode": "production"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "21da05e6-74c9-4d28-a77c-ab60264ad9c3",
"connections": {
"If": {
"main": [
[],
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
},
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Slack",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
社交评论代理
基于 Claude Sonnet 和 Trigify 的 AI 社交媒体思想领导力系统
If
Set
Slack
+6
14 节点Max Mitcham
社交媒体
入站网站演示流程
使用 Claude AI、Cal.com 和 Instantly.ai 筛选和培育网站演示请求
If
Set
Wait
+7
21 节点Max Mitcham
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
Fluentform导出
从 Fluentform 自动导出潜在客户到 Google 表格，支持表单分类
If
Set
Webhook
+3
9 节点Khairul Muhtadin
潜在客户开发
基于公司ID的Apollo数据丰富
使用Apollo、Google Sheets和Telegram基于公司ID丰富采购联系人
If
Set
Code
+9
27 节点Khaisa Studio
潜在客户开发
LinkedIn潜在客户生成与CRM自动化套件
使用Apify提取LinkedIn个人资料并为Google Sheets CRM自动生成潜在客户数据
If
Set
Code
+7
18 节点David Olusola
潜在客户开发
工作流信息
难度等级
中级
节点数量14
分类1
节点类型6
作者
Max Mitcham
@maxmitchamBuilding Trigify.io an AI Social Listening platform -> Follow my journey here: LinkedIn - https://www.linkedin.com/in/max-mitcham/ YouTube - https://www.youtube.com/@MaxMitchamAgents
外部链接
在 n8n.io 查看 →
分享此工作流