8
n8n 中文网amn8n.com

特斯拉新闻与情绪分析工具

中级

这是一个Marketing领域的自动化工作流，包含 10 个节点。主要使用 Set, Code, HttpRequest, GoogleSheets, ManualTrigger 等节点。 使用BuiltWith跟踪技术变化并记录到Google Sheets

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

使用的节点 (10)

Set
Code
StickyNote
HttpRequest
GoogleSheets
ManualTrigger

分类

营销
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "Gzj0XGbwdrkLDnf6",
  "meta": {
    "instanceId": "84ad02d6104594179f43f1ce9cfe3a81637b2faedb57dafcb9e649b7542988db",
    "templateCredsSetupCompleted": true
  },
  "name": "## 📘 特斯拉新闻与情绪分析工具",
  "tags": [],
  "nodes": [
    {
      "id": "c92c104a-6eba-4178-8bf6-991085ee1695",
      "name": "手动触发器",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "76e24861-9f7d-4b29-b522-6a844b9436bb",
      "name": "Builtwith追踪器转邮件",
      "type": "n8n-nodes-base.set",
      "position": [
        220,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "03833cf1-e817-4466-9507-f8ddb587b5cb",
              "name": "Technology",
              "type": "string",
              "value": "Shopify"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "15417d50-e7dd-4114-b907-fccc811868af",
      "name": "设置技术",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        520,
        0
      ],
      "parameters": {
        "url": "https://api.builtwith.com/v20/api.json",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "KEY",
              "value": "YOUR_API_KEY"
            },
            {
              "name": "TECH",
              "value": "={{ $json.Technology }}"
            },
            {
              "name": "START",
              "value": "0"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "c688d193-0f53-4a83-a60e-8f2c8d10ab33",
      "name": "获取BuiltWith数据",
      "type": "n8n-nodes-base.code",
      "position": [
        740,
        0
      ],
      "parameters": {
        "jsCode": "const techSearched = $json[\"technologies\"] || \"Unknown\"; // fallback in case it's not set\nconst results = $json.Results || [];\n\nreturn results.map(site => {\n  return {\n    json: {\n      domain: site.ResultPath || \"\",\n      technology: techSearched,\n      firstIndexed: site.FirstIndexed || \"\",\n      vertical: site.Vertical || \"\"\n    }\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "dda7e1db-6e29-4f2d-b98f-25e1473f4ac8",
      "name": "提取网站信息",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1120,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Domain": "={{ $json.domain }}",
            "Vertical": "={{ $json.vertical }}",
            "Technology": "={{ $json.technology }}",
            "First Indexed": "={{ $json.firstIndexed }}"
          },
          "schema": [
            {
              "id": "Domain",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Technology",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Technology",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Indexed",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Indexed",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Vertical",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Vertical",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lDu3HvxcpA1nRDJq6Ge-OrMO0v592UfLBIjt3Ylc3Mo/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1lDu3HvxcpA1nRDJq6Ge-OrMO0v592UfLBIjt3Ylc3Mo",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lDu3HvxcpA1nRDJq6Ge-OrMO0v592UfLBIjt3Ylc3Mo/edit?usp=drivesdk",
          "cachedResultName": "Builtwith"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Rp7XiR3hxJfv03ZO",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "9e1ffa72-734e-4a66-a3e8-2b45b8979e4a",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -980
      ],
      "parameters": {
        "color": 3,
        "width": 400,
        "height": 1160,
        "content": "记录到Google表格"
      },
      "typeVersion": 1
    },
    {
      "id": "a43fadd2-cf70-4f67-aa99-f513ea0e404a",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        -1180
      ],
      "parameters": {
        "color": 5,
        "width": 420,
        "height": 1360,
        "content": "## 🧩 第一部分：**🔘 手动启动 + 📝 设置目标技术**"
      },
      "typeVersion": 1
    },
    {
      "id": "97ce7536-bc81-4f00-966d-7375c6563fa3",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1000,
        -720
      ],
      "parameters": {
        "color": 6,
        "width": 360,
        "height": 900,
        "content": "## 🔗 第二部分：**🌐 获取 + 🧠 处理BuiltWith数据**"
      },
      "typeVersion": 1
    },
    {
      "id": "dd0c5a1a-c155-4f8b-8680-8ccd4dd4196d",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1680,
        -980
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "d3a277a7-ad8c-4f8c-bd08-5ac2b3e7f87e",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1680,
        -640
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 2658,
        "content": "## 📊 第三部分：**📄 记录到Google表格**"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {
    "Fetch BuiltWith Data": [
      {
        "json": {
          "Next": 2,
          "Limit": 2,
          "Start": 0,
          "Total": 2345,
          "Results": [
            {
              "Vertical": "E-commerce",
              "ResultPath": "www.example-shop.com",
              "FirstIndexed": "2024-11-02",
              "Technologies": [
                {
                  "Name": "Shopify",
                  "Categories": [
                    "Ecommerce",
                    "Hosted Solution"
                  ],
                  "Description": "Shopify is a hosted ecommerce platform.",
                  "LastDetected": "2025-06-01",
                  "FirstDetected": "2024-10-15"
                },
                {
                  "Name": "jQuery",
                  "LastDetected": "2025-06-01",
                  "FirstDetected": "2024-10-15"
                }
              ]
            },
            {
              "Vertical": "Retail",
              "ResultPath": "www.coolstore.net",
              "FirstIndexed": "2024-12-18",
              "Technologies": [
                {
                  "Name": "Shopify",
                  "LastDetected": "2025-05-30",
                  "FirstDetected": "2024-12-01"
                }
              ]
            }
          ]
        }
      }
    ]
  },
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "97826b84-6499-4d64-b608-f6a256cb8684",
  "connections": {
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Set Technology",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Technology": {
      "main": [
        [
          {
            "node": "Fetch BuiltWith Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Site Info": {
      "main": [
        [
          {
            "node": "Log to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch BuiltWith Data": {
      "main": [
        [
          {
            "node": "Extract Site Info",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 营销

需要付费吗？

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

相关工作流推荐

Builtwith 技术栈追踪器
使用 BuiltWith 追踪技术栈并查找决策者，同步至 Google Sheets
Set
Code
Http Request
+3
10 节点Yaron Been
人工智能
AI YouTube分析助手：评论分析与洞察报告
AI YouTube分析助手：评论分析器与洞察报告生成器
If
Set
Code
+9
19 节点Yaron Been
人工智能
使用Bright Data和LLMs自动化大规模超个性化外联
通过Bright Data和大语言模型实现大规模超个性化外联自动化
If
Set
Wait
+8
21 节点Yaron Been
销售
CrunchBase竞争对手追踪
自动竞争对手情报：从CrunchBase到ClickUp的追踪工作流
Set
Code
Click Up
+3
9 节点Yaron Been
营销
YouTube频道智能收集器
使用Google表格和SerpAPI收集YouTube频道统计数据和联系信息
Set
Code
Http Request
+3
15 节点Yaron Been
营销
CrunchBase竞争对手追踪
CrunchBase竞争对手情报追踪器
Set
Code
Click Up
+3
9 节点Yaron Been
财务
工作流信息
难度等级
中级
节点数量10
分类1
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Yaron Been

Yaron Been

@yaron-nofluff

Building AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos

外部链接
在 n8n.io 查看 →

分享此工作流