n8n 自动生成研究型冷邮件破冰语

输入：产品简介 + 目标职位/地区 → 爬取目标网站 → GPT 摘要 → 生成个性化多段破冰邮件 → 输出：Google Sheets 行数据

给谁

SDR、增长人员、代运营机构，需要批量发送高回复率冷邮件

你会得到

自动爬取潜在客户网站，生成引用网站细节的多段个性化破冰邮件，并写入 Google Sheets 供审核或接入外发系统

你需要

n8n · google-sheets

步骤

1. 配置表单触发器与凭证

   在 n8n 中导入模板后，先配置 Details（表单触发器）节点：填写 Outreach 表单标题，确认 6 个字段（About your Product、Designation、Location、Keywords、Your Name、Product URL）的必填状态。然后进入 Credentials 配置 OpenAI API key、Google Sheets OAuth2、以及 Apify API token（或你自用的线索源凭证）。

2. 提交表单并获取线索

   通过表单提交你的产品描述、目标职位、地区等信息。工作流自动调用 Leads Scraper1（HTTP Request 节点，默认请求 Apify act）获取潜在联系人列表。随后 Only Websites & Emails1（Filter 节点）过滤掉缺少 website 或 email 的行，仅保留有效线索进入下游。

3. 爬取网站并提取页面

   Scrape Home1 节点抓取每个线索的公司官网首页；HTML1 节点提取页面中的所有 <a> 链接。Edit Fields1（Set 节点）整理字段，将 company_website、email、first_name、last_name、headline、location、phone_number 等标准化。Loop Over Items1 将线索分批处理。

4. 过滤链接、去重并转为 Markdown

   Split Out1 将链接数组拆分为单行；Filter1 保留以 / 开头的相对路径链接；Code1 节点执行 JavaScript 归一化链接（处理相对路径、绝对 URL 转 pathname、去除末尾斜杠）。Remove Duplicate URLs1 去重后，Limit1 默认限制为 3 条链接。Request web page for URL1 抓取每个链接页面，Markdown1 将 HTML 转为 Markdown 供 GPT 处理。

   运行提示词 · 来源原文。Code1 节点（链接归一化）的 JS Code 字段

   复制提示词

   const items = $input.all();
   
   const updatedItems = items.map((item) => {
     const link = item?.json?.links;
   
     if (typeof link === "string") {
       // Case: starts with "/" → already relative
       if (link.startsWith("/")) {
         item.json.links = link;
       } 
       
       // Case: absolute URL (http or https)
       else if (link.startsWith("http://") || link.startsWith("https://")) {
         try {
           const url = new URL(link);
           let path = url.pathname;
   
           // Strip trailing slash unless root "/"
           if (path !== "/" && path.endsWith("/")) {
             path = path.slice(0, -1);
           }
   
           item.json.links = path || "/";
         } catch (e) {
           // On parse error, keep original
           item.json.links = link;
         }
       }
   
       // Fallback: not relative or absolute, leave as-is
       else {
         item.json.links = link;
       }
     }
   
     return item;
   });
   
   return updatedItems;

5. GPT 摘要每个页面

   Summarize Website Page1（OpenAI 节点，模型 gpt-4.1）接收 Markdown 页面内容，输出两段式摘要。system 角色设定为网站爬取助手，user 提示词要求以 JSON 格式返回 {"abstract":"..."}，语气简洁直接。

   运行提示词 · 来源原文。Summarize Website Page1 节点的 system message

   复制提示词

   You're a helpful, intelligent website scraping assistant.

   运行提示词 · 来源原文。Summarize Website Page1 节点的 user message（摘要指令）

   复制提示词

   You're provided a Markdown scrape of a website page. Your task is to provide a two-paragraph abstract of what this page is about.
   
   Return in this JSON format:
   
   {"abstract":"your abstract goes here"}
   
   Rules:
   - Your extract should be comprehensive—similar level of detail as an abstract to a published paper.
   - Use a straightforward, spartan tone of voice.
   - If it's empty, just say "no content".

   运行提示词 · 来源原文。Summarize Website Page1 节点的 user message（动态输入变量）

   复制提示词

   ={{ $json.data }}

6. 聚合摘要并生成破冰邮件

   Aggregate1 节点将所有页面的 message.content.abstract 聚合为数组。Generate Multiline Icebreaker1（OpenAI 节点，模型 gpt-4.1，temperature=0.5）读取聚合后的摘要、线索个人信息和产品描述，生成 JSON 格式的完整冷邮件（含主题和正文）。system 角色为销售助手，user 提示词包含邮件模板结构、语气规则，以及一个完整的 few-shot 示例（Maki Agency 案例）。

   运行提示词 · 来源原文。Generate Multiline Icebreaker1 节点的 system message

   复制提示词

   You're a helpful, intelligent sales assistant.

   运行提示词 · 来源原文。Generate Multiline Icebreaker1 节点的 user message（邮件生成指令，含模板与规则）

   复制提示词

   =We just scraped a series of web pages for a business called {companyName}. Your task is to take their summaries and turn them into personalized full cold email bodies that feel researched and tailored.
   
   You’ll return each email in the following format:
   
   {
     "email": "Subject: A quick idea for {companyShort}\n\nHi {name},\n\nI spent some time on {companyShort}’s site and noticed {specificThing}. It’s a small detail, but it shows how much you care about {valueTheyCareAbout}, which not everyone in {industry/space} prioritizes. I also saw the focus on {secondThing}, which signals a bigger strategy around {insight}.\n\nThe reason I’m reaching out: we built {productDescription}, a lightweight but powerful tool that costs just a few cents per run, scales easily, and consistently drives high conversion rates. A few things that set it apart:\n- {featureOne}\n- {featureTwo}\n- {featureThree}\n\nIf you’d like a closer look, I’ve shared a link here: {{ $('Details').item.json['Product URL'] }}. My sense is that {companyShort} values {someImpliedBeliefTheyHave}, and this tool aligns directly with that. Would you be open to a short conversation to see if it could fit into what you’re already running?\n\nBest regards,\n{{ $('Details').item.json['Your Name'] }}"
   }
   
   
   
   Rules:
   
   Keep the tone professional, concise, and credible—avoid fluff.
   
   Expand on the product by mentioning cost efficiency, conversion performance, ease of use, and flexibility.
   
   Shorten long company names and locations (e.g., “Love AMS” instead of “AMS Professional Services,” “San Fran” instead of “San Francisco”).
   
   Focus on non-obvious details from the company summaries—small but meaningful things that imply real research.
   
   Avoid generic praise like “Great website” or “Love your marketing.”
   
   The output should always follow the JSON format provided.

   运行提示词 · 来源原文。Generate Multiline Icebreaker1 节点的 user message（few-shot 示例输入：Maki Agency 摘要）

   复制提示词

   =Profile: Aina Rakotoarinaly, CEO founder - Maki Agency / Ti'bouffe, Maki agency, outsourcing/offshoring, Antananarivo, Madagascar
   
   Website: 
   
   This webpage presents Maki Agency, a professional digital outsourcing company based in Madagascar that specializes in tailored web development, integration, design, SEO, content creation, community management, and more. The agency offers a range of white-label and dedicated resource solutions, targeting businesses that wish to outsource various digital projects. Maki Agency emphasizes its team's versatile technical expertise across major web technologies, including CSS, HTML, JQuery, WordPress, PHP, WooCommerce, Laravel, and Odoo. The company positions itself as an ideal partner for comprehensive digital support, ensuring that client's digital and branding needs are met through experienced personnel and rigorous project management.\n\nThe website details the specific services provided, such as graphic and web design (logos, banners, retouching), web integration (landing pages, newsletters, site layouts), development (showcase sites, e-commerce, intranets, bespoke applications, maintenance), content writing (SEO-optimized texts, articles, product sheets, social media posts), search engine optimization (audits, optimizations, submissions), and social media management. The agency highlights its strengths in quality of work, experience, and discretion, especially in white-label arrangements. Visitors are encouraged to contact Maki Agency for new or existing projects, and convenient contact options (phone, QR codes, social media, chat) are provided for initiating discussions.
   
   This page presents Maki Agency, a Madagascar-based digital agency specializing in web outsourcing and subcontracting services. The agency emphasizes its experience and dedicated team capable of handling diverse digital tasks such as web development, design, SEO, content writing, integration, community management, and maintenance. Maki Agency offers both white-label and dedicated resource solutions for clients seeking to externalize parts of their workflow to a specialized offshore partner. The descriptions highlight the agency's proficiency in popular web technologies, frameworks, and CMS platforms (such as HTML, CSS, PHP, WordPress, Laravel, WooCommerce, and Odoo), as well as its ability to execute projects ranging from landing pages, e-commerce platforms, and intranets to detailed graphic design and content creation.\n\nThe site underscores Maki Agency's core values and competitive advantages, such as meticulous attention to detail, experienced professionals, creativity, discretion, and a client-focused approach. It provides detailed breakdowns of service offerings, ranging from graphic materials (logos, flyers, banners), technical integration, app and website development, staff outsourcing (developers, designers, writers), SEO strategies, community management, and digital content production. Contact details and multiple avenues for communication (phone, WhatsApp, Skype, QR codes) are prominently featured, along with encouragements for clients to reach out for consultations or ongoing projects requiring outsourcing. The agency also highlights its longevity and adaptability in the digital sector, supporting clients across various industries and digital competencies

   运行提示词 · 来源原文。Generate Multiline Icebreaker1 节点的 assistant message（few-shot 示例输出）

   复制提示词

   {"icebreaker":"Hey Aina,\n\nLove what you're doing at Maki. Also doing some outsourcing right now, wanted to run something by you.\n\nSo I hope you'll forgive me, but I creeped you/Maki quite a bit. I know that discretion is important to you guys (or at least I'm assuming this given the part on your website about white-labelling your services) and I put something together a few months ago that I think could help. To make a long story short, it's an outreach system that uses AI to find people hiring website devs. Then pitches them with templates (actually makes them a white-labelled demo website). Costs just a few cents to run, very high converting, and I think it's in line with Maki's emphasis on scalability."}

   运行提示词 · 来源原文。Generate Multiline Icebreaker1 节点的 user message（运行时动态变量）

   复制提示词

   =Profile: {{ $('Loop Over Items1').item.json.first_name }} {{ $('Loop Over Items1').item.json.last_name }} {{ $('Loop Over Items1').item.json.headline }}
   
   Website: {{ $json.abstract.join("/n") }}
   
   Product Description: {{ $('Details').item.json["About your Product"] }}

7. 写入 Google Sheets

   Add Row1（Google Sheets 节点，operation=append）将最终 outreach 内容和线索元数据追加到指定表格。映射 8 列：first_name、last_name、designation、email、website_url、location、phone_number、Outreach Content。需提前创建表格并授权凭证。

你是一个 n8n 工作流搭建助手。用户想要复现「Deep Multiline Icebreaker」模板：通过表单输入产品信息，自动爬取潜在客户网站并用 GPT-4.1 生成个性化冷邮件破冰语，最终写入 Google Sheets。请先确认用户已具备以下前提：1）n8n 实例；2）OpenAI API key；3）Google Sheets OAuth 写权限；4）Apify API token 或替代线索源。然后引导用户从 n8n 模板库导入 workflow ID 13282，按步骤配置凭证、表单字段、Google Sheets 文档 ID 和 sheet 名称，并建议先用 Limit1=1 做小规模测试。