中文网

竞争对手情报代理：SERP监控+Thordata+OpenAI的摘要洞察

高级

这是一个Market Research、AI Summarization领域的自动化工作流，包含 23 个节点。主要使用 Set、Merge、GoogleSheets、ManualTrigger、Agent 等节点。 竞争对手情报代理：SERP 监控 + Thordata + OpenAI 摘要洞察

前置要求
  • •Google Sheets API 凭证
  • •可能需要目标 API 的认证凭证
  • •OpenAI API Key

使用的节点 (23 个)

Set
Merge
StickyNote
GoogleSheets
ManualTrigger
Agent
HttpRequestTool
ChainLlm
LmChatOpenAi
InformationExtractor
OutputParserStructured

分类

Market Research
AI Summarization
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "OQEOWynAfK54HxNr",
  "meta": {
    "instanceId": "885b4fb4a6a9c2cb5621429a7b972df0d05bb724c20ac7dac7171b62f1c7ef40",
    "templateCredsSetupCompleted": true
  },
  "name": "竞争对手情报代理：SERP监控+Thordata+OpenAI的摘要洞察",
  "tags": [
    {
      "id": "Kujft2FOjmOVQAmJ",
      "name": "Engineering",
      "createdAt": "2025-04-09T01:31:00.558Z",
      "updatedAt": "2025-04-09T01:31:00.558Z"
    },
    {
      "id": "ddPkw7Hg5dZhQu2w",
      "name": "AI",
      "createdAt": "2025-04-13T05:38:08.053Z",
      "updatedAt": "2025-04-13T05:38:08.053Z"
    },
    {
      "id": "qpxJxOMCv2x7Op5c",
      "name": "SERP",
      "createdAt": "2025-04-03T15:37:19.686Z",
      "updatedAt": "2025-04-03T15:37:19.686Z"
    }
  ],
  "nodes": [
    {
      "id": "d370dfd6-2a22-4e90-816f-be5e3b84c4c4",
      "name": "AI代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -304,
        -288
      ],
      "parameters": {
        "text": "={{ $json.search_query }}",
        "options": {},
        "promptType": "define"
      },
      "retryOnFail": true,
      "typeVersion": 2.2
    },
    {
      "id": "7af03b55-ba2e-4408-80ff-b81c02286993",
      "name": "OpenAI聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -592,
        -64
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "vPKynKbDzJ5ZU4cU",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "51f08152-e6e0-428a-b914-77cf14e13283",
      "name": "必应搜索",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        -416,
        -64
      ],
      "parameters": {
        "url": "https://scraperapi.thordata.com/request",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "form-urlencoded",
        "sendHeaders": true,
        "authentication": "predefinedCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "engine",
              "value": "bing"
            },
            {
              "name": "q",
              "value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('parameters1_Value', ``, 'string') }}"
            },
            {
              "name": "json",
              "value": "1"
            }
          ]
        },
        "toolDescription": "HTTP request using Bing Search",
        "headerParameters": {
          "parameters": [
            {}
          ]
        },
        "nodeCredentialType": "httpBearerAuth"
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "m17YVh2yJY7Fl9Wx",
          "name": "Thordata SERP Bearer YOUR_TOKEN_HERE Account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "ecdb2eb4-373b-4929-b3b6-14b9063d1e91",
      "name": "谷歌搜索",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        -256,
        -64
      ],
      "parameters": {
        "url": "https://scraperapi.thordata.com/request",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "form-urlencoded",
        "sendHeaders": true,
        "authentication": "predefinedCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "engine",
              "value": "google"
            },
            {
              "name": "q",
              "value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('parameters1_Value', ``, 'string') }}"
            },
            {
              "name": "json",
              "value": "1"
            }
          ]
        },
        "toolDescription": "HTTP request using Google Search",
        "headerParameters": {
          "parameters": [
            {}
          ]
        },
        "nodeCredentialType": "httpBearerAuth"
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "m17YVh2yJY7Fl9Wx",
          "name": "Thordata SERP Bearer YOUR_TOKEN_HERE Account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "ddfeffd8-9c9a-42c4-be8d-36f2dbacb99c",
      "name": "Yandex搜索",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        -48,
        -64
      ],
      "parameters": {
        "url": "https://scraperapi.thordata.com/request",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "form-urlencoded",
        "sendHeaders": true,
        "authentication": "predefinedCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "engine",
              "value": "yandex"
            },
            {
              "name": "q",
              "value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('parameters1_Value', ``, 'string') }}"
            },
            {
              "name": "json",
              "value": "1"
            }
          ]
        },
        "toolDescription": "HTTP request using Yandex Search",
        "headerParameters": {
          "parameters": [
            {}
          ]
        },
        "nodeCredentialType": "httpBearerAuth"
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "m17YVh2yJY7Fl9Wx",
          "name": "Thordata SERP Bearer YOUR_TOKEN_HERE Account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "8fdd3ba1-7f2f-4cb5-8be7-810be5048240",
      "name": "DuckDuckGo搜索",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        144,
        -64
      ],
      "parameters": {
        "url": "https://scraperapi.thordata.com/request",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "form-urlencoded",
        "sendHeaders": true,
        "authentication": "predefinedCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "engine",
              "value": "duckduckgo"
            },
            {
              "name": "q",
              "value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('parameters1_Value', ``, 'string') }}"
            },
            {
              "name": "json",
              "value": "1"
            }
          ]
        },
        "toolDescription": "HTTP request using DuckDuckGo Search",
        "headerParameters": {
          "parameters": [
            {}
          ]
        },
        "nodeCredentialType": "httpBearerAuth"
      },
      "credentials": {
        "httpBearerAuth": {
          "id": "m17YVh2yJY7Fl9Wx",
          "name": "Thordata SERP Bearer YOUR_TOKEN_HERE Account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "d1a85744-8eb1-4a7a-9ac4-1dc11843c522",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        -1136
      ],
      "parameters": {
        "color": 7,
        "width": 160,
        "content": "![Logo](https://consumersiteimages.trustpilot.net/business-units/67b212598525b99cf90a59cc-198x149-1x.jpg)"
      },
      "typeVersion": 1
    },
    {
      "id": "884c52b5-d8a2-4c67-b2a4-ca4ccacb7677",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1072,
        -288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6a142d04-f88e-436c-8a20-4f575de756b8",
      "name": "设置输入字段",
      "type": "n8n-nodes-base.set",
      "position": [
        -784,
        -288
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "4a779b05-0cb9-4d93-883c-90b8859edbca",
              "name": "search_query",
              "type": "string",
              "value": "Google Search for Top SEO strategies for e-commerce in 2025"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "8234accd-fa05-4795-96ef-99a158e673ff",
      "name": "总结内容",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        448,
        -464
      ],
      "parameters": {
        "text": "=Summarize the following content  {{ $json.output }}.\n\nOutput just the summary. Do not provide your own suggestions or recommendations",
        "batching": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "retryOnFail": true,
      "typeVersion": 1.7
    },
    {
      "id": "fe9c7ae5-70e8-4854-8c4d-f2dee9956024",
      "name": "用于摘要的OpenAI聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        432,
        -224
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "vPKynKbDzJ5ZU4cU",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "2438f8b8-02cf-4811-a65f-7c4601f252bc",
      "name": "关键词和主题分析",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        464,
        -32
      ],
      "parameters": {
        "text": "=Perform Keyword and Topic Analysis of the following  {{ $json.output }}",
        "options": {},
        "schemaType": "manual",
        "inputSchema": "{\n  \"$schema\": \"http://json-schema.org/draft-07/schema#\",\n  \"title\": \"KeywordTopicAnalysis\",\n  \"type\": \"object\",\n  \"properties\": {\n    \"query\": {\n      \"type\": \"string\",\n      \"description\": \"The original search query or keyword used in the SERP analysis.\"\n    },\n    \"primary_keywords\": {\n      \"type\": \"array\",\n      \"description\": \"List of primary focus keywords extracted from the analyzed content or SERP data.\",\n      \"items\": { \"type\": \"string\" }\n    },\n    \"secondary_keywords\": {\n      \"type\": \"array\",\n      \"description\": \"Related or supporting keywords derived from semantic clustering or co-occurrence.\",\n      \"items\": { \"type\": \"string\" }\n    },\n    \"keyword_metrics\": {\n      \"type\": \"array\",\n      \"description\": \"SEO metrics for each keyword, including difficulty and search volume.\",\n      \"items\": {\n        \"type\": \"object\",\n        \"properties\": {\n          \"keyword\": { \"type\": \"string\" },\n          \"search_volume\": { \"type\": \"integer\" },\n          \"competition_score\": { \"type\": \"number\" },\n          \"difficulty_score\": { \"type\": \"number\" },\n          \"trend\": { \"type\": \"string\", \"enum\": [\"rising\", \"falling\", \"steady\"] }\n        },\n        \"required\": [\"keyword\"]\n      }\n    },\n    \"focus_topics\": {\n      \"type\": \"array\",\n      \"description\": \"List of main content themes or topics derived from the SERP results or web pages.\",\n      \"items\": { \"type\": \"string\" }\n    },\n    \"topic_clusters\": {\n      \"type\": \"array\",\n      \"description\": \"Groups of semantically related keywords and topics.\",\n      \"items\": {\n        \"type\": \"object\",\n        \"properties\": {\n          \"cluster_name\": { \"type\": \"string\" },\n          \"related_keywords\": { \"type\": \"array\", \"items\": { \"type\": \"string\" } },\n          \"search_intent\": {\n            \"type\": \"string\",\n            \"enum\": [\"informational\", \"navigational\", \"transactional\", \"commercial\"]\n          }\n        },\n        \"required\": [\"cluster_name\", \"related_keywords\"]\n      }\n    },\n    \"seo_strength_score\": {\n      \"type\": \"integer\",\n      \"description\": \"Overall SEO opportunity score (0–100).\"\n    },\n    \"content_gap_summary\": {\n      \"type\": \"string\",\n      \"description\": \"Summary describing missing topics or keyword opportunities in current content.\"\n    },\n    \"competitor_insights\": {\n      \"type\": \"array\",\n      \"description\": \"Optional data about competitors ranking for the analyzed keyword(s).\",\n      \"items\": {\n        \"type\": \"object\",\n        \"properties\": {\n          \"domain\": { \"type\": \"string\" },\n          \"ranking_position\": { \"type\": \"integer\" },\n          \"page_title\": { \"type\": \"string\" },\n          \"content_type\": { \"type\": \"string\" },\n          \"keyword_overlap\": { \"type\": \"number\" }\n        },\n        \"required\": [\"domain\", \"ranking_position\"]\n      }\n    },\n    \"ai_summary\": {\n      \"type\": \"string\",\n      \"description\": \"GPT-generated summary of the keyword and topic insights.\"\n    },\n    \"timestamp\": {\n      \"type\": \"string\",\n      \"format\": \"date-time\",\n      \"description\": \"Timestamp when the analysis was performed.\"\n    }\n  },\n  \"required\": [\"query\", \"primary_keywords\", \"focus_topics\", \"seo_strength_score\"]\n}\n"
      },
      "typeVersion": 1.2
    },
    {
      "id": "c4b13e07-1fa9-4d33-9140-14375f1e5c6b",
      "name": "用于关键词和主题分析的OpenAI聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        464,
        144
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "vPKynKbDzJ5ZU4cU",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "27bcba40-fa09-4561-8a79-67af2e479e16",
      "name": "SEO分析师",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        432,
        -960
      ],
      "parameters": {
        "text": "=Analyze the following SERP results for competitor insights and keyword opportunities:\\n\\n {{ $json.output }}",
        "options": {
          "systemPromptTemplate": "You are an SEO analyst. Extract primary keywords, competitor names, content tone, and summarize SEO strength from SERP data. "
        },
        "schemaType": "manual",
        "inputSchema": "{\n  \"$schema\": \"http://json-schema.org/draft-07/schema#\",\n  \"title\": \"CompetitorInsightsAndKeywordOpportunities\",\n  \"type\": \"object\",\n  \"description\": \"Structured output for analyzing SERP results to extract competitor insights, keyword opportunities, and SEO metrics.\",\n  \"properties\": {\n    \"query\": {\n      \"type\": \"string\",\n      \"description\": \"The search query or topic analyzed in the SERP.\"\n    },\n    \"analyzed_date\": {\n      \"type\": \"string\",\n      \"format\": \"date-time\",\n      \"description\": \"Timestamp when the analysis was performed.\"\n    },\n    \"competitors\": {\n      \"type\": \"array\",\n      \"description\": \"List of main competitors or domains identified in the SERP results.\",\n      \"items\": {\n        \"type\": \"object\",\n        \"properties\": {\n          \"domain\": { \"type\": \"string\", \"description\": \"Competitor domain or brand name.\" },\n          \"page_title\": { \"type\": \"string\", \"description\": \"Title of the competitor’s ranking page.\" },\n          \"ranking_position\": { \"type\": \"integer\", \"description\": \"SERP position for this result.\" },\n          \"snippet\": { \"type\": \"string\", \"description\": \"Short description or meta snippet from the SERP.\" },\n          \"content_type\": {\n            \"type\": \"string\",\n            \"enum\": [\"blog\", \"product_page\", \"landing_page\", \"news\", \"other\"],\n            \"description\": \"Type of content represented by the competitor page.\"\n          },\n          \"estimated_traffic_share\": {\n            \"type\": \"number\",\n            \"minimum\": 0,\n            \"maximum\": 100,\n            \"description\": \"Estimated share of search traffic (%) for this result.\"\n          },\n          \"keyword_overlap\": {\n            \"type\": \"number\",\n            \"minimum\": 0,\n            \"maximum\": 1,\n            \"description\": \"Proportion of shared keywords with the target domain (0–1 scale).\"\n          },\n          \"strengths\": {\n            \"type\": \"array\",\n            \"items\": { \"type\": \"string\" },\n            \"description\": \"SEO strengths or advantages identified for this competitor.\"\n          },\n          \"weaknesses\": {\n            \"type\": \"array\",\n            \"items\": { \"type\": \"string\" },\n            \"description\": \"Content or optimization weaknesses detected.\"\n          }\n        },\n        \"required\": [\"domain\", \"ranking_position\"]\n      }\n    },\n    \"keyword_opportunities\": {\n      \"type\": \"array\",\n      \"description\": \"List of new or underutilized keywords identified from the SERP analysis.\",\n      \"items\": {\n        \"type\": \"object\",\n        \"properties\": {\n          \"keyword\": { \"type\": \"string\" },\n          \"search_volume\": { \"type\": \"integer\", \"description\": \"Estimated monthly search volume.\" },\n          \"competition_score\": { \"type\": \"number\", \"description\": \"Keyword competition (0–1 scale).\" },\n          \"difficulty_score\": { \"type\": \"number\", \"description\": \"Keyword difficulty (0–100 scale).\" },\n          \"intent\": {\n            \"type\": \"string\",\n            \"enum\": [\"informational\", \"navigational\", \"transactional\", \"commercial\"],\n            \"description\": \"User search intent.\"\n          },\n          \"relevance_score\": {\n            \"type\": \"number\",\n            \"minimum\": 0,\n            \"maximum\": 1,\n            \"description\": \"Relevance to the analyzed query (0–1 scale).\"\n          }\n        },\n        \"required\": [\"keyword\"]\n      }\n    },\n    \"topic_clusters\": {\n      \"type\": \"array\",\n      \"description\": \"Clusters of semantically related topics derived from the SERP.\",\n      \"items\": {\n        \"type\": \"object\",\n        \"properties\": {\n          \"cluster_name\": { \"type\": \"string\" },\n          \"related_keywords\": { \"type\": \"array\", \"items\": { \"type\": \"string\" } },\n          \"dominant_competitor\": { \"type\": \"string\", \"description\": \"Competitor leading in this topic cluster.\" }\n        },\n        \"required\": [\"cluster_name\", \"related_keywords\"]\n      }\n    },\n    \"content_gap_analysis\": {\n      \"type\": \"object\",\n      \"description\": \"Summary of missing or underrepresented topics in the current content compared to competitors.\",\n      \"properties\": {\n        \"gaps_identified\": { \"type\": \"array\", \"items\": { \"type\": \"string\" } },\n        \"recommendations\": { \"type\": \"array\", \"items\": { \"type\": \"string\" } }\n      }\n    },\n    \"seo_strength_score\": {\n      \"type\": \"integer\",\n      \"minimum\": 0,\n      \"maximum\": 100,\n      \"description\": \"Overall SEO opportunity score (0–100) based on keyword difficulty, gap size, and competitor weaknesses.\"\n    },\n    \"ai_summary\": {\n      \"type\": \"string\",\n      \"description\": \"GPT-generated executive summary of the key findings, keyword opportunities, and competitor insights.\"\n    }\n  },\n  \"required\": [\"query\", \"competitors\", \"keyword_opportunities\", \"seo_strength_score\", \"ai_summary\"]\n}\n"
      },
      "typeVersion": 1.2
    },
    {
      "id": "b5cac579-1031-488c-9caa-75af3c14250e",
      "name": "用于SEO分析师的OpenAI聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        432,
        -784
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "vPKynKbDzJ5ZU4cU",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ccae56d4-2d58-4b87-bc57-e24857716860",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        640,
        -224
      ],
      "parameters": {
        "schemaType": "manual",
        "inputSchema": "{\n\t\"type\": \"object\",\n\t\"properties\": {\"comprehensive_summary\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n        \"abstract_summary\": {\n\t\t\t\"type\": \"string\"\n\t\t}\n    }\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "934a59b1-7061-4834-8b8e-7a37ebecf43d",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        -384
      ],
      "parameters": {
        "color": 6,
        "width": 944,
        "height": 480,
        "content": "## SERP AI代理"
      },
      "typeVersion": 1
    },
    {
      "id": "3941d4f9-83e0-4bcb-87a4-311b1fe9a077",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        -592
      ],
      "parameters": {
        "color": 5,
        "width": 512,
        "height": 896,
        "content": "## 数据丰富"
      },
      "typeVersion": 1
    },
    {
      "id": "f9919d39-0cd5-489f-ad16-4baff0a648ae",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        -1072
      ],
      "parameters": {
        "color": 4,
        "width": 512,
        "height": 448,
        "content": "## SEO分析师"
      },
      "typeVersion": 1
    },
    {
      "id": "a3060af6-1f26-42ab-a69e-4be7a7dc4e01",
      "name": "在表格中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1152,
        -368
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [
            "seo"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/151xx1ClNDoQ2g_SANQJmdN4EJroWWEsPM658dFWLMTQ/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "151xx1ClNDoQ2g_SANQJmdN4EJroWWEsPM658dFWLMTQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/151xx1ClNDoQ2g_SANQJmdN4EJroWWEsPM658dFWLMTQ/edit?usp=drivesdk",
          "cachedResultName": "Competitor Intelligence Agent"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Zjoxh2BUZ6VXGQhA",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "d058cb5c-ee3a-4b50-be25-8562a1be4e68",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        944,
        -384
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3.2
    },
    {
      "id": "b0286661-257a-43e7-ae77-3ddba37af384",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        -560
      ],
      "parameters": {
        "color": 3,
        "width": 480,
        "height": 496,
        "content": "## 导出数据处理"
      },
      "typeVersion": 1
    },
    {
      "id": "32d8e326-65b6-4705-9a01-a8d6c35755c6",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        -944
      ],
      "parameters": {
        "color": 7,
        "width": 992,
        "height": 528,
        "content": "## **目的：**"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a4d805de-2a7e-466a-bdce-26a1bc60e212",
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Summarize the content",
            "type": "main",
            "index": 0
          },
          {
            "node": "Keyword and Topic Analysis",
            "type": "main",
            "index": 0
          },
          {
            "node": "SEO Analyst",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Bing Search": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "SEO Analyst": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Search": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Yandex Search": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "DuckDuckGo Search": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Set the Input Fields": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize the content": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Summarize the content",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Keyword and Topic Analysis": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "OpenAI Chat Model for SEO Analyst": {
      "ai_languageModel": [
        [
          {
            "node": "SEO Analyst",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model For Summarization": {
      "ai_languageModel": [
        [
          {
            "node": "Summarize the content",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Set the Input Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model for Keyword and Topic Analysis": {
      "ai_languageModel": [
        [
          {
            "node": "Keyword and Topic Analysis",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

这是一个高级难度的工作流，适用于Market Research、AI Summarization等场景。适合高级用户，包含 16+ 个节点的复杂工作流

需要付费吗？

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

相关工作流推荐

使用Google Gemini和Decode总结提取Glassdoor公司信息
使用Google Gemini和Decode总结提取Glassdoor公司信息
Set
Code
Merge
+9
15 节点Ranjan Dailata
Market Research
通过 Decodo + Google Sheets + OpenAI GPT-4.1-mini 进行 SEO 竞争对手关键词跟踪
使用 Decodo、GPT-4.1-mini 和 Google Sheets 跟踪竞争对手 SEO 关键词
Set
Code
Google Sheets
+5
11 节点Ranjan Dailata
Market Research
品牌可见性检查 - AI实验室演示项目
跨AI搜索工具的品牌可见性和情感分析 (OpenAI、Perplexity、ChatGPT)
If
Set
Limit
+11
48 节点AOE Agent Lab
Market Research
使用 Bright Data API 和 AI 抓取分析 Google 广告并发送邮件报告
使用 Bright Data API 和 AI 抓取分析 Google 广告并发送邮件报告
Set
Code
Gmail
+15
45 节点Zacharia Kimotho
Market Research
使用ScrapeGraph AI提取n8n社区最近添加的工作流
使用ScrapeGraphAI和Gemini提取和存储n8n社区最近添加的工作流
Set
Merge
Split Out
+12
21 节点Davide
Miscellaneous
使用Decodo和GPT-4o-mini进行LinkedIn人才情报与数据挖掘
利用LinkedIn、Decodo和GPT-4o-mini提取并分析人才情报与数据挖掘
Set
Code
Merge
+9
19 节点Ranjan Dailata
HR
工作流信息
难度等级
高级
节点数量23
分类2
节点类型11
难度说明

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

作者
Ranjan Dailata

Ranjan Dailata

@ranjancse

A Professional based out of India specialized in handling AI-powered automations. Contact me at ranjancse@gmail.com

外部链接
在 n8n.io 上查看 →

分享此工作流