8
n8n 中文网amn8n.com

智能活动跟进与社交助手

高级

这是一个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
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "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": {
    "cb0350f4-0ff5-4050-b790-3af2ad5e96d7": {
      "main": [
        [
          {
            "node": "345b815d-2f48-438c-8a4d-8cf50db45492",
            "type": "main",
            "index": 0
          },
          {
            "node": "3893012b-cbc5-44a9-b345-c288cf759562",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "220f2155-4052-4454-994a-bc88dc574a5d": {
      "main": [
        [
          {
            "node": "2c9cc858-4882-4645-9570-97783d4c5e6f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4c17b902-da18-40f1-b8c0-9d78e2a21c0d": {
      "main": [
        [
          {
            "node": "bd5c3beb-0e48-45a1-b88d-1657e87a1664",
            "type": "main",
            "index": 0
          },
          {
            "node": "f8b77773-301d-4846-b205-462123837c66",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2c9cc858-4882-4645-9570-97783d4c5e6f": {
      "main": [
        [
          {
            "node": "12fa20d1-4bb6-4f08-8422-73b32e68cc12",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "12fa20d1-4bb6-4f08-8422-73b32e68cc12": {
      "main": [
        [
          {
            "node": "25976c83-8a67-41bc-9fbf-57bb9c662c20",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e935b3a3-a41e-45c5-b830-c45476ea5f09": {
      "main": [
        [
          {
            "node": "06001185-5d97-4290-9832-3dc0c806f3bc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bd5c3beb-0e48-45a1-b88d-1657e87a1664": {
      "main": [
        [
          {
            "node": "12fa20d1-4bb6-4f08-8422-73b32e68cc12",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ca7083ce-c154-40d1-aee0-a792efdb1539": {
      "ai_languageModel": [
        [
          {
            "node": "220f2155-4052-4454-994a-bc88dc574a5d",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "77382348-01bf-4d73-806c-67af02c67114": {
      "main": [
        [
          {
            "node": "e935b3a3-a41e-45c5-b830-c45476ea5f09",
            "type": "main",
            "index": 0
          },
          {
            "node": "e089c5fe-2a41-4b9a-bc76-0318bab22bc6",
            "type": "main",
            "index": 0
          },
          {
            "node": "5f7f56f1-b1d1-4fa9-9e87-982128a37b5d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e089c5fe-2a41-4b9a-bc76-0318bab22bc6": {
      "main": [
        [
          {
            "node": "06001185-5d97-4290-9832-3dc0c806f3bc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "25976c83-8a67-41bc-9fbf-57bb9c662c20": {
      "main": [
        [
          {
            "node": "0f3ab05d-2f77-45eb-9fa0-b296bb645410",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2c79001e-7667-4fac-a26b-ab64c001ca94": {
      "ai_languageModel": [
        [
          {
            "node": "cb0350f4-0ff5-4050-b790-3af2ad5e96d7",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "0f3ab05d-2f77-45eb-9fa0-b296bb645410": {
      "main": [
        [
          {
            "node": "1f32a972-e373-4b26-b2d1-d2f3151dff21",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f8b77773-301d-4846-b205-462123837c66": {
      "main": [
        [
          {
            "node": "25976c83-8a67-41bc-9fbf-57bb9c662c20",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "06001185-5d97-4290-9832-3dc0c806f3bc": {
      "main": [
        [
          {
            "node": "cb0350f4-0ff5-4050-b790-3af2ad5e96d7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5f7f56f1-b1d1-4fa9-9e87-982128a37b5d": {
      "main": [
        [
          {
            "node": "06001185-5d97-4290-9832-3dc0c806f3bc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "345b815d-2f48-438c-8a4d-8cf50db45492": {
      "main": [
        [
          {
            "node": "220f2155-4052-4454-994a-bc88dc574a5d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "702d8331-1bbf-4a34-afac-4977fcd40098": {
      "ai_languageModel": [
        [
          {
            "node": "4c17b902-da18-40f1-b8c0-9d78e2a21c0d",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "3893012b-cbc5-44a9-b345-c288cf759562": {
      "main": [
        [
          {
            "node": "4c17b902-da18-40f1-b8c0-9d78e2a21c0d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

高级 - 客户培育, 多模态 AI

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
高级
节点数量25
分类2
节点类型11
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The 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.

外部链接
在 n8n.io 查看

分享此工作流

分类

分类: 34