8
n8n 中文网amn8n.com

我的工作流2

高级

这是一个Market Research, AI Summarization领域的自动化工作流，包含 17 个节点。主要使用 Code, Filter, EmailSend, GoogleSheets, ScheduleTrigger 等节点。 使用ScrapeGraphAI和Google Sheets发现和分析SEO反向链接

前置要求
  • •Google Sheets API 凭证

使用的节点 (17)

Code
Filter
EmailSend
StickyNote
GoogleSheets
ScheduleTrigger
ScrapegraphAi

分类

市场调研
AI 摘要总结
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "VhEwspDqzu7ssFVE",
  "meta": {
    "instanceId": "f4b0efaa33080e7774e0d9285c40c7abcd2c6f7cf1a8b901fa7106170dd4cda3",
    "templateCredsSetupCompleted": true
  },
  "name": "我的工作流 2",
  "tags": [
    {
      "id": "DxXGubfBzRKh6L8T",
      "name": "Revenue Optimization",
      "createdAt": "2025-07-25T16:24:30.370Z",
      "updatedAt": "2025-07-25T16:24:30.370Z"
    },
    {
      "id": "IxkcJ2IpYIxivoHV",
      "name": "Content Strategy",
      "createdAt": "2025-07-25T12:57:37.677Z",
      "updatedAt": "2025-07-25T12:57:37.677Z"
    },
    {
      "id": "PAKIJ2Mm9EvRcR3u",
      "name": "Trend Monitoring",
      "createdAt": "2025-07-25T12:57:37.670Z",
      "updatedAt": "2025-07-25T12:57:37.670Z"
    },
    {
      "id": "YtfXmaZk44MYedPO",
      "name": "Dynamic Pricing",
      "createdAt": "2025-07-25T16:24:30.369Z",
      "updatedAt": "2025-07-25T16:24:30.369Z"
    },
    {
      "id": "wJ30mjhtrposO8Qt",
      "name": "Simple RAG",
      "createdAt": "2025-07-28T12:55:14.424Z",
      "updatedAt": "2025-07-28T12:55:14.424Z"
    }
  ],
  "nodes": [
    {
      "id": "c445da82-03ca-455c-b70f-f452f325e41a",
      "name": "周计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        608,
        720
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "weeks"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "64aa43a5-ae6c-434c-bc4d-4e601f4269ff",
      "name": "AI驱动的竞争对手外链抓取工具",
      "type": "n8n-nodes-scrapegraphai.scrapegraphAi",
      "position": [
        1168,
        720
      ],
      "parameters": {
        "userPrompt": "Find all the backlinks pointing to competitor websites in our niche. Extract the following information for each backlink: { \"source_url\": \"https://example.com/page\", \"target_url\": \"https://competitor.com\", \"anchor_text\": \"relevant keyword\", \"domain_authority\": \"65\", \"page_title\": \"Page Title\", \"context\": \"surrounding text context\" }",
        "websiteUrl": "https://ahrefs.com/backlink-checker/"
      },
      "typeVersion": 1
    },
    {
      "id": "d663512b-bedb-47f9-ba53-5512b3a9f842",
      "name": "外链机会分析器",
      "type": "n8n-nodes-base.code",
      "notes": "Analyzes and scores\nbacklink opportunities\nbased on multiple factors",
      "position": [
        1760,
        704
      ],
      "parameters": {
        "jsCode": "// Process scraped backlink data and analyze opportunities\nconst inputData = $input.all()[0].json;\n\n// Extract backlinks array from result\nconst backlinks = inputData.result.backlinks || [];\n\n// Analyze and score each backlink opportunity\nreturn backlinks.map(link => {\n  // Calculate opportunity score based on multiple factors\n  const domainAuth = parseInt(link.domain_authority) || 0;\n  const hasRelevantAnchor = link.anchor_text && link.anchor_text.length > 0;\n  const hasContext = link.context && link.context.length > 50;\n  \n  // Scoring algorithm\n  let opportunityScore = 0;\n  opportunityScore += domainAuth * 0.4; // 40% weight on domain authority\n  opportunityScore += hasRelevantAnchor ? 20 : 0; // 20 points for anchor text\n  opportunityScore += hasContext ? 15 : 0; // 15 points for context\n  opportunityScore += Math.random() * 25; // 25 points random factor for content relevance\n  \n  return {\n    json: {\n      source_url: link.source_url,\n      target_url: link.target_url,\n      anchor_text: link.anchor_text,\n      domain_authority: link.domain_authority,\n      page_title: link.page_title,\n      context: link.context,\n      opportunity_score: Math.round(opportunityScore),\n      priority: opportunityScore > 70 ? 'High' : opportunityScore > 40 ? 'Medium' : 'Low',\n      analyzed_date: new Date().toISOString().split('T')[0]\n    }\n  };\n});"
      },
      "notesInFlow": true,
      "typeVersion": 2
    },
    {
      "id": "98b58330-7b28-489e-8ee1-9a6354926cd3",
      "name": "高优先级机会筛选器",
      "type": "n8n-nodes-base.filter",
      "position": [
        2336,
        720
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "condition-high-priority",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.priority }}",
              "rightValue": "High"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "0a609388-12e0-4721-a0b4-7e58452a5ec2",
      "name": "AI驱动的联系人信息查找器",
      "type": "n8n-nodes-scrapegraphai.scrapegraphAi",
      "position": [
        2880,
        768
      ],
      "parameters": {
        "userPrompt": "Find contact information on this website including email addresses, contact forms, social media profiles, and any team member information. Return data in this format: { \"emails\": [\"contact@example.com\", \"info@example.com\"], \"contact_forms\": [\"https://example.com/contact\"], \"social_media\": { \"twitter\": \"@handle\", \"linkedin\": \"company-page\" }, \"team_members\": [{ \"name\": \"John Doe\", \"role\": \"Content Manager\", \"email\": \"john@example.com\" }] }",
        "websiteUrl": "={{ $json.source_url }}"
      },
      "typeVersion": 1
    },
    {
      "id": "9f0b62f6-29a8-43fb-814e-efb7060108a2",
      "name": "数据合并与外联准备",
      "type": "n8n-nodes-base.code",
      "notes": "Combines opportunity data\nwith contact info and\nprepares outreach materials",
      "position": [
        3632,
        752
      ],
      "parameters": {
        "jsCode": "// Merge backlink opportunity data with contact information\nconst backlinkData = $input.first().json;\nconst contactData = $input.last().json;\n\n// Extract contact info from scraping result\nconst contacts = contactData.result || {};\n\n// Create comprehensive outreach record\nreturn [{\n  json: {\n    // Backlink opportunity data\n    source_url: backlinkData.source_url,\n    target_url: backlinkData.target_url,\n    anchor_text: backlinkData.anchor_text,\n    domain_authority: backlinkData.domain_authority,\n    page_title: backlinkData.page_title,\n    context: backlinkData.context,\n    opportunity_score: backlinkData.opportunity_score,\n    priority: backlinkData.priority,\n    analyzed_date: backlinkData.analyzed_date,\n    \n    // Contact information\n    emails: contacts.emails || [],\n    contact_forms: contacts.contact_forms || [],\n    social_media: contacts.social_media || {},\n    team_members: contacts.team_members || [],\n    \n    // Outreach status\n    outreach_status: 'pending',\n    outreach_attempts: 0,\n    last_contact_date: null,\n    notes: '',\n    \n    // Generate personalized outreach message\n    suggested_subject: `Partnership Opportunity - ${backlinkData.page_title}`,\n    outreach_message: `Hi there,\\n\\nI came across your article \"${backlinkData.page_title}\" and found it really valuable. I noticed you mentioned ${backlinkData.anchor_text} - we have some related content that your readers might find helpful.\\n\\nWould you be interested in exploring a content partnership?\\n\\nBest regards`\n  }\n}];"
      },
      "notesInFlow": true,
      "typeVersion": 2
    },
    {
      "id": "0c5f454c-9d96-4ce4-bd2d-0d170f2acac7",
      "name": "Google Sheets机会追踪器",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        4096,
        768
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "source_url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "source_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "target_url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "target_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "anchor_text",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "anchor_text",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "domain_authority",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "domain_authority",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "opportunity_score",
              "type": "number",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "opportunity_score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "priority",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "priority",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "emails",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "emails",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "outreach_status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "outreach_status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "suggested_subject",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "suggested_subject",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": []
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Backlink_Opportunities"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": ""
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "f26fdc84-c320-42a0-b8f3-f453e996d983",
      "name": "邮箱可用性筛选器",
      "type": "n8n-nodes-base.filter",
      "position": [
        3632,
        560
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "has-email-condition",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.emails.length }}",
              "rightValue": 0
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "d7c4c6ef-ccba-4fc7-8bdf-190b6b2cbd86",
      "name": "自动化外联邮件营销",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        4592,
        816
      ],
      "webhookId": "6cbbf447-4a67-4f70-96f6-45c7cf926e95",
      "parameters": {
        "options": {
          "replyTo": "",
          "attachments": "attachments",
          "allowUnauthorizedCerts": false
        },
        "subject": "={{ $json.suggested_subject }}"
      },
      "typeVersion": 2.1
    },
    {
      "id": "ff9f16cc-ea88-4116-a05e-5dbf6e373c1b",
      "name": "步骤1 - 计划触发器信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        384,
        -16
      ],
      "parameters": {
        "color": 4,
        "width": 575,
        "height": 962,
        "content": "# 步骤1：周计划触发器 ⏰"
      },
      "typeVersion": 1
    },
    {
      "id": "435ce088-f331-4196-9ae1-85848748e92a",
      "name": "步骤2 - 竞争对手抓取工具信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        -16
      ],
      "parameters": {
        "color": 4,
        "width": 575,
        "height": 962,
        "content": "# 步骤2：AI驱动的竞争对手外链抓取工具 🕷️"
      },
      "typeVersion": 1
    },
    {
      "id": "af85e14d-cb85-456e-911c-1f3da25e4005",
      "name": "步骤3 - 机会分析器信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1536,
        -16
      ],
      "parameters": {
        "color": 4,
        "width": 575,
        "height": 962,
        "content": "# 步骤3：外链机会分析器 📊"
      },
      "typeVersion": 1
    },
    {
      "id": "edcd090e-bfc2-4cb6-9af7-45d65f5e4081",
      "name": "步骤4 - 优先级筛选器信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2112,
        -16
      ],
      "parameters": {
        "color": 4,
        "width": 575,
        "height": 962,
        "content": "# 步骤4：高优先级机会筛选器 🎯"
      },
      "typeVersion": 1
    },
    {
      "id": "9bafc262-fa70-4c0b-9105-079bc1a1239b",
      "name": "步骤5 - 联系人查找器信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2688,
        -16
      ],
      "parameters": {
        "color": 4,
        "width": 575,
        "height": 962,
        "content": "# 步骤5：AI驱动的联系人信息查找器 👥"
      },
      "typeVersion": 1
    },
    {
      "id": "fdf304ce-91c4-4a0e-9f20-062af314cbc3",
      "name": "步骤6 - 数据合并器信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3264,
        -16
      ],
      "parameters": {
        "color": 4,
        "width": 575,
        "height": 962,
        "content": "# 步骤6：数据合并与外联准备 🔗"
      },
      "typeVersion": 1
    },
    {
      "id": "392eba9b-5b50-494c-9389-8c8b7ebbc2df",
      "name": "步骤7 - Sheets追踪器信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3840,
        -16
      ],
      "parameters": {
        "color": 4,
        "width": 575,
        "height": 962,
        "content": "# 步骤7：Google Sheets机会追踪器 📈"
      },
      "typeVersion": 1
    },
    {
      "id": "1650fb50-4794-411a-9644-567f39cde834",
      "name": "步骤8 - 邮件活动信息",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4416,
        -16
      ],
      "parameters": {
        "color": 4,
        "width": 575,
        "height": 962,
        "content": "# 步骤8：自动化外联邮件营销 📧"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c24b3ee0-7fae-40ea-81ea-b72b9e311e0a",
  "connections": {
    "Email Available Filter": {
      "main": [
        [
          {
            "node": "Automated Outreach Email Campaign",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly Schedule Trigger": {
      "main": [
        [
          {
            "node": "AI-Powered Competitor Backlink Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Backlink Opportunity Analyzer": {
      "main": [
        [
          {
            "node": "High Priority Opportunity Filter",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Sheets Opportunity Tracker",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "High Priority Opportunity Filter": {
      "main": [
        [
          {
            "node": "AI-Powered Contact Information Finder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data Merger and Outreach Preparation": {
      "main": [
        [
          {
            "node": "Email Available Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI-Powered Contact Information Finder": {
      "main": [
        [
          {
            "node": "Data Merger and Outreach Preparation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI-Powered Competitor Backlink Scraper": {
      "main": [
        [
          {
            "node": "Backlink Opportunity Analyzer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 市场调研, AI 摘要总结

需要付费吗？

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

相关工作流推荐

我的工作流 2
结合 AI 竞品监控和收入优化的自动化动态定价
If
Code
Merge
+8
25 节点vinci-king-01
市场调研
我的工作流程 2
AI驱动内容差距分析，使用ScrapeGraphAI和战略规划
Code
Google Sheets
Schedule Trigger
+2
18 节点vinci-king-01
市场调研
使用 ScrapegraphAI 自动抓取新闻文章并存储到 Google Sheets
使用ScrapegraphAI自动抓取新闻文章并存储到Google Sheets
Code
Google Sheets
Schedule Trigger
+2
8 节点vinci-king-01
市场调研
我的工作流程2
使用AI、Slack和Google Sheets监控社交媒体内容趋势
Code
Merge
Slack
+5
17 节点vinci-king-01
市场调研
竞品价格监控
带AI组件和警报的价格监控仪表板
If
Code
Slack
+6
15 节点vinci-king-01
市场调研
Amazon 键盘产品智能抓取与 Google Sheets 集成
使用 ScrapeGraphAI 抓取 Amazon 键盘产品到 Google Sheets
Code
Google Sheets
Schedule Trigger
+2
8 节点vinci-king-01
市场调研
工作流信息
难度等级
高级
节点数量17
分类2
节点类型7
难度说明

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

作者
vinci-king-01

vinci-king-01

@vinci-king-01
外部链接
在 n8n.io 查看 →

分享此工作流