使用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 导入」,粘贴配置后根据需要修改凭证设置即可。

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

这是一个高级难度的工作流,适用于Lead Generation、Multimodal AI等场景。适合高级用户,包含 16+ 个节点的复杂工作流

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 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 上查看 →

分享此工作流