BuiltWith到Trello
中级
这是一个Sales、IT Ops领域的自动化工作流，包含 10 个节点。主要使用 Code、Trello、HttpRequest、GoogleSheets、ManualTrigger 等节点。 自动化销售管道：将BuiltWith技术数据通过Google Sheets导入Trello潜在客户卡片
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "SdBKwXCUZaS6VYQE",
"meta": {
"instanceId": "84ad02d6104594179f43f1ce9cfe3a81637b2faedb57dafcb9e649b7542988db"
},
"name": "BuiltWith到Trello",
"tags": [],
"nodes": [
{
"id": "ecafd36c-ff4a-4348-95ec-5a221a73ddf7",
"name": "手动触发器",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-420,
900
],
"parameters": {},
"typeVersion": 1
},
{
"id": "efbaced5-1171-406b-9704-277a12a51f0d",
"name": "从Google Sheets读取域名",
"type": "n8n-nodes-base.googleSheets",
"position": [
-200,
900
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Hs9LcBpC-kaGgD_QjkkqBEJzDeAd85RW_L1fXTYEdCA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Hs9LcBpC-kaGgD_QjkkqBEJzDeAd85RW_L1fXTYEdCA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Hs9LcBpC-kaGgD_QjkkqBEJzDeAd85RW_L1fXTYEdCA/edit?usp=drivesdk",
"cachedResultName": "BuiltWith Domain"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Rp7XiR3hxJfv03ZO",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "1793828d-c274-4b8b-b612-33a80a27fba0",
"name": "通过BuiltWith获取详细信息",
"type": "n8n-nodes-base.httpRequest",
"position": [
60,
900
],
"parameters": {
"url": "https://api.builtwith.com/v21/api.json",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "KEY",
"value": "YOUR_API_KEY"
},
{
"name": "LOOKUP",
"value": "={{ $json.Domain }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "d64e4b44-5a7c-487d-98ec-5f5ff40ecf56",
"name": "提取技术栈信息",
"type": "n8n-nodes-base.code",
"position": [
280,
900
],
"parameters": {
"jsCode": "const result = $json.Results?.[0];\nconst domain = result?.Lookup || null;\nconst path = result?.Result?.Paths?.[0];\nconst url = path?.Url || null;\n\nlet extracted = null;\n\n// Loop through Groups to find the first available Tech entry\nfor (const group of path?.Groups || []) {\n const category = group.Name;\n const tech = group.Tech?.[0];\n \n if (tech) {\n extracted = {\n Technology: tech.Name,\n Category: category,\n \"First Detected\": tech.FirstDetected,\n \"Last Detected\": tech.LastDetected,\n Domain: domain,\n URL: url\n };\n break; // Stop after first match\n }\n}\n\nreturn extracted ? [extracted] : [];\n"
},
"typeVersion": 2
},
{
"id": "63da73d8-06a5-4780-a8b3-24ebf1c93176",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
220
],
"parameters": {
"color": 5,
"width": 360,
"height": 880,
"content": "# 📊 **第3部分：创建Trello卡片**"
},
"typeVersion": 1
},
{
"id": "43a5ae54-2faa-42c0-bdf1-013fe7cdbd34",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"color": 7,
"width": 440,
"height": 1100,
"content": "## 🌍 **第2部分：技术栈查询**"
},
"typeVersion": 1
},
{
"id": "4b3f94c2-ff44-49b4-9382-da3933a015af",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
100
],
"parameters": {
"color": 6,
"width": 420,
"height": 1000,
"content": "## 🧩 **第1部分：输入收集**"
},
"typeVersion": 1
},
{
"id": "4be59f24-b1bf-43c9-979c-70d53e4292c8",
"name": "Trello",
"type": "n8n-nodes-base.trello",
"position": [
620,
900
],
"parameters": {
"name": "Scan BuiltWith Results",
"description": "=域名: {{ $json.Domain }}",
"additionalFields": {
"due": "",
"idMembers": ""
}
},
"typeVersion": 1
},
{
"id": "7df51d43-61d0-4999-8e65-d0d7271e0684",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2100,
100
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "df23bd49-1a2c-4c40-8f38-3b90d24850a8",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2100,
440
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2858,
"content": "## ⚙️ **工作流概览：抓取BuiltWith技术数据并创建Trello卡片**"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Fetch detail via BuiltWith": [
{
"json": {
"Results": [
{
"Lookup": "webflow.com",
"Result": {
"Paths": [
{
"Url": "http://webflow.com",
"Groups": [
{
"Name": "Web Hosting Providers",
"Tech": [
{
"Name": "Amazon Web Services",
"LastDetected": "2025-06-06",
"FirstDetected": "2022-01-10"
}
]
},
{
"Name": "JavaScript Libraries",
"Tech": [
{
"Name": "React",
"LastDetected": "2025-06-06",
"FirstDetected": "2021-05-01"
},
{
"Name": "jQuery",
"LastDetected": "2024-12-01",
"FirstDetected": "2020-09-15"
}
]
}
]
}
]
}
}
]
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "c7136027-b14e-4f10-a759-fbd538ae3991",
"connections": {
"Manual Trigger": {
"main": [
[
{
"node": "Read Domains from Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Extract Tech Stack Info": {
"main": [
[
{
"node": "Trello",
"type": "main",
"index": 0
}
]
]
},
"Fetch detail via BuiltWith": {
"main": [
[
{
"node": "Extract Tech Stack Info",
"type": "main",
"index": 0
}
]
]
},
"Read Domains from Google Sheets": {
"main": [
[
{
"node": "Fetch detail via BuiltWith",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个中级难度的工作流，适用于Sales、IT Ops等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Bright Data和LLMs自动化大规模超个性化外联
通过Bright Data和大语言模型实现大规模超个性化外联自动化
If
Set
Wait
+8
21 节点Yaron Been
Sales
使用 Bright Data 抓取 LinkedIn 职位列表以获取招聘信号和潜在客户
使用 Bright Data 抓取 LinkedIn 职位列表以获取招聘信号和潜在客户
If
Set
Code
+5
15 节点Yaron Been
Sales
智能 Shopify 代理：AI 驱动的弃购车挽回
智能 Shopify 代理：AI 驱动的弃购车挽回系统
If
Wait
Gmail
+7
16 节点Yaron Been
Sales
HubSpot 联系人同步（含 LinkedIn URL）、变更检测与 Gmail 提醒
同步 HubSpot 联系人（含 LinkedIn URL），检测变更并发送 Gmail 提醒
If
Set
Code
+11
46 节点PollupAI
Sales
研究论文爬虫到Google Sheets
使用Bright Data和n8n自动化研究论文收集
Set
Code
Html
+4
12 节点Yaron Been
AI
BuiltWith到Google Sheets
从BuiltWith导出并整理技术栈数据到Google Sheets
Code
Http Request
Google Sheets
+2
10 节点Yaron Been
Marketing
工作流信息
难度等级
中级
节点数量10
分类2
节点类型6
作者
Yaron Been
@yaron-nofluffBuilding 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 上查看 →
分享此工作流