8
n8n 中文网amn8n.com

使用GPT-4 Mini、Apify和LinkedIn生成个性化冷邮件开场白

高级

这是一个Lead Generation, Multimodal AI领域的自动化工作流,包含 16 个节点。主要使用 Set, Filter, Aggregate, HttpRequest, GoogleSheets 等节点。 使用GPT-4 Mini、Apify和LinkedIn生成个性化冷邮件开场白

前置要求
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "235448548816fb2146ac5c0df5e58a4e0be98ea5380c09b000703674b2c5f3c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "49891093-0149-475d-ad6a-b80832087c47",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -48,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "947b70ae-4cab-4c36-b4f4-27d36d78915e",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        864,
        80
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "5f132e78-5a48-45b2-a777-87983fb5a647",
      "name": "调用Apify LinkedIn API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1408,
        96
      ],
      "parameters": {
        "url": "=https://api.apify.com/v2/acts/{{ $json.apifyActorID }}/run-sync-get-dataset-items",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "={\n    \"profileUrls\": [\n        \"{{ $('Loop Over Items').item.json.linkedin_url }}\"\n    ]\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Accept",
              "value": "application/json"
            },
            {
              "name": "Authorization",
              "value": "=Bearer {{ $json.apifyAPIKey }}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "b411411c-96b9-48b8-8d4d-b4884912336c",
      "name": "聚合",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1632,
        96
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "e8a9b61d-4cf8-4b0e-a10d-ba83d212ae07",
      "name": "生成个性化开场白",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        2192,
        96
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini",
          "cachedResultName": "GPT-4.1-MINI"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "=You are a useful intelligent sales assistant.\n\nYou are given a set of information about a lead (LinkedIn profile data, headline, company SEO, etc). These are all people in the dental industry in the US. We are offering them custom AI voice receptionist that answers calls 24/7 and works into their CRM. \n\nYour task is to to take all these info and turn them into catchy, personalized openers/icebreakers for our cold email campaign. Keep the icebreakers short and 3-4 sentences max.\n\nYou'll return your icebreakers in the following JSON format:\n\n{\"icebreaker\":\"Hey {first_name},\\n\\nI spent some time studying {theirCompanyName} and was genuinely impressed by {thing}. I have a business proposal which might help you so thought I'd reach out.\"} \n\n\nRules:\n- Write in a spartan/laconic tone of voice.\n- Always mention their first Name and their shortened company name in the copy\n- Make sure to use the above format when constructing your icebreakers. We wrote it this way on purpose.\n- Shorten the company name wherever possible (say, \"XYZ\" instead of \"XYZ Dental\"). More examples: \"Love AMS\" instead of \"Love AMS Dental Group\", \"Love Tooth Tales\" instead of \"Love Tooth Tales Pediatric Dentistry & Orthodontics\", \"Love Dental Solutions\" instead of \"Love Dental Solutions, LLC\", \"Love Bernstein\" instead of \"Love Bernstein Orthodontics\", \"Love Pinnacle\" instead of \"Love Pinnacle Dental Group\", etc.\n- Do the same with locations. \"San Fran\" instead of \"San Fransisco\", \"LA\" instead of \"Los Angeles\", \"NJ\" instead of \"New Jersey\", etc.\n- For your variables, focus on small, non-obvious things to paraphrase. The idea is to make people think we *really* dove deep into their website/Linkedin profile, so don't use something obvious. Do not say cookie-cutter stuff like \"Love your website!\" or \"Love your years of experience!\".\n\n\n\n"
            },
            {
              "content": "=firstName: {{ $json.firstName }}\n\nlastName: {{ $json.lastName }}\n\ncompanyName: {{ $json.companyName }}\n\nheadline: {{ $json.headline }}\n\ncurrentJobDurationInYrs: {{ $json.currentJobDurationInYrs }}\n\nemail: {{ $json.email }}\n\norganizationShortDescription: {{ $json.organizationShortDescription }}\n\norganizationCity: {{ $json.organizationCity }}\n\norganizationState: {{ $json.organizationState }}\n\nData found from their LinkedIn:\n{{ Object.entries($('Aggregate').item.json.data[0]).map(([key, value]) => {\n  if (typeof value === 'object' && value !== null) {\n    return `${key}:\\n${JSON.stringify(value, null, 2)}`;\n  }\n  return `${key}: ${value}`;\n}).join('\\n\\n') }}"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "21ws2m6bU7yrdhRD",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "50ae1e60-f2cb-491e-8d02-20d8c31e91e6",
      "name": "附加增强的开场白",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1888,
        656
      ],
      "parameters": {
        "columns": {
          "value": {
            "id": "={{ $('Loop Over Items').item.json.id }}",
            "name": "={{ $('Loop Over Items').item.json.name }}",
            "email": "={{ $('Loop Over Items').item.json.email }}",
            "company": "={{ $('Loop Over Items').item.json.organization_name }}",
            "headline": "={{ $('Simplify Fields for AI Agent').item.json.headline }}",
            "linkedIn": "={{ $('Loop Over Items').item.json.linkedin_url }}",
            "icebreaker": "={{ $json.message.content.icebreaker }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "id",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "company",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "headline",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "headline",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "icebreaker",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "icebreaker",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "linkedIn",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "linkedIn",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "id"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1772101798,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw/edit#gid=1772101798",
          "cachedResultName": "Enriched"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw/edit?usp=drivesdk",
          "cachedResultName": "USA_Dental"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ziNN7PjMJnH4Xalf",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "7263e986-8992-4f26-9df1-4c00a1a0d73a",
      "name": "更新未增强列表",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2320,
        656
      ],
      "parameters": {
        "columns": {
          "value": {
            "id": "={{ $('hasEmail?').item.json.id }}",
            "status": "enriched"
          },
          "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": "email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "personal_email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "personal_email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_website_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_website_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "linkedin_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "linkedin_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "industry",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "headline",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "headline",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "seniority",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "seniority",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "estimated_num_employees",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "estimated_num_employees",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "city",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "city",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "state",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "state",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_annual_revenue_printed",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_annual_revenue_printed",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_seo_description",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_seo_description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_short_description",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_short_description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "keywords",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "keywords",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_technologies",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_technologies",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email_domain_catchall",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "email_domain_catchall",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "id",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_id",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "twitter_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "twitter_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "facebook_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "facebook_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_linkedin_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_linkedin_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_linkedin_uid",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_linkedin_uid",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_twitter_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_twitter_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_facebook_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_facebook_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_founded_year",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_founded_year",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_primary_domain",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_primary_domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_street_address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_street_address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_raw_address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_raw_address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_state",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_state",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_city",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_city",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "organization_postal_code",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "organization_postal_code",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "id"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 206882063,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw/edit#gid=206882063",
          "cachedResultName": "100 Leads"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw/edit?usp=drivesdk",
          "cachedResultName": "USA_Dental"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ziNN7PjMJnH4Xalf",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "1bc1dfa6-e4b3-45d4-b30c-9b953c21a0b5",
      "name": "hasEmail?",
      "type": "n8n-nodes-base.filter",
      "position": [
        480,
        80
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c6b56607-6929-42cd-8c72-d7cff6c80066",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "1abc54ec-ae6b-460c-b560-d5e2bef27458",
      "name": "为AI Agent简化字段",
      "type": "n8n-nodes-base.set",
      "position": [
        1952,
        96
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "c2c46a40-fb08-41f1-a692-422f525813e9",
              "name": "firstName",
              "type": "string",
              "value": "={{ $json.data[0].firstName }}"
            },
            {
              "id": "09bb5d67-8b12-47e5-b0e0-e4bd1bad4f9a",
              "name": "lastName",
              "type": "string",
              "value": "={{ $json.data[0].lastName }}"
            },
            {
              "id": "1055fac7-ec58-4b52-941d-1d15de09d419",
              "name": "companyName",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json.organization_name }}"
            },
            {
              "id": "1714c8ee-f694-484b-b0d8-aade982c6a51",
              "name": "headline",
              "type": "string",
              "value": "={{ $json.data[0].headline }}"
            },
            {
              "id": "2e1b64a2-b7d3-4524-8b5b-38a8b728dca7",
              "name": "currentJobDurationInYrs",
              "type": "number",
              "value": "={{ $json.data[0].currentJobDurationInYrs }}"
            },
            {
              "id": "04409de1-1672-4b1f-a1db-7ac098789eba",
              "name": "email",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json.email }}"
            },
            {
              "id": "4da75ea0-5f95-4083-9e20-ef9a0ec7898a",
              "name": "organizationShortDescription",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json.organization_short_description }}"
            },
            {
              "id": "185993ef-25a8-483b-a748-4c6515a3f0f6",
              "name": "organizationCity",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json.organization_city }}"
            },
            {
              "id": "f0d764c6-6eb0-4743-b476-49486e259945",
              "name": "organizationState",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json.organization_state }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "330e4c8f-376d-4738-87ee-50877f64f162",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        -304
      ],
      "parameters": {
        "width": 672,
        "height": 720,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3c4c4919-81c6-4ad5-a7dd-594271fd59c1",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        -96
      ],
      "parameters": {
        "color": 3,
        "width": 560,
        "height": 400,
        "content": "## 预处理原始潜在客户"
      },
      "typeVersion": 1
    },
    {
      "id": "7b97c7f6-4d1e-4cd3-a73e-3f9894e340d7",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1120,
        -96
      ],
      "parameters": {
        "color": 2,
        "width": 672,
        "height": 400,
        "content": "## 从LinkedIn获取数据并清理"
      },
      "typeVersion": 1
    },
    {
      "id": "2651f7b6-fd1f-41cd-bb78-68046d3a8bab",
      "name": "获取原始未增强潜在客户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        256,
        80
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "un-enriched",
              "lookupColumn": "status"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 206882063,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw/edit#gid=206882063",
          "cachedResultName": "100 Leads"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1kJq_R41U_PkQlIhi7D1LTAhWP-RO0hSRjUNf9C4AHUw/edit?usp=drivesdk",
          "cachedResultName": "USA_Dental"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ziNN7PjMJnH4Xalf",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "1754f0ae-6be9-4a8a-9087-fa41824fd999",
      "name": "设置Apify令牌",
      "type": "n8n-nodes-base.set",
      "position": [
        1200,
        96
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "69e8dbff-d9f3-446a-9dbd-2d4f2829cf1e",
              "name": "apifyAPIKey",
              "type": "string",
              "value": ""
            },
            {
              "id": "ab06d038-d0f2-43c0-b17e-c38c80817aae",
              "name": "apifyActorID",
              "type": "string",
              "value": ""
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "93c3718a-df70-4dc2-ad86-5db621f0984c",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1840,
        -96
      ],
      "parameters": {
        "color": 2,
        "width": 672,
        "height": 400,
        "content": "## 生成个性化开场白"
      },
      "typeVersion": 1
    },
    {
      "id": "713a09f1-b3a2-42fa-9bfd-8dd11ca4a01b",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1840,
        448
      ],
      "parameters": {
        "color": 2,
        "width": 672,
        "height": 400,
        "content": "## 附加和更新Google Sheet"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Aggregate": {
      "main": [
        [
          {
            "node": "Simplify Fields for AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "hasEmail?": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Set Apify Tokens",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Apify Tokens": {
      "main": [
        [
          {
            "node": "Call Apify LinkedIn API",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Call Apify LinkedIn API": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Un-enriched List": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Raw Un-enriched Leads": {
      "main": [
        [
          {
            "node": "hasEmail?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append Enriched Icebreaker": {
      "main": [
        [
          {
            "node": "Update Un-enriched List",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Simplify Fields for AI Agent": {
      "main": [
        [
          {
            "node": "Generate Personalized Icebreaker",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Personalized Icebreaker": {
      "main": [
        [
          {
            "node": "Append Enriched Icebreaker",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get Raw Un-enriched Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 潜在客户开发, 多模态 AI

需要付费吗?

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

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

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

作者
Erfan Mostafiz

Erfan Mostafiz

@erfanmostafiz

n8n AI automation builder focused on practical, high-impact workflows that save time and close deals. I specialize in workflows that include cold outreach, lead enrichment, and marketing ops using tools like n8n, OpenAI, Apify, and Google Sheets. Everything I publish is built for speed, clarity, and real-world use.

外部链接
在 n8n.io 查看

分享此工作流