用 n8n 自动审计竞品 SEO 内容：Decodo 抓取 + Gemini 分析 + Google Sheets 报告

输入关键词列表与品牌身份表 → Decodo 搜索并抓取竞品正文 → Gemini 审计内容缺口 → 输出结构化 Action Plan 到 Google Sheets

给谁

有 n8n 使用经验、需要批量竞品内容审计的 SEO 或内容运营人员

你会得到

按关键词自动获取竞品排名页面，提取正文后由 AI 对比品牌身份，生成包含 Winning Factor / Content Gap / Action Plan 的结构化 JSON 并写入 Google Sheets

你需要

n8n · google-sheets

步骤

1. 配置全局参数与读取品牌数据

   在 n8n 画布中确认触发器（Manual Execution 或 Schedule Trigger）连接 Config 节点。在 Config（Set）节点设置 target_geo（如 United States）、target_locale（如 en-US）、serp_results_amount（如 10）。Config 输出连接 Brand Info 与 Data Sourcing：Brand Info 读取 Google Sheets 的 Brand Identity 标签页（单单元格，存放品牌使命、USP、目标受众）；Data Sourcing 读取 Target Keywords 标签页（单列 Target Keyword）。

2. 竞品发现与 URL 拆分

   Data Sourcing 的输出连接 Google Search（Decodo 节点）。该节点使用 Config 中的 target_geo、target_locale、serp_results_amount，对每条 Target Keyword 执行 Google 搜索。搜索结果传入 Split to Competitor URLs（Code 节点），该节点将 Decodo 返回的 organic 结果按 serp_results_amount 切片，并把每条结果拆分为独立 n8n item，字段包括 keyword、url、title、rank。

   运行提示词 · 来源原文。Split to Competitor URLs 节点的 JS Code 字段

   复制提示词

   // 1. Get configuration, keywords, and search results
   const config = $("Config").first().json;
   const allKeywords = $("Data Sourcing").all();
   const allSearchResults = $("Google Search").all();
   
   // Use the limit from Config, or default to 5 if not found
   const resultLimit = config.serp_results_amount || 10; 
   
   let finalOutput = [];
   
   // 2. Loop through every search result set
   allSearchResults.forEach((searchResult, searchIndex) => {
     
     // Get the keyword from the matching index
     const keyword = allKeywords[searchIndex].json["Target Keyword"] || "Keyword Not Found";
     
     // Navigate the deep Decodo path
     let organicResults = searchResult.json.results[0].content.results.results.organic;
   
     // 3. LIMIT THE RESULTS HERE
     // slice(0, X) takes only the first X items from the array
     const limitedResults = organicResults.slice(0, resultLimit);
   
     // 4. Map each URL (up to the limit) to its own n8n item
     limitedResults.forEach(result => {
       finalOutput.push({
         json: {
           keyword: keyword,
           url: result.url,
           title: result.title,
           rank: result.pos
         },
         // Keeps the internal n8n breadcrumb trail alive
         pairedItem: {
           item: searchIndex
         }
       });
     });
   });
   
   return finalOutput;

3. 内容抓取与清洗

   Split to Competitor URLs 的每条 item 传入 Universal Scraping（Decodo 节点），参数 url 取 item.json.url，geo 取 Config.target_geo。抓取结果传入 Extract Body（HTML 节点），operation 设为 extractHtmlContent，dataPropertyName 为 results[0].content，extractionValues 用 cssSelector: body、skipSelectors: img, link，提取正文并转为 Markdown 以减少 token 噪声。

4. AI 内容审计

   Extract Body 的输出连接 AI Content Auditor（AI Agent 节点）。该节点挂载 Google Gemini Chat Model 与 Structured Output Parser。User prompt 接收当前 item 的 keyword、url、rank 与提取后的 body；System message 定义 Senior SEO Content Strategist 角色，要求对比 Brand Info 中的品牌身份，输出严格 JSON，包含 primary_h1、word_count、top_topics、winning_factor、content_gap、action_plan。

   运行提示词 · 来源原文。AI Content Auditor 节点的 text（User Prompt）字段

   复制提示词

   =Please perform a deep SEO audit on the following competitor content for the keyword: "**{{ $('Split to Competitor URLs').item.json.keyword }}**".
   
   **Competitor URL:** {{ $('Split to Competitor URLs').item.json.url }}
   **Current Rank:** {{ $('Split to Competitor URLs').item.json.rank }}
   
   ---
   **PAGE CONTENT (MARKDOWN):**
   {{ $json.body }}
   ---
   
   Analyze the content and provide the Audit Requirements defined in your system instructions.

   运行提示词 · 来源原文。AI Content Auditor 节点的 options.systemMessage 字段

   复制提示词

   =You are a Senior SEO Content Strategist. Your mission is to perform a "Search Intent Audit" to find the delta between this competitor and our brand.
   
   ### OUR BRAND IDENTITY (THE GOLD STANDARD):
   {{ $("Brand Info").first().json['Brand Info'] }}
   
   ### INPUT CONTEXT:
   - Target Keyword: {{ $('Split to Competitor URLs').item.json.keyword }}
   - SERP Rank: {{ $('Split to Competitor URLs').item.json.rank }}
   - Content Source: Competitor Markdown extraction.
   
   ### STRATEGIC LOGIC RULES:
   1. THE GAP DEFINITION: A "Content Gap" is NOT just missing text. It is a specific angle, data point, or user-need that OUR BRAND provides (based on the Identity above) which is absent in the competitor's text.
   2. WINNING FACTOR: Identify if they are winning due to "Topical Depth" (long-form), "Technical Authority" (tools/data), or "User Experience" (skimmable headers).
   3. ACTION PLAN: This must be a "Checkmate" instruction. If they are broad, we must be specific. If they are technical, we must be accessible.
   
   ### OUTPUT SCHEMA (STRICT JSON ONLY):
   {
     "primary_h1": "String",
     "word_count": Integer,
     "top_topics": ["Topic 1", "Topic 2", "Topic 3"],
     "winning_factor": "Detailed 1-sentence analysis of their SEO moat.",
     "content_gap": "What specific 'Brand Value' from our identity is missing here?",
     "action_plan": "Specific instruction: 'Write a [Section Type] that focuses on [Brand USP] to outperform their [Competitor Section].'"
   }
   
   ### CONSTRAINTS:
   - No conversational filler. 
   - If the Markdown is empty or invalid, return "Error: No Content".
   - Ensure the 'action_plan' uses the brand voice defined in the Brand Identity.

5. 结果写入报告表

   AI Content Auditor 的输出传入 Strategy Master Writer（Google Sheets 节点），operation 设为 append，sheet 指向 Competitor Audit Feed 标签页。字段映射：Keyword、Competitor URL、Rank、Primary H1、Winning Factor、The Gap、Action Plan 均取自上游节点输出。写入完成后连接 Done（NoOp）节点结束流程。

你正在复现一个 n8n 模板：自动审计竞品 SEO 内容。请先确认你已具备以下前提：
1) 可访问的 n8n 实例；2) Google Sheets OAuth2 凭证；3) Decodo API 密钥；4) googlePalmApi 凭证（用于 Gemini 节点）。
然后按步骤检查 Config 节点参数、Google Sheet 三标签页结构、以及 AI Content Auditor 的 systemMessage 与 user prompt 是否已正确填入。建议先用 1 条关键词和 1 个 competitor 做小规模测试，确认 Structured Output Parser 能返回合法 JSON 后再批量运行。