LinkedIn 潜在客户个性化：Google Drive + Apify + AI 自动外联开场白

上传 Google Drive 表格 → 解析每行并抓取 LinkedIn 动态 → 用 LLM 生成单句个性化开场白 → 回写 Google Sheets 并发送 Telegram 摘要

给谁

销售/SDR 团队、潜在客户开发机构、增长营销人员

你会得到

为每位潜在客户自动生成一句基于其 LinkedIn 近期帖子或个人资料的冷邮件开场白，写回原表格

你需要

n8n · google-drive · google-sheets · apify · anthropic · openai · telegram

步骤

1. 连接凭证与配置触发器

   在 n8n 中连接以下凭证：Google Drive/Sheets（OAuth2）、Apify（token）、Anthropic 和/或 OpenAI（API key）、Telegram（bot token）。打开 Google Drive Trigger 节点，选择要监控的文件夹（每次上传新表格时触发）。

2. 准备表格并映射列

   确保上传的表格包含以下列：First Name、Last Name、Company Name for Emails、Person Linkedin Url、Email、Website。工作流中的 Code1 节点会将这些列映射为 firstName、lastName、company、linkedinUrl、email、website。

3. 替换占位符

   在 HTTP Request 节点（Scrape LinkedIn Profile Post、Colect LinkedIn Data）中，将 Authorization 头的值替换为 Bearer 你的实际 Apify token。在 Telegram 节点（Lead Enrichment is ready）中，将 chatId 替换为实际 Telegram Bot Chat ID。

4. 抓取 LinkedIn 并判断时效（OpenAI）

   工作流对每个联系人调用 Apify LinkedIn Profile Posts 抓取最近帖子，同时 Date & Time 节点记录当前日期。OpenAI 节点（gpt-4.1-mini）根据帖子和日期判断是否为当年发布，仅返回 true 或 false。

   运行提示词 · 来源原文。OpenAI 节点的 system message 字段

   复制提示词

   You are a LinkedIn Post Analyzer that determines if a profile has posts from the current year. Your sole purpose is to examine LinkedIn post data and determine if there are any posts from 2025.
   TASK:
   Analyze the provided LinkedIn profile post data and determine:
   
   If the profile has ANY posts
   If any posts are from the current year (2025)
   
   OUTPUT FORMAT:
   You must respond with EXACTLY ONE of these values:
   
   "true" - If there is at least one post from 2025
   "false" - If there are no posts from 2025
   
   Do not include any explanations, reasoning, or additional text - ONLY return "true" or "false" based on your analysis.

   运行提示词 · 来源原文。OpenAI 节点的 user message 字段

   复制提示词

   =Examine the following LinkedIn profile data and determine if there are any posts from the current year - 2025.
   LinkedIn Profile Data:
   
   Post: {{ $('Scrape LinkedIn Profile Post').item.json.text }}
   Date: {{ $('Scrape LinkedIn Profile Post').item.json.posted_at.date }}
   Current Date: {{ $json.currentDate }}
   
   If the data contains at least one post with a timestamp or date indicating it was posted in 2025, respond with only the word "true".
   If the profile has no posts OR all posts are from years prior to 2025, respond with only the word "false".
   Your entire response must be ONLY "true" or "false" with no additional text.

5. 分支 A：基于近期帖子生成个性化句子（Anthropic）

   若 OpenAI 返回 true，AI Agent1 节点调用 Anthropic Chat Model（claude-sonnet-4-20250514），根据最近 LinkedIn 帖子生成一句 25-30 词的自然引用句。

   运行提示词 · 来源原文。AI Agent1 节点的 user prompt 字段（text）

   复制提示词

   =I need to create a personalized outreach message for a prospect. Please use this recent LinkedIn post from their profile and generate a single personalized sentence I can use in my outreach email.
   
   LinkedIn Post:
   {{ $('Scrape LinkedIn Profile Post').item.json.text }}
   
   Context: I own an AI automation agency focused on building Lead Generation Outreach and Lead Enrichment Systems. I'm reaching out to this person because their work appears relevant to our services.
   
   Generate a single personalized sentence that references their LinkedIn activity in a natural, non-intrusive way that I can include in my outreach email.

   运行提示词 · 来源原文。AI Agent1 节点的 system message 字段（options.systemMessage）

   复制提示词

   You are a LinkedIn Post Analyzer specialized in creating personalized outreach sentences. Your purpose is to examine the most recent LinkedIn posts from a prospect's profile and generate a single, authentic engagement sentence that can be used in cold email outreach.
   
   TASK:
   1. Use the most recent LinkedIn post provided in the user prompt.
   2. From the selected post, craft ONE personalized sentence (25-30 words maximum) that:
      - References specific content from the post without appearing stalkerish
      - Creates a genuine connection based on the post's content
      - Uses conversational language that sounds natural in an email
      - Avoids generic compliments or obvious flattery
      - Maintains a professional tone while being personable
   
   IMPORTANT: Your output must ONLY contain the single personalized sentence with no labels or prefixes. Do not include "Personalized Sentence:" or any other text before your response. Do not include greetings, introductions, or closings. Focus solely on creating a natural reference to their LinkedIn post that demonstrates genuine interest in their professional perspective.
   
   The output will be inserted directly into a CRM system with no human review, so it must be ready to use without any additional formatting or labels.

6. 分支 B：基于个人资料生成个性化句子（Anthropic）

   若 OpenAI 返回 false，先调用 Apify LinkedIn Profile Scraper 获取 headline、about、experiences，再由 AI Agent_Personalization_no LN post 节点调用 Anthropic 生成一句 15-25 词的冷邮件开场白。

   运行提示词 · 来源原文。AI Agent_Personalization_no LN post 节点的 user prompt 字段（text）

   复制提示词

   =Create ONE personalized, emotional opening sentence for a cold email to {{ $json.firstName }} {{ $json.lastName }} that will compel them to read further. Focus on our Lead Generation Sales System that saves time.
   Output only the sentence, nothing else.

   运行提示词 · 来源原文。AI Agent_Personalization_no LN post 节点的 system message 字段（options.systemMessage）

   复制提示词

   =You are a sales development expert crafting personalized cold email opening lines without website data.
   
   Your task is to create ONE compelling opening sentence for a cold email that will grab attention immediately. focus on:
   
   1. Using the name of the lead: {{ $json.firstName }}
   2. Using their headline: {{ $json.headline }}
   3. Using their LInkedIN about section: {{ $json.about }}
   4. Current company: {{ $json.experiences[0].subtitle }}
   5. Addressing a universal pain point related to lead generation that resonates with their likely business challenges
   6. Creating curiosity about our Lead Generation Sales System
   7. Mentioning a specific benefit (saving time, reducing costs, increasing conversion rates)
   8. Making it conversational and emotionally engaging (15-25 words maximum)
   
   OUR PRODUCT: We offer a Lead Generation Sales System that automates prospect qualification, outreach sequences and lead enrichment after booking. Key benefits include:
   - 60% reduction in time spent on manual prospecting
   - 40% lower customer acquisition costs
   - 3x higher quality leads through AI-powered targeting
   - Elimination of repetitive sales tasks
   
   TONE GUIDELINES:
   - Confident but not aggressive
   - Curious rather than presumptive
   - Focused on their potential gains, not their current problems
   - Conversational, as if from one professional to another
   
   EXAMPLES OF EXCELLENT OPENERS:
   - "What if your sales team at [Company] could focus exclusively on closing while an automated system handles all prospecting, [First Name]?"
   - "The companies outperforming their competitors this quarter have one thing in common, [First Name]: they've eliminated manual lead generation entirely."
   - "Imagine cutting your customer acquisition costs by 40% while simultaneously improving lead quality, [First Name] - that's what our system recently did for a company similar to [Company]."
   - "While researching innovative companies in the [derived industry] space, [Company]'s approach stood out as perfectly positioned to benefit from automated lead generation."
   
   Remember: ONE sentence only. Make it compelling enough that they WANT to read the next line of the email.

7. 回写 Google Sheets 并循环处理

   Personalization 节点将 AI 输出赋值给 personalization 字段，并携带 sheetId、FileName、SheetName。Google Sheets Update with Personalization 节点按 email 列匹配，将 personalization 写回原表格。Loop Over Items1 节点逐行处理，全部完成后进入 End of Loops。

8. 发送 Telegram 完成通知

   End of Loops 节点（JavaScript Code）汇总所有行结果，拼接表格名称与链接，发送 Markdown 格式消息到 Telegram。

本模板为 n8n 工作流搭建指南。请按以下顺序操作：1）在 n8n 中导入 workflow JSON；2）连接 Google Drive/Sheets、Apify、Anthropic/OpenAI、Telegram 凭证；3）选择 Drive 监控文件夹；4）确认表格列名与模板一致；5）替换所有 HTTP 和 Telegram 节点中的占位符；6）上传测试表格并手动执行一次验证。