智能活动跟进与社交助手
这是一个Lead Nurturing, Multimodal AI领域的自动化工作流,包含 25 个节点。主要使用 Code, Filter, Hubspot, Webhook, Postgres 等节点。 使用 GPT-4、LinkedIn 和 HubSpot 多渠道触达实现活动跟进自动化
- •HubSpot API Key
- •HTTP Webhook 端点(n8n 会自动生成)
- •PostgreSQL 数据库连接信息
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
使用的节点 (25)
{
"id": "EdsA8tMTiX0U8OGD",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "智能活动跟进与社交助手",
"tags": [],
"nodes": [
{
"id": "77382348-01bf-4d73-806c-67af02c67114",
"name": "Webhook 触发器",
"type": "n8n-nodes-base.webhook",
"position": [
-272,
432
],
"webhookId": "a962b8dd-4b73-48b3-bb5f-fb7968adca40",
"parameters": {
"path": "networking-assistant",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 1
},
{
"id": "e935b3a3-a41e-45c5-b830-c45476ea5f09",
"name": "获取参会者",
"type": "n8n-nodes-base.httpRequest",
"position": [
-48,
240
],
"parameters": {
"url": "=https://api.eventplatform.com/events/{{ $json.body.eventId }}/attendees",
"options": {},
"authentication": "genericCredentialType"
},
"typeVersion": 4.1
},
{
"id": "e089c5fe-2a41-4b9a-bc76-0318bab22bc6",
"name": "获取互动记录",
"type": "n8n-nodes-base.httpRequest",
"position": [
-48,
432
],
"parameters": {
"url": "=https://api.eventplatform.com/events/{{ $json.body.eventId }}/interactions",
"options": {},
"authentication": "genericCredentialType"
},
"typeVersion": 4.1
},
{
"id": "5f7f56f1-b1d1-4fa9-9e87-982128a37b5d",
"name": "丰富 LinkedIn 数据",
"type": "n8n-nodes-base.httpRequest",
"position": [
-48,
624
],
"parameters": {
"url": "=https://api.linkedin.com/v2/people/{{ $json.linkedinId }}",
"options": {},
"authentication": "genericCredentialType"
},
"typeVersion": 4.1
},
{
"id": "06001185-5d97-4290-9832-3dc0c806f3bc",
"name": "合并与丰富数据",
"type": "n8n-nodes-base.code",
"position": [
176,
432
],
"parameters": {},
"typeVersion": 2
},
{
"id": "2c79001e-7667-4fac-a26b-ab64c001ca94",
"name": "AI 分析个人资料",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
480,
656
],
"parameters": {
"model": "=gpt-4o",
"options": {
"temperature": 0.8
}
},
"credentials": {
"openAiApi": {
"id": "CDQ16eImh6D4tY15",
"name": "OpenAi account 2 - test"
}
},
"typeVersion": 1
},
{
"id": "345b815d-2f48-438c-8a4d-8cf50db45492",
"name": "筛选高优先级",
"type": "n8n-nodes-base.filter",
"position": [
752,
240
],
"parameters": {
"options": {},
"conditions": {
"options": {
"caseSensitive": false
},
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.followUpPriority }}",
"rightValue": "high"
}
]
}
},
"typeVersion": 2
},
{
"id": "3893012b-cbc5-44a9-b345-c288cf759562",
"name": "筛选中优先级",
"type": "n8n-nodes-base.filter",
"position": [
752,
640
],
"parameters": {
"options": {},
"conditions": {
"options": {
"caseSensitive": false
},
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.followUpPriority }}",
"rightValue": "medium"
}
]
}
},
"typeVersion": 2
},
{
"id": "ca7083ce-c154-40d1-aee0-a792efdb1539",
"name": "生成邮件",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1056,
352
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "CDQ16eImh6D4tY15",
"name": "OpenAi account 2 - test"
}
},
"typeVersion": 1
},
{
"id": "702d8331-1bbf-4a34-afac-4977fcd40098",
"name": "生成 LinkedIn 消息",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1056,
864
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "CDQ16eImh6D4tY15",
"name": "OpenAi account 2 - test"
}
},
"typeVersion": 1
},
{
"id": "bd5c3beb-0e48-45a1-b88d-1657e87a1664",
"name": "发送 LinkedIn",
"type": "n8n-nodes-base.httpRequest",
"position": [
1328,
528
],
"parameters": {
"url": "=https://api.linkedin.com/v2/messages",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "recipient",
"value": "={{ $json.linkedinId }}"
},
{
"name": "message",
"value": "={{ $json.generatedLinkedInMsg }}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "f8b77773-301d-4846-b205-462123837c66",
"name": "Slack 通知",
"type": "n8n-nodes-base.httpRequest",
"position": [
1328,
784
],
"parameters": {
"url": "=https://slack.com/api/chat.postMessage",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "channel",
"value": "={{ $json.slackUserId }}"
},
{
"name": "text",
"value": "=Follow up with {{ $json.name }} from event!"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "12fa20d1-4bb6-4f08-8422-73b32e68cc12",
"name": "更新 CRM",
"type": "n8n-nodes-base.hubspot",
"position": [
1552,
336
],
"parameters": {
"email": "={{ $json.email }}",
"options": {},
"additionalFields": {}
},
"credentials": {
"hubspotApi": {
"id": "W7t1pOQwFXrMGtqj",
"name": "HubSpot account -test"
}
},
"typeVersion": 2
},
{
"id": "25976c83-8a67-41bc-9fbf-57bb9c662c20",
"name": "保存到数据库",
"type": "n8n-nodes-base.postgres",
"position": [
1776,
432
],
"parameters": {
"table": "networking_followups",
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"columns": {
"value": {},
"schema": [],
"mappings": [
{
"value": "={{ $json.id }}",
"column": "attendee_id"
},
{
"value": "={{ $('Webhook Trigger').first().json.body.eventId }}",
"column": "event_id"
},
{
"value": "={{ $json.followUpPriority }}",
"column": "priority"
},
{
"value": "={{ $json.interactionScore }}",
"column": "interaction_score"
},
{
"value": true,
"column": "email_sent"
},
{
"value": "={{ JSON.stringify($json.aiInsights) }}",
"column": "ai_insights"
},
{
"value": "={{ $now }}",
"column": "created_at"
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"typeVersion": 2.4
},
{
"id": "0f3ab05d-2f77-45eb-9fa0-b296bb645410",
"name": "生成分析报告",
"type": "n8n-nodes-base.code",
"position": [
2000,
432
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1f32a972-e373-4b26-b2d1-d2f3151dff21",
"name": "发送响应",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
2224,
432
],
"parameters": {
"options": {},
"respondWith": "json",
"responseBody": "={{ {\n success: true,\n message: 'Networking assistant completed',\n analytics: $json\n} }}"
},
"typeVersion": 1
},
{
"id": "cb0350f4-0ff5-4050-b790-3af2ad5e96d7",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
400,
432
],
"parameters": {
"options": {}
},
"typeVersion": 2.2
},
{
"id": "220f2155-4052-4454-994a-bc88dc574a5d",
"name": "AI Agent1",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
976,
128
],
"parameters": {
"options": {}
},
"typeVersion": 2.2
},
{
"id": "4c17b902-da18-40f1-b8c0-9d78e2a21c0d",
"name": "AI Agent2",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
976,
640
],
"parameters": {
"options": {}
},
"typeVersion": 2.2
},
{
"id": "ac38fead-87f9-4435-b545-68531ab899c1",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-128,
32
],
"parameters": {
"color": 4,
"height": 768,
"content": "从您的活动平台收集参会者数据"
},
"typeVersion": 1
},
{
"id": "54c84b81-ca01-4df7-95a8-40dcb011d439",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
144,
160
],
"parameters": {
"width": 176,
"height": 608,
"content": "通过 LinkedIn 个人资料和实时互动日志进行数据丰富"
},
"typeVersion": 1
},
{
"id": "da960d89-b2bc-48f7-b35e-940c8d2d0f79",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
384,
-48
],
"parameters": {
"color": 4,
"width": 512,
"height": 1056,
"content": "使用 AI 分析对话、角色和共同兴趣"
},
"typeVersion": 1
},
{
"id": "0f197150-6b66-41f7-af23-ac8cc783f77e",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
944,
-48
],
"parameters": {
"width": 512,
"height": 1056,
"content": "生成超个性化跟进邮件和 LinkedIn 消息,并通过首选渠道(邮件、LinkedIn、Slack)发送消息"
},
"typeVersion": 1
},
{
"id": "8669cf7f-03be-4045-b384-6e1551f8b908",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1488,
-64
],
"parameters": {
"color": 4,
"width": 912,
"height": 1056,
"content": "使用跟进状态和后续步骤更新 HubSpot CRM"
},
"typeVersion": 1
},
{
"id": "2c9cc858-4882-4645-9570-97783d4c5e6f",
"name": "发送邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
1328,
240
],
"webhookId": "ea153704-a86b-4095-9f7f-58de6409bda2",
"parameters": {
"options": {
"allowUnauthorizedCerts": false
},
"subject": "=Great connecting at {{ $('Webhook Trigger').first().json.body.eventName }}!",
"toEmail": "xyz@gmail.com",
"fromEmail": "abc@gmail.com"
},
"credentials": {
"smtp": {
"id": "G1kyF8cSWTZ4vouN",
"name": "SMTP -test"
}
},
"typeVersion": 2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "6295ff20-ac7c-46f5-aa13-2f4f5a47302f",
"connections": {
"AI Agent": {
"main": [
[
{
"node": "Filter High Priority",
"type": "main",
"index": 0
},
{
"node": "Filter Medium Priority",
"type": "main",
"index": 0
}
]
]
},
"AI Agent1": {
"main": [
[
{
"node": "Send email",
"type": "main",
"index": 0
}
]
]
},
"AI Agent2": {
"main": [
[
{
"node": "Send LinkedIn",
"type": "main",
"index": 0
},
{
"node": "Slack Notification",
"type": "main",
"index": 0
}
]
]
},
"Send email": {
"main": [
[
{
"node": "Update CRM",
"type": "main",
"index": 0
}
]
]
},
"Update CRM": {
"main": [
[
{
"node": "Save to Database",
"type": "main",
"index": 0
}
]
]
},
"Get Attendees": {
"main": [
[
{
"node": "Merge & Enrich Data",
"type": "main",
"index": 0
}
]
]
},
"Send LinkedIn": {
"main": [
[
{
"node": "Update CRM",
"type": "main",
"index": 0
}
]
]
},
"Generate Email": {
"ai_languageModel": [
[
{
"node": "AI Agent1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Webhook Trigger": {
"main": [
[
{
"node": "Get Attendees",
"type": "main",
"index": 0
},
{
"node": "Get Interactions",
"type": "main",
"index": 0
},
{
"node": "Enrich LinkedIn Data",
"type": "main",
"index": 0
}
]
]
},
"Get Interactions": {
"main": [
[
{
"node": "Merge & Enrich Data",
"type": "main",
"index": 0
}
]
]
},
"Save to Database": {
"main": [
[
{
"node": "Generate Analytics",
"type": "main",
"index": 0
}
]
]
},
"AI Analyze Profile": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Generate Analytics": {
"main": [
[
{
"node": "Send Response",
"type": "main",
"index": 0
}
]
]
},
"Slack Notification": {
"main": [
[
{
"node": "Save to Database",
"type": "main",
"index": 0
}
]
]
},
"Merge & Enrich Data": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Enrich LinkedIn Data": {
"main": [
[
{
"node": "Merge & Enrich Data",
"type": "main",
"index": 0
}
]
]
},
"Filter High Priority": {
"main": [
[
{
"node": "AI Agent1",
"type": "main",
"index": 0
}
]
]
},
"Generate LinkedIn Msg": {
"ai_languageModel": [
[
{
"node": "AI Agent2",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Filter Medium Priority": {
"main": [
[
{
"node": "AI Agent2",
"type": "main",
"index": 0
}
]
]
}
}
}如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
高级 - 客户培育, 多模态 AI
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
分享此工作流