n8n 自动 Reddit 潜客挖掘：AI 分析与 Google Sheets 整合

输入业务画像 → AI 选定子版块并生成搜索查询 → Reddit 实时搜索 → AI 分级与商机分析 → 高价值潜客写入 Google Sheets

给谁

需要在 Reddit 上寻找 B2B 潜客的服务型业务团队

你会得到

按设定周期自动扫描 Reddit 帖子，AI 筛选高意向潜客并输出到表格

你需要

n8n · google-sheets · reddit

步骤

1. 配置业务画像与触发器

   在 n8n 中导入模板后，先配置 Schedule Trigger（默认每 2 小时）。然后准备 Google Sheet「业务画像表」，首行填入必填字段：profession、industry、primary_services、service_keywords、target_client_profile、pain_points、intent_signals、urgency_indicators、price_range。在「Get Enhanced Business Profile」节点中绑定你的 Google Sheets OAuth2 凭证并指定该表格。【首次测试安全】首次运行前，将 Reddit Search Engine 的 limit 临时改为 1，或改用测试 Google Sheet，避免首跑即大量搜索并写入生产表。

2. AI 选定目标子版块

   「Strategic Subreddit Selector」节点读取业务画像后，调用 Google Gemini 分析并返回 5 个最相关的子版块。该节点已连接 Structured Output Parser，要求输出 JSON 格式包含 subreddits 数组与 reasoning。

   运行提示词 · 来源原文。Strategic Subreddit Selector 节点的 text 参数（LLM Chain 的 prompt）

   复制提示词

   =You are a Reddit lead generation strategist. Analyze the business profile and identify the 5 most relevant subreddits for lead generation.
   
   **Business Profile:**
   - Profession: {{ $json.profession }}
   - Industry: {{ $json.industry }}
   - Primary Services: {{ $json.primary_services }}
   - Service Keywords: {{ $json.service_keywords }}
   - Target Client: {{ $json['target_client_profile '] }}
   - Pain Points: {{ $json.pain_points }}
   
   **Selection Criteria:**
   1. **High Intent Communities**: Subreddits where your target clients actively seek solutions
   2. **Problem-Focused**: Communities discussing specific pain points you solve
   3. **Business Context**: Professional subreddits with decision-makers
   4. **Active Engagement**: 10K+ members with recent quality discussions
   5. **Lead-Friendly**: Communities that welcome helpful solutions (not purely promotional)
   
   **Avoid:**
   - Pure promotional subreddits
   - Overly broad communities (r/AskReddit)
   - Student/hobbyist focused groups
   - Dead or low-engagement communities
   
   Return the 5 most strategic subreddits that balance relevance, engagement, and lead potential. Include reasoning for your selections.

3. 生成搜索查询并执行 Reddit 搜索

   「Multi-Query Generator」节点基于业务画像和已选子版块，生成 3 条不同意图类型的 Reddit 搜索查询（直接服务请求、问题导向、推荐请求）。输出经 Code 节点（Python）格式转换后，由「Split Query Batches」分批送入「Reddit Search Engine」节点执行实时搜索（每查询上限 10 条，按 new 排序）。需配置 Reddit OAuth2 凭证。

   运行提示词 · 来源原文。Multi-Query Generator 节点的 text 参数

   复制提示词

   =Act as a Reddit search expert specializing in B2B lead identification.
   
   Create 3 focused search queries targeting different intent types:
   
   **Business Context:**
   - Profession:{{ $('Get Enhanced Business Profile').item.json.profession }} 
   - Primary Services: {{ $('Get Enhanced Business Profile').item.json.primary_services }}
   - Service Keywords: {{ $('Get Enhanced Business Profile').item.json.service_keywords }}
   - Target Client: {{ $('Get Enhanced Business Profile').item.json['target_client_profile '] }}
   - Pain Points: {{ $('Get Enhanced Business Profile').item.json.pain_points }}
   - Intent Signals: {{ $('Get Enhanced Business Profile').item.json.intent_signals }}
   - Urgency Indicators: {{ $('Get Enhanced Business Profile').item.json.urgency_indicators }}
   
   **Target Subreddits:** {{ $json.output.subreddits }}
   
   **Query Types to Create:**
   
   1. **Direct Service Requests** (High Intent)
      - People explicitly asking for your type of service as a {{ $('Get Enhanced Business Profile').item.json.profession }} 
      - Format: (subreddit:X OR subreddit:Y) ("looking for" OR "need" OR "hire") ("service_keyword1" OR "service_keyword2") -("I offer" OR "my service")
   
   2. **Problem-Focused** (Medium-High Intent)  
      - People describing problems you solve as a {{ $('Get Enhanced Business Profile').item.json.profession }} 
      - Format: (subreddit:X OR subreddit:Y) ("struggling with" OR "problem with") ("pain_point1" OR "pain_point2") AND ("help" OR "advice" OR "solution")
   
   3. **Recommendation Requests** (Medium Intent)
      - People asking for tool/service recommendations that a {{ $('Get Enhanced Business Profile').item.json.profession }} can help
      - Format: (subreddit:X OR subreddit:Y) ("recommend" OR "suggestions") ("service_area") -("free" OR "DIY")
   
   **Query Rules:**
   - Keep each query under 200 characters
   - Use exact pain point language from target audience
   - Include 3-5 service keywords per query
   - Exclude competitor promotional content
   - Focus on business decision-maker language
   
   Output 3 separate optimized queries with their intent levels.

4. AI 分级帖子意向

   搜索返回的帖子由「AI Lead Classifier」节点进行四级分类：HIGH_POTENTIAL、MEDIUM_POTENTIAL、LOW_POTENTIAL、NO_POTENTIAL。分类器将业务画像与帖子标题、内容、子版块、互动数据一并送入 Gemini 模型判断。

   运行提示词 · 来源原文。AI Lead Classifier 节点的 inputText 参数

   复制提示词

   =**Service Profile:**
   <profession>{{ $('Get Enhanced Business Profile').item.json.profession }}</profession>
   <primary_services>{{ $('Get Enhanced Business Profile').item.json.primary_services }}</primary_services>
   <target_client>{{ $('Get Enhanced Business Profile').item.json['target_client_profile '] }}</target_client>
   
   <pain_points>{{ $('Get Enhanced Business Profile').item.json.pain_points }}</pain_points>
   
   **Post Content:**
   <title>{{ $json.title || 'N/A' }}</title>
   <content>{{ $json.selftext || $json.text || $json.content || $json.body || 'No content' }}</content>
   <subreddit>{{ $json.subreddit_name_prefixed }}</subreddit>
   <author>{{ $json.author || 'unknown' }}</author>
   <engagement>{{ $json.score || 0 }} upvotes, {{ $json.num_comments || 0 }} comments</engagement>
   <post_age>{{ $json.created || 'unknown' }}</post_age>

5. 深度商机分析

   被标记为 HIGH_POTENTIAL 的帖子进入「Service Opportunity Analyzer」节点，由 Gemini 输出结构化分析：lead_score（1-10）、urgency_level、estimated_value、response_priority、recommended_service、outreach_approach 等。该节点连接 Service Analysis Parser 强制 JSON 输出。

   运行提示词 · 来源原文。Service Opportunity Analyzer 节点的 text 参数

   复制提示词

   You are a business development strategist analyzing Reddit posts for service opportunities.
   
   **Professional Context:**
   - Profession: {{ $('Get Enhanced Business Profile').item.json.profession }}
   - Primary Services: {{ $('Get Enhanced Business Profile').item.json.primary_services }}
   - Target Clients: {{ $('Get Enhanced Business Profile').item.json.target_client_profile }}
   - Price Range: {{ $('Get Enhanced Business Profile').item.json.price_range }}
   - Service Keywords: {{ $('Get Enhanced Business Profile').item.json.service_keywords }}
   
   **Reddit Post Analysis:**
   Title: {{ $json.title }}
   Content: {{ $json.selftext }}
   Subreddit: {{ $json.subreddit_name_prefixed }}
   Engagement: {{ $json.score }} upvotes, {{ $json.num_comments }} comments
   Classification: {{ $json.category }}
   
   **Analysis Framework:**
   1. **Problem Identification**: What specific business problem is expressed?
   2. **Service Mapping**: Which of your services directly addresses this problem?
   3. **Value Assessment**: What measurable outcome could you deliver?
   4. **Urgency Assessment**: How time-sensitive is their need?
   5. **Business Context**: Are they the right size/type of client?
   6. **Competition Analysis**: How many others are likely targeting this lead?
   
   **Scoring Criteria:**
   - Lead Score (1-10): Overall conversion probability
   - Urgency Level: immediate/high/medium/low
   - Estimated Value: Based on problem scope and your pricing
   - Response Priority: immediate/today/this_week/monitor
   
   **Output Requirements:**
   Provide a comprehensive lead analysis including specific service recommendations, outreach strategy, and business justification. Focus on actionable insights for immediate lead engagement.

6. 过滤并保存高价值潜客

   「High Value Filter」节点仅放行 lead_score ≥ 6 的结果。通过的记录由「Save High-Value Leads」节点写入 Google Sheet「Reddit Leads Sheet」，以 post_id 为匹配键执行 appendOrUpdate，避免重复。需配置输出表格的 Google Sheets OAuth2 凭证。

7. 循环处理与人工复核

   「Loop Over Items」节点遍历批次，未处理完的帖子返回继续分析。最终输出表格包含：post_id、post_url、post_title、post_post、post_subreddit、post_date、service suggestion（完整 JSON 分析）。建议销售团队在跟进前人工复核帖子上下文与联系方式。

你正在搭建一个 n8n 工作流，用于从 Reddit 自动挖掘 B2B 潜客。请先确认你已具备：自托管 n8n 实例、Google Sheets OAuth2 凭证、Reddit OAuth2 凭证、Google Gemini API 凭证。然后按步骤配置两张 Google Sheet（业务画像输入表、潜客输出表），导入 workflow.json 并替换凭证与表格 ID，最后测试单次运行。