8
n8n 中文网amn8n.com

09 - 潜在客户档案增强器

高级

这是一个Lead Nurturing, Multimodal AI领域的自动化工作流,包含 30 个节点。主要使用 If, Set, Code, Wait, Gmail 等节点。 自动化潜在客户信息丰富与个性化外联:HubSpot、Phantombuster和GPT

前置要求
  • Google 账号和 Gmail API 凭证
  • HubSpot API Key
  • HTTP Webhook 端点(n8n 会自动生成)
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "SANITIZED_WORKFLOW_ID",
  "meta": {
    "instanceId": "SANITIZED_INSTANCE_ID",
    "templateCredsSetupCompleted": false
  },
  "name": "09 - 潜在客户档案增强器",
  "tags": [],
  "nodes": [
    {
      "id": "7cac7cf5-958f-4a8b-8519-8ff30ea3dd1b",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -180,
        -160
      ],
      "parameters": {
        "color": 5,
        "width": 649,
        "height": 664,
        "content": "## 🔗 触发器与输入"
      },
      "typeVersion": 1
    },
    {
      "id": "007a3ed2-25f0-4e78-8429-52b35586cc78",
      "name": "📝 使用用户 Twitter/LinkedIn 更新表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        320,
        120
      ],
      "parameters": {
        "columns": {
          "value": {
            "Status": "Done",
            "Profiles": "={{ $json.properties.twitter.value }}"
          },
          "schema": [
            {
              "id": "Profiles",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Profiles",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Profiles"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_GOOGLE_SHEET_ID",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit",
          "cachedResultName": "Your Sheet Name"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "YOUR_GOOGLE_SHEETS_CREDENTIAL_ID",
          "name": "Google Sheets OAuth2 Credential"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "0515886e-a3d8-4a8e-a01b-90b8cb320348",
      "name": "👤 获取联系人",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        100,
        120
      ],
      "parameters": {
        "contactId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.body[0].objectId }}"
        },
        "operation": "get",
        "authentication": "appToken",
        "additionalFields": {}
      },
      "credentials": {
        "hubspotAppToken": {
          "id": "YOUR_HUBSPOT_CREDENTIAL_ID",
          "name": "HubSpot App Token Credential"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "fec95488-309a-4b87-a38a-517eba206127",
      "name": "🔗 HubSpot 联系人 Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -120,
        120
      ],
      "webhookId": "YOUR_WEBHOOK_ID",
      "parameters": {
        "path": "webhook-endpoint",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2
    },
    {
      "id": "e16a8110-05b4-4712-8a14-eda731bf702b",
      "name": "✅ 验证 Twitter/LinkedIn 存在",
      "type": "n8n-nodes-base.if",
      "position": [
        540,
        120
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "1d288783-b441-4f91-9067-c267015477e5",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.Profiles }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "b39ce319-58df-431a-a187-f6f35d27ff5a",
      "name": "🚀 启动档案采集器",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        760,
        220
      ],
      "parameters": {
        "url": "=https://api.phantombuster.com/api/v2/agents/launch",
        "method": "POST",
        "options": {},
        "jsonBody": "{\n  \"id\": \"YOUR_PROFILE_SCRAPER_ID\",\n  \"manualLaunch\": true\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "X-Phantombuster-Key-1",
              "value": "YOUR_PHANTOMBUSTER_API_KEY"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "c1625010-5d09-46be-9c0a-4b68965a606a",
      "name": "🎯 启动推文采集器",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        760,
        20
      ],
      "parameters": {
        "url": "=https://api.phantombuster.com/api/v2/agents/launch",
        "method": "POST",
        "options": {},
        "jsonBody": "{\n  \"id\": \"YOUR_TWEET_SCRAPER_ID\",\n  \"manualLaunch\": true\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "X-Phantombuster-Key-1",
              "value": "YOUR_PHANTOMBUSTER_API_KEY"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.1
    },
    {
      "id": "ebf5cba0-2b4f-419c-b837-b6e6c16ce197",
      "name": "⏳ 等待档案处理",
      "type": "n8n-nodes-base.wait",
      "position": [
        980,
        220
      ],
      "webhookId": "YOUR_PROFILE_WAIT_WEBHOOK_ID",
      "parameters": {
        "amount": 30
      },
      "typeVersion": 1.1
    },
    {
      "id": "3045d517-cbfd-4211-b4e1-3ab9dceaf949",
      "name": "⏳ 等待推文处理",
      "type": "n8n-nodes-base.wait",
      "position": [
        980,
        20
      ],
      "webhookId": "YOUR_TWEET_WAIT_WEBHOOK_ID",
      "parameters": {
        "amount": 60
      },
      "typeVersion": 1.1
    },
    {
      "id": "69537661-7f91-43a1-b7e7-0f2717c5d5ab",
      "name": "📊 获取档案结果",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1200,
        220
      ],
      "parameters": {
        "url": "=https://api.phantombuster.com/api/v2/containers/fetch-output?id={{ $json.containerId }}",
        "options": {
          "response": {
            "response": {}
          }
        },
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "X-Phantombuster-Key-1",
              "value": "YOUR_PHANTOMBUSTER_API_KEY_1"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "a92e1e5d-c07e-45e0-9ba9-ca00f348681e",
      "name": "📊 获取推文结果",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1200,
        20
      ],
      "parameters": {
        "url": "=https://api.phantombuster.com/api/v2/containers/fetch-output?id={{ $json.containerId }}&withResultObject=true",
        "options": {
          "response": {
            "response": {}
          }
        },
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "X-Phantombuster-Key-1",
              "value": "YOUR_PHANTOMBUSTER_API_KEY_2"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "28b7f093-9752-4f3b-8c3a-cb9985d74852",
      "name": "🔍 提取档案 URL",
      "type": "n8n-nodes-base.code",
      "position": [
        1420,
        220
      ],
      "parameters": {
        "jsCode": "// Extract the JSON URL from the Phantombuster output\nconst output = $input.first().json.output;\n\n// More specific regex pattern to match the JSON result URL\nconst jsonUrlMatch = output.match(/JSON saved at (https:\\/\\/phantombuster\\.s3\\.amazonaws\\.com\\/\\w+\\/\\w+\\/result\\.json)/);\n\nif (jsonUrlMatch) {\n  return [{ json: { resultUrl: jsonUrlMatch[1] } }];\n} else {\n  // If JSON URL not found, also try to find CSV URL as fallback\n  const csvUrlMatch = output.match(/CSV saved at (https:\\/\\/phantombuster\\.s3\\.amazonaws\\.com\\/\\w+\\/\\w+\\/result\\.csv)/);\n  \n  if (csvUrlMatch) {\n    return [{ json: { resultUrl: csvUrlMatch[1] } }];\n  } else {\n    throw new Error('Could not find result URL in output. Output: ' + output);\n  }\n}"
      },
      "typeVersion": 2
    },
    {
      "id": "5c3096a3-4b77-4edc-b44f-6a0758299fba",
      "name": "🔍 提取推文 URL",
      "type": "n8n-nodes-base.code",
      "position": [
        1420,
        20
      ],
      "parameters": {
        "jsCode": "// Extract the JSON URL from the output\nconst output = $input.first().json.output;\nconst jsonUrlMatch = output.match(/JSON saved at (https:\\/\\/phantombuster\\.s3\\.amazonaws\\.com\\/[^\\s]+\\.json)/);\n\nif (jsonUrlMatch) {\n  return [{ json: { resultUrl: jsonUrlMatch[1] } }];\n} else {\n  throw new Error('Could not find result URL in output');\n}"
      },
      "typeVersion": 2
    },
    {
      "id": "00aa83c9-c9d1-4649-a52e-ed61e1cefb90",
      "name": "📥 下载档案数据",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1640,
        220
      ],
      "parameters": {
        "url": "={{ $json.resultUrl }}",
        "options": {
          "response": {
            "response": {
              "responseFormat": "file"
            }
          }
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "84dd3555-1bd1-4808-9dc0-6dab6650fd24",
      "name": "📋 解析档案 JSON",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        1860,
        220
      ],
      "parameters": {
        "options": {},
        "operation": "fromJson"
      },
      "typeVersion": 1
    },
    {
      "id": "666741d2-2991-4582-ab3b-1249991e07b7",
      "name": "🏷️ 格式化档案字段",
      "type": "n8n-nodes-base.set",
      "position": [
        2080,
        220
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "db34c1fc-0c06-4704-af41-5aa212f5436d",
              "name": "Twitter",
              "type": "string",
              "value": "={{ $json.data[0].query }}"
            },
            {
              "id": "cccd2ae9-6f56-45f7-8dcd-6a1d2253c86d",
              "name": "Tweet Count",
              "type": "string",
              "value": "={{ $json.data[0].tweetsCount }}"
            },
            {
              "id": "42e93287-b26a-4512-9c75-ced1102222ea",
              "name": "Followers",
              "type": "string",
              "value": "={{ $json.data[0].followers }}"
            },
            {
              "id": "ff19814a-1507-4855-9c82-94cb1e5b5afc",
              "name": "Following",
              "type": "string",
              "value": "={{ $json.data[0].following }}"
            },
            {
              "id": "04919753-74e6-4358-8ddb-4ce39e03e0cb",
              "name": "Likes",
              "type": "string",
              "value": "={{ $json.data[0].likes }}"
            },
            {
              "id": "0864c613-5243-4ec6-b804-a8e234a85706",
              "name": "Lists",
              "type": "string",
              "value": "={{ $json.data[0].lists }}"
            },
            {
              "id": "e6b83a62-7687-4c5c-bc53-4fcf12e184fe",
              "name": "Bio",
              "type": "string",
              "value": "={{ $json.data[0].bio }}"
            },
            {
              "id": "cd6a44d1-ba8b-45fb-99d1-ccc6e76a395b",
              "name": "Website",
              "type": "string",
              "value": "={{ $json.data[0].website }}"
            },
            {
              "id": "39c544e4-0253-464e-ba89-f093db6575a5",
              "name": "Verified",
              "type": "string",
              "value": "={{ $json.data[0].verified }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "217803a0-a475-4b87-bd5b-573682b956c9",
      "name": "🏷️ 格式化推文字段",
      "type": "n8n-nodes-base.set",
      "position": [
        2080,
        20
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "c25b75bf-dd1a-48c4-bdd7-5e7ad939cae6",
              "name": "Tweets",
              "type": "string",
              "value": "="
            },
            {
              "id": "a6ab20fe-d29d-4fbb-8f72-fd232db84e8b",
              "name": "Email",
              "type": "string",
              "value": "={{ $('👤 Fetch Contact').item.json.properties.email.value }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "2f321e43-3784-4097-a261-7812b97e645c",
      "name": "🔄 合并数据流",
      "type": "n8n-nodes-base.merge",
      "position": [
        2300,
        120
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "4366bb24-e6ae-4fcf-a5c7-6a2a96b24dd2",
      "name": "🧩 合并所有数据",
      "type": "n8n-nodes-base.code",
      "position": [
        2520,
        120
      ],
      "parameters": {
        "jsCode": "// Get all input items\nconst inputData = $input.all().map(item => item.json);\n\n// Merge all objects into one\nconst combined = inputData.reduce((acc, curr) => {\n  return { ...acc, ...curr };\n}, {});\n\n// Return the merged object\nreturn [\n  {\n    json: combined\n  }\n];"
      },
      "typeVersion": 2
    },
    {
      "id": "96797231-0f43-4e79-bc87-e62e5ba63b11",
      "name": "🧠 生成个性化邮件",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        2740,
        120
      ],
      "parameters": {
        "text": "=You are an AI assistant helping write personalized emails using social media profile data.\n\nHere is the extracted Twitter profile data:\n\n{\n  \"Tweets\": {{ $json.Tweets }},\n  \"Twitter\": {{ $json.Twitter }},\n  \"Tweet Count\": {{ $json['Tweet Count'] }},\n  \"Followers\": {{ $json.Followers }},\n  \"Following\": {{ $json.Following }},\n  \"Likes\": {{ $json.Likes }},\n  \"Lists\": {{ $json.Lists }},\n  \"Bio\": {{ $json.Bio }},\n  \"Website\": {{ $json.Website }},\n  \"Verified\": {{ $json.Verified }}\n}\n\n✅ Based on this, write a professional and engaging HTML email to the user of the profile.\nThe email should:\n\nStart with a relevant and compelling subject line.\n\nInclude a personalized introduction using the profile info (like follower count, profession, etc.).\n\nMention the value we can offer (you can assume the sender is a brand or platform).\n\nInclude a call to action (e.g., connect with us, collaborate, reply back, etc.).\n\nBe formatted in clean HTML.\n\n🔻 Your response must be a JSON with two keys:\n\n\"subject\": Plain text string for email subject.\n\n\"body\": A string with HTML content of the email body.\n\nhere's my information \nName: [YOUR_NAME]\nPosition: [YOUR_POSITION]\nCompany: [YOUR_COMPANY]\nTwitter: [YOUR_TWITTER_URL]\nInstagram: [YOUR_INSTAGRAM_URL]\n",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 2
    },
    {
      "id": "7318c5ff-85e3-4cd3-bfda-0d84e7e4f4e6",
      "name": "🤖 OpenAI 语言模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        2828,
        340
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "YOUR_OPENAI_CREDENTIAL_ID",
          "name": "OpenAI API Credential"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "516f428e-e79e-41c2-946c-6d9b299ba651",
      "name": "✂️ 解析邮件内容",
      "type": "n8n-nodes-base.code",
      "position": [
        3116,
        120
      ],
      "parameters": {
        "jsCode": "// Get the raw string inside the output field\nconst rawOutput = $input.first().json.output;\n\n// Remove ```json and ``` if present, and trim whitespace\nconst cleaned = rawOutput\n  .replace(/```json|```/g, '')\n  .trim();\n\n// Parse the cleaned JSON string\nconst parsed = JSON.parse(cleaned);\n\n// Return subject and body\nreturn [\n  {\n    json: {\n      subject: parsed.subject,\n      body: parsed.body\n    }\n  }\n];"
      },
      "typeVersion": 2
    },
    {
      "id": "f63668c9-dde2-447e-9dff-397cb97875ef",
      "name": "📧 发送邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        3336,
        120
      ],
      "webhookId": "YOUR_EMAIL_WEBHOOK_ID",
      "parameters": {
        "sendTo": "={{ $('🧩 Combine All Data').item.json.Email }}",
        "message": "={{ $json.body }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "={{ $json.subject }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "YOUR_GMAIL_CREDENTIAL_ID",
          "name": "Gmail OAuth2 Credential"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "d3dd663b-8251-41cd-9e83-41fce92bc67f",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        -160
      ],
      "parameters": {
        "width": 220,
        "height": 660,
        "content": "## ✅ 条件路径"
      },
      "typeVersion": 1
    },
    {
      "id": "2c82fb3f-9b14-4872-970d-384bd4c17849",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        720,
        -560
      ],
      "parameters": {
        "color": 3,
        "width": 840,
        "height": 1060,
        "content": "## 🔍 社交媒体采集(使用 Phantombuster)"
      },
      "typeVersion": 1
    },
    {
      "id": "3bfc5f34-f068-42a7-a1d4-bc52767b64c0",
      "name": "📋 下载推文 JSON",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1640,
        20
      ],
      "parameters": {
        "url": "={{ $json.resultUrl }}",
        "options": {
          "response": {
            "response": {
              "responseFormat": "file"
            }
          }
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "21dad60e-b732-47e3-97ae-3c0ebc596393",
      "name": "📋 解析推文 JSON",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        1860,
        20
      ],
      "parameters": {
        "options": {},
        "operation": "fromJson"
      },
      "typeVersion": 1
    },
    {
      "id": "d3df814b-7990-4f80-92cb-748070d98068",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1580,
        -260
      ],
      "parameters": {
        "color": 6,
        "width": 420,
        "height": 760,
        "content": "## 📥 数据下载与解析"
      },
      "typeVersion": 1
    },
    {
      "id": "e3c99a78-d4ad-4fc4-8ef7-a0729f2e624f",
      "name": "便签说明4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2040,
        -360
      ],
      "parameters": {
        "color": 4,
        "width": 640,
        "height": 860,
        "content": "## 🏷️ 数据结构化"
      },
      "typeVersion": 1
    },
    {
      "id": "f88a12de-b2ce-4de5-a0e8-767098748464",
      "name": "便签说明5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2700,
        -180
      ],
      "parameters": {
        "color": 5,
        "width": 780,
        "height": 680,
        "content": "## ✉️ 邮件生成与发送"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "SANITIZED_VERSION_ID",
  "connections": {
    "👤 Fetch Contact": {
      "main": [
        [
          {
            "node": "📝 Update Sheet with Users Twitter/LinkedIn",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📋 Parse Tweet JSON": {
      "main": [
        [
          {
            "node": "🏷️ Format Tweet Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧩 Combine All Data": {
      "main": [
        [
          {
            "node": "🧠 Generate Personalized Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔍 Extract Tweet URL": {
      "main": [
        [
          {
            "node": "📋 Download Tweet JSON",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📋 Parse Profile JSON": {
      "main": [
        [
          {
            "node": "🏷️ Format Profile Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔄 Merge Data Streams": {
      "main": [
        [
          {
            "node": "🧩 Combine All Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊 Fetch Tweet Results": {
      "main": [
        [
          {
            "node": "🔍 Extract Tweet URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📋 Download Tweet JSON": {
      "main": [
        [
          {
            "node": "📋 Parse Tweet JSON",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔍 Extract Profile URL": {
      "main": [
        [
          {
            "node": "📥 Download Profile Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🎯 Launch Tweet Scraper": {
      "main": [
        [
          {
            "node": "⏳ Wait for Tweet Processing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "✂️ Parse Email Content": {
      "main": [
        [
          {
            "node": "📧 Sends Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊 Fetch Profile Results": {
      "main": [
        [
          {
            "node": "🔍 Extract Profile URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📥 Download Profile Data": {
      "main": [
        [
          {
            "node": "📋 Parse Profile JSON",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🤖 OpenAI Language Model": {
      "ai_languageModel": [
        [
          {
            "node": "🧠 Generate Personalized Email",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "🏷️ Format Tweet Fields": {
      "main": [
        [
          {
            "node": "🔄 Merge Data Streams",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🚀 Launch Profile Scraper": {
      "main": [
        [
          {
            "node": "⏳ Wait for Profile Processing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔗 HubSpot Contact Webhook": {
      "main": [
        [
          {
            "node": "👤 Fetch Contact",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "⏳ Wait for Tweet Processing": {
      "main": [
        [
          {
            "node": "📊 Fetch Tweet Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🏷️ Format Profile Fields": {
      "main": [
        [
          {
            "node": "🔄 Merge Data Streams",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "⏳ Wait for Profile Processing": {
      "main": [
        [
          {
            "node": "📊 Fetch Profile Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧠 Generate Personalized Email": {
      "main": [
        [
          {
            "node": "✂️ Parse Email Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "✅ Validate Twitter/LinkedIn Exists": {
      "main": [
        [
          {
            "node": "🚀 Launch Profile Scraper",
            "type": "main",
            "index": 0
          },
          {
            "node": "🎯 Launch Tweet Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📝 Update Sheet with Users Twitter/LinkedIn": {
      "main": [
        [
          {
            "node": "✅ Validate Twitter/LinkedIn Exists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

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

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

作者
Avkash Kakdiya

Avkash Kakdiya

@itechnotion

🚀 Founder of iTechNotion — we build custom AI-powered automation workflows for startups, agencies, and founders. 💡 Specializing in agentic AI systems, content automation, sales funnels, and digital workers. 🔧 14+ years in tech | Building scalable no-code/low-code solutions using n8n, OpenAI, and other API-first tools. 📬 Let’s automate what slows you down.

外部链接
在 n8n.io 查看

分享此工作流