8
n8n 中文网amn8n.com

冷邮件生成

高级

这是一个自动化工作流,包含 24 个节点。主要使用 If, Wait, Gmail, Limit, EmailSend 等节点。 使用Apollo、Apify和GPT自动化B2B潜在客户开发与个性化冷邮件

前置要求
  • Google 账号和 Gmail API 凭证
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key

分类

-
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "HaeyHJ55hJdqFWXF",
  "meta": {
    "instanceId": "81fbc47f2c7361dad100f5803eda7f24983f8844d7b7d1688ed0eec2a021756c"
  },
  "name": "冷邮件生成",
  "tags": [],
  "nodes": [
    {
      "id": "4b4b6802-06d6-48b9-8a28-1b6d2d05de78",
      "name": "添加到 Google 表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1600,
        528
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $json.output.email }}",
            "Title": "={{ $json.output.title }}",
            "PRASER": "={{ $('Parse Lead Data').item.json.output }}",
            "Full Name": "={{ $json.output.fullName }}",
            "AI Summary": "={{ $json.output.summary }}",
            "Company Name": "={{ $json.output.companyName }}",
            "Company Website": "={{ $json.output.companyWebsite }}",
            "Company LinkedIn": "={{ $json.output.companyLinkedIn }}",
            "Personal LinkedIn": "={{ $json.output.LinkedIn }}"
          },
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Personal LinkedIn",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Personal LinkedIn",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company Website",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company LinkedIn",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company LinkedIn",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "AI Summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "AI Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Mail",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Mail",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Wysłany?",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Wysłany?",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PRASER",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PRASER",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "MAIL",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "MAIL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Full Name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 595949380,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fbk-IZwfXj9kmQR98VhSBiFek6_fVSg10_W0IkGIvhA/edit#gid=595949380",
          "cachedResultName": "doradcy"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1fbk-IZwfXj9kmQR98VhSBiFek6_fVSg10_W0IkGIvhA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fbk-IZwfXj9kmQR98VhSBiFek6_fVSg10_W0IkGIvhA/edit?usp=drivesdk",
          "cachedResultName": "apollo"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "f4By4zSkpxEHAFsW",
          "name": "ccu"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "e65236a6-d58e-4370-9270-8d16cac6c3fb",
      "name": "表单提交时",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        800,
        96
      ],
      "webhookId": "ba6e9c2d-ed5d-45f0-98c9-9a1c39496dd6",
      "parameters": {
        "options": {},
        "formTitle": "Apollo + Apify Lead Generation",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Job Title",
              "placeholder": "Founder, Engineer, Owner"
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Company Size",
              "fieldOptions": {
                "values": [
                  {
                    "option": "1-10"
                  },
                  {
                    "option": "11-50"
                  },
                  {
                    "option": "51-200"
                  },
                  {
                    "option": "201-1000"
                  },
                  {
                    "option": "10001-5000"
                  },
                  {
                    "option": "5001-10000"
                  },
                  {
                    "option": "10001-100000"
                  }
                ]
              }
            },
            {
              "fieldLabel": "Keywords",
              "placeholder": "Keywords relevant to the contact or company"
            },
            {
              "fieldLabel": "Location",
              "placeholder": "United States, California, London"
            }
          ]
        },
        "formDescription": "Describe the types of leads you are trying to find."
      },
      "typeVersion": 2.2
    },
    {
      "id": "06b9b08c-c859-4825-813b-d4d03e068a0a",
      "name": "Apollo URL 生成器",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1008,
        96
      ],
      "parameters": {
        "text": "=Job Title: {{ $json['Job Title'] }}\n\nCompany Size: {{ $json['Company Size'] }}\n\nKeywords: {{ $json.Keywords }}\n\nLocation: {{ $json.Location }}\n\n\n",
        "batching": {},
        "messages": {
          "messageValues": [
            {
              "message": "=You are an expert Apollo search URL generator.\n\nYour task is to take key-value data from a form submission and turn it into a precise Apollo Search URL. You will only receive input for the fields listed below.\n\nSupported Search Fields\nYou only support the following four fields from the form input:\n\npersonLocation: The location of the person. Maps to the personLocations[] parameter.\njobTitle: The person's job title. Maps to the personTitles[] parameter.\ncompanySize: The employee range of the company. Maps to the organizationNumEmployeesRanges[] parameter.\nkeywords: Specific keyword tags for the organization. Maps to the qOrganizationKeywordTags[] parameter.\nDo not add or infer any other fields or parameters.\n\nURL Template\nUse the following URL template:\n\n\nhttps://app.apollo.io/#/people?{field1}={value1}&{field2}={value2}&...\n\n\n\n\nExample:\n\nInput\npersonLocation: New York\njobTitle: VP of Engineering\ncompanySize: 51-200\nkeywords: Healthcare AI\n\n\nOutput\n\nhttps://app.apollo.io/#/people?personLocations[]=New%20York&personTitles[]=VP%20of%20Engineering&organizationNumEmployeesRanges[]=51%2C200&qOrganizationKeywordTags[]=Healthcare%20AI"
            }
          ]
        },
        "promptType": "define"
      },
      "typeVersion": 1.7
    },
    {
      "id": "1c966679-8a61-43da-a277-233a7aaa06f2",
      "name": "运行 Apify",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1296,
        96
      ],
      "parameters": {
        "url": "https://api.apify.com/v2/acts/pipelinelabs~lead-scraper-apollo-zoominfo-lusha/run-sync-get-dataset-items?token=apify_api_YOUR_TOKEN_HERE",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n    \"companyCountry\": [\n        \"Poland\"\n    ],\n    \"companyEmployeeSize\": [\n        \"2 - 10\",\n        \"11 - 50\"\n    ],\n    \"companyIndustry\": [\n        \"Financial Services\"\n    ],\n    \"hasEmail\": true,\n    \"hasPhone\": false,\n    \"personCountry\": [\n        \"Poland\"\n    ],\n    \"seniority\": [\n        \"Owner\"\n    ]\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpBearerAuth",
        "headerParameters": {
          "parameters": [
            {
              "name": "Accept",
              "value": "application/json"
            },
            {
              "name": "Authorization",
              "value": "Bearer "
            }
          ]
        }
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "60i8DkYR1DqARkuQ",
          "name": "Bearer YOUR_TOKEN_HERE account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "c755b5ac-926b-446d-9ec0-52b6dcb113eb",
      "name": "限制",
      "type": "n8n-nodes-base.limit",
      "position": [
        576,
        512
      ],
      "parameters": {
        "maxItems": 5
      },
      "typeVersion": 1
    },
    {
      "id": "a2911e3b-332e-47f2-8e09-623156872a8c",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        912,
        656
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"fullName\": \"Stefan Chira\",\n  \"email\": \"stefan@quantumturf.com\",\n  \"title\": \"Founder\",\n  \"LinkedIn\": \"http://www.linkedin.com/in/stefanchira\",\n  \"companyName\": \"Quantum Turf\",\n  \"companyWebsite\": \"http://www.quantumturf.com\",\n  \"companyLinkedIn\": \"http://www.linkedin.com/company/quantumturf\",\n  \"summary\": \"Stefan Chira is the Founder of Quantum Turf...\"\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "a2bd2bb6-7c58-473c-940f-b021a6df99bf",
      "name": "解析潜在客户数据",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        752,
        512
      ],
      "parameters": {
        "text": "=Name: {{ $json.name }}\n\nTitle: {{ $json.title }}\n\nEmail: {{ $json.email }}\n\nLinkedIn: {{ $json.linkedin_url }}\n\nOrg Name: {{ $json.organization_name }}\n\nOrg Website: {{ $json.organization_website_url }}\n\nOrg LinkedIn: {{ $json.organization_linkedin_url }}\n\n\n\n",
        "batching": {},
        "messages": {
          "messageValues": [
            {
              "message": "=You are a sophisticated AI data-processing engine. Your task is to receive a raw JSON object for a single business prospect, perform two critical actions, and then provide your response in a specific JSON format.\n\n**Your Instructions:**\n\n1.  **EXTRACT KEY DATA:** You must parse the raw JSON input to find and extract the following specific data points. If a field is not present, use a value of `BRAK`.\n    * **Full Name:** Look for `first_name` and `last_name`.\n    * **Email:** Find the first available email address. Look in fields like `emails` or `personal_emails` .\n    * **LinkedIn** Look for the 'linkedin_url'\n    * **Title:** Look for the `title` field.\n    * **Company Name:** Look for the `organization_name` field.\n    * **Company Website:** Look for the `organization_website` field.\n    * **Company LinkedIn:** Combine `organization_linkedin.\n\n2.  **SYNTHESIZE A SUMMARY:** After extracting the data, write a concise, 2-3 sentence professional summary suitable for a sales team.\n\n3.  **FORMAT THE OUTPUT:** You MUST structure your entire response as a single, clean JSON object. The object should contain exactly the keys listed below. Do not include any other text, explanations, or greetings in your response—ONLY the final JSON object.\n\n**Required Output Format:**\n{\n  \"fullName\": \"...\",\n  \"email\": \"...\",\n  \"title\": \"...\",\n  \"LinkedIn\"\n  \"companyName\": \"...\",\n  \"companyWebsite\": \"...\",\n  \"companyLinkedIn\": \"...\",\n  \"summary\": \"...\"\n}"
            }
          ]
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.7
    },
    {
      "id": "820ce9cc-edfb-4ca4-953f-e225f2e4975e",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        -64
      ],
      "parameters": {
        "color": 5,
        "width": 500,
        "height": 800,
        "content": "BY MIRAI"
      },
      "typeVersion": 1
    },
    {
      "id": "023da3f8-2872-4c8a-97cc-ead84c741d92",
      "name": "条件判断",
      "type": "n8n-nodes-base.if",
      "position": [
        1024,
        512
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "0c3299a2-95c2-472e-b4b1-023d935dd2d9",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.output.email }}",
              "rightValue": "BRAK"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "6732b35a-7d00-431b-b959-ee1b9ce05ed0",
      "name": "遍历项目1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2304,
        528
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "4231bbd5-78da-41a6-b07b-14c7f56d08f8",
      "name": "等待",
      "type": "n8n-nodes-base.wait",
      "position": [
        2672,
        720
      ],
      "webhookId": "1141ae77-a350-4d6d-b4c1-6e20910f5c89",
      "parameters": {
        "unit": "minutes",
        "amount": 10
      },
      "typeVersion": 1.1
    },
    {
      "id": "42268bfc-af7b-4fe5-bef6-18e2bcf8a28d",
      "name": "无操作,不执行任何操作",
      "type": "n8n-nodes-base.noOp",
      "position": [
        2736,
        368
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f098ad71-fb9e-4afc-8aef-7c6f030d8de0",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        -192
      ],
      "parameters": {
        "width": 864,
        "height": 464,
        "content": "## 开始"
      },
      "typeVersion": 1
    },
    {
      "id": "6e6b16c4-744d-492d-820f-dd9c7fe0dfb9",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        320
      ],
      "parameters": {
        "width": 928,
        "height": 384,
        "content": "## 解析潜在客户数据"
      },
      "typeVersion": 1
    },
    {
      "id": "9c96c62a-7a96-4967-a991-4f145317a422",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1536,
        96
      ],
      "parameters": {
        "color": 5,
        "width": 228,
        "height": 608,
        "content": "## 排序"
      },
      "typeVersion": 1
    },
    {
      "id": "646d5457-ee42-4b79-8f72-68de028cae81",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1856,
        304
      ],
      "parameters": {
        "color": 5,
        "width": 228,
        "height": 384,
        "content": "## 电子邮件魔法"
      },
      "typeVersion": 1
    },
    {
      "id": "0452b6ac-e352-4066-b465-2839adce0803",
      "name": "便利贴5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2192,
        -112
      ],
      "parameters": {
        "width": 864,
        "height": 1056,
        "content": "## 发送电子邮件"
      },
      "typeVersion": 1
    },
    {
      "id": "2754efe3-96c1-43b6-b6c2-8b36a2582b12",
      "name": "工作结束确认消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2528,
        368
      ],
      "webhookId": "46e5a229-f43c-4494-8de2-789806ca7bc2",
      "parameters": {
        "message": "All emails send",
        "options": {},
        "subject": "WORK DONE"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "V1fKvLRJh7V1DfwB",
          "name": "Gmail account 2"
        }
      },
      "executeOnce": true,
      "typeVersion": 2.1
    },
    {
      "id": "3a3080f4-cac6-4f36-b3d6-0ecfa0f9fadc",
      "name": "发送冷邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2512,
        560
      ],
      "webhookId": "0c4969af-fcd7-4bd0-b07c-6461b57111ed",
      "parameters": {
        "text": "={{ $json.message.content }}",
        "options": {},
        "subject": "Nowe leady",
        "toEmail": "kontakt@miraiautomation.xyz",
        "fromEmail": "={{ $('Add to Google Sheet').item.json.Email }}",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "vc0fQqyoJySlvmvL",
          "name": "SMTP account 2"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "dd5e530f-c93d-403d-adaa-27f7f8472d8a",
      "name": "发送冷邮件 Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2688,
        560
      ],
      "webhookId": "00085c8a-134d-4e0b-ab03-0584bc6ac749",
      "parameters": {
        "sendTo": "={{ $('Add to Google Sheet').item.json.Email }}",
        "message": "={{ $json.message.content }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "Brzmi znajomo?",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "V1fKvLRJh7V1DfwB",
          "name": "Gmail account 2"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "1fae88ea-4338-43b8-8c1a-fe02bfba8809",
      "name": "创建电子邮件",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1856,
        528
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-5",
          "cachedResultName": "GPT-5"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Użwyając tych danych  {{ $('Parse Lead Data').item.json.output }}\nPrzerób ponizszą wiadomośc w taki spsób aby brzmiała jak przygotowane specjalnie dla tej osoby\n\nWzór maila:\n\nHej {{ $json['Full Name'] }},\n\nczy w {{ $json['Company Name'] }} cold mailing działa tak, jakbyś chciał?\nPytam, bo stworzyliśmy system, który sam generuje leady i follow-upy —\na zespół dostaje tylko gotowe rozmowy.\n\nBrzmi jak coś, co mogłoby się sprawdzić w {{ $json['Company Name'] }}?\n\nNie zmieniaj sensu, struktury i języka maila podmień tylko dane które otrzymałeś nic więcej,\n\nOdpowiadaj tylko gotowym mailem, nie dodawaj nic więcej"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "cRv8DoMwA95Md5fb",
          "name": "OpenAi account 3"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "415b1cb5-11da-44cf-b882-20dcb630df59",
      "name": "无电子邮件的潜在客户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1600,
        384
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $json.output.email }}",
            "Title": "={{ $json.output.title }}",
            "Full Name": "={{ $json.output.fullName }}",
            "AI Summary": "={{ $json.output.summary }}",
            "Company Name": "={{ $json.output.companyName }}",
            "Company Website": "={{ $json.output.companyWebsite }}",
            "Company LinkedIn": "={{ $json.output.companyLinkedIn }}",
            "Personal LinkedIn": "={{ $json.output.LinkedIn }}"
          },
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Personal LinkedIn",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Personal LinkedIn",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company Website",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company LinkedIn",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company LinkedIn",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "AI Summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "AI Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Mail",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Mail",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Wysłany?",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Wysłany?",
              "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": [
            "Full Name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 595949380,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fbk-IZwfXj9kmQR98VhSBiFek6_fVSg10_W0IkGIvhA/edit#gid=595949380",
          "cachedResultName": "doradcy"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1fbk-IZwfXj9kmQR98VhSBiFek6_fVSg10_W0IkGIvhA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fbk-IZwfXj9kmQR98VhSBiFek6_fVSg10_W0IkGIvhA/edit?usp=drivesdk",
          "cachedResultName": "apollo"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "f4By4zSkpxEHAFsW",
          "name": "ccu"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "bce0c041-9054-40d8-bd2e-cda784590888",
      "name": "解析数据模块",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        688,
        656
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini",
          "cachedResultName": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "sp1N9oDRVcWik32U",
          "name": "rifff"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ce63c6f3-b62f-45aa-b8ec-3cbb86c11390",
      "name": "链接解析器",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        928,
        192
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-5",
          "cachedResultName": "gpt-5"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "cRv8DoMwA95Md5fb",
          "name": "OpenAi account 3"
        }
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "4a0d08e6-0d1c-4b52-b14d-5b777fbcc6db",
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Leads without email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Add to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "Parse Lead Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Apify": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LINK PASER": {
      "ai_languageModel": [
        [
          {
            "node": "Apollo URL Generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Parse Lead Data": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Creating a email": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items1": {
      "main": [
        [
          {
            "node": "message confirming end of work",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sending cold email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Data module": {
      "ai_languageModel": [
        [
          {
            "node": "Parse Lead Data",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Apollo URL Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sending cold email": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add to Google Sheet": {
      "main": [
        [
          {
            "node": "Creating a email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apollo URL Generator": {
      "main": [
        [
          {
            "node": "Run Apify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Parse Lead Data",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "message confirming end of work": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级

需要付费吗?

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

工作流信息
难度等级
高级
节点数量24
分类-
节点类型15
难度说明

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

作者
Mirai

Mirai

@mirai

At MIRAI, we believe that time is the true luxury. Thanks to AI automation, we free up time for you and your business. Our technologies work continuously.

外部链接
在 n8n.io 查看

分享此工作流