8
n8n 中文网amn8n.com

BuiltWith每周摘要

中级

这是一个Marketing领域的自动化工作流，包含 12 个节点。主要使用 Code, Gmail, HttpRequest, GoogleSheets, Agent 等节点。 使用BuiltWith、GPT-4o和Gmail的自动化每周技术栈报告

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

使用的节点 (12)

Code
Gmail
StickyNote
HttpRequest
GoogleSheets
Agent
ScheduleTrigger
LmChatOpenAi

分类

营销
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "8owN5INh7X8vZtVY",
  "meta": {
    "instanceId": "84ad02d6104594179f43f1ce9cfe3a81637b2faedb57dafcb9e649b7542988db",
    "templateCredsSetupCompleted": true
  },
  "name": "BuiltWith每周摘要",
  "tags": [],
  "nodes": [
    {
      "id": "94dc7e06-7eae-429a-a7ac-a732452b430f",
      "name": "提取技术栈信息",
      "type": "n8n-nodes-base.code",
      "position": [
        900,
        0
      ],
      "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": "609233cd-e8d6-4896-8e63-f065305022e5",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1200,
        220
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "wYwTjEv45IzlAOAu",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "7a9ebaf7-2abf-4e1b-ad9a-bed19adc9bd5",
      "name": "每周触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        180,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "weeks",
              "triggerAtDay": [
                1
              ],
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "0750f0ed-8dd0-4a67-815a-dbb6c5d0c45d",
      "name": "获取域名列表",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        380,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1byVKIR8vdDYc8HbrKVlIXw48dVMvcU23SMczwt4E8S8/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1byVKIR8vdDYc8HbrKVlIXw48dVMvcU23SMczwt4E8S8",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1byVKIR8vdDYc8HbrKVlIXw48dVMvcU23SMczwt4E8S8/edit?usp=drivesdk",
          "cachedResultName": "BuiltWith weekly ecommerce summary"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Rp7XiR3hxJfv03ZO",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "d5f6b578-a70f-4768-86c8-76dac077c99a",
      "name": "获取技术栈（BuiltWith API）",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        680,
        0
      ],
      "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": "7a85fed1-df8e-4fb2-bcf9-aed9fdbf86af",
      "name": "生成技术栈摘要（AI）",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1220,
        0
      ],
      "parameters": {
        "text": "=Provide summary of the data that is scraped from BuiltWith\n\nDomain: {{ $json.Domain }}\nTechnology: {{ $json.Technology }}\nCategory: {{ $json.Category }}\nFirst Detected: {{ $json['First Detected'] }}\nLast Detected: {{ $json['Last Detected'] }}\nURL: {{ $json.URL }}",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 1.9
    },
    {
      "id": "3057b031-183a-4f84-be77-0ce53418203b",
      "name": "发送摘要邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1580,
        0
      ],
      "webhookId": "05291794-346e-453c-985a-7c4fd12620f2",
      "parameters": {
        "sendTo": "shahkar.genai@gmail.com",
        "message": "={{ $json.output }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "Weekly BuitlWith Ecommerce Platform Summary",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "noKcKj5FEpHHvboL",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "fe050e42-81ae-43e2-bb7f-899f9a0f1029",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        120,
        -1380
      ],
      "parameters": {
        "color": 6,
        "width": 440,
        "height": 1560,
        "content": "## 📦 **第1部分：数据收集阶段**"
      },
      "typeVersion": 1
    },
    {
      "id": "55d142da-8cf6-4f84-bb38-d9311eb8e094",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        620,
        -1380
      ],
      "parameters": {
        "color": 5,
        "width": 440,
        "height": 1560,
        "content": "# 🧠 **第2部分：技术栈情报阶段**"
      },
      "typeVersion": 1
    },
    {
      "id": "ddb1135e-3bd4-4b80-aa00-c070ed7722a7",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1120,
        -1100
      ],
      "parameters": {
        "color": 3,
        "width": 620,
        "height": 1460,
        "content": "## 💌 **第3部分：智能摘要与交付**"
      },
      "typeVersion": 1
    },
    {
      "id": "b2c9dc89-87f5-4921-8f98-4dd20601e46a",
      "name": "### 替换 Airtable 连接",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1560,
        -1360
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "0603059d-4e1b-4fa1-b9c5-17b75a40ba56",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1560,
        -1020
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 3398,
        "content": "## 🧩 **自动化技术栈报告工作流**"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {
    "Get Tech Stack (BuiltWith API)": [
      {
        "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": "5f270319-ac54-4ce9-9230-c6debfc01927",
  "connections": {
    "Weekly Trigger": {
      "main": [
        [
          {
            "node": "Fetch Domain List",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Domain List": {
      "main": [
        [
          {
            "node": "Get Tech Stack (BuiltWith API)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Generate Stack Summary (AI)",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Extract Tech Stack Info": {
      "main": [
        [
          {
            "node": "Generate Stack Summary (AI)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Stack Summary (AI)": {
      "main": [
        [
          {
            "node": "Send Summary Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Tech Stack (BuiltWith API)": {
      "main": [
        [
          {
            "node": "Extract Tech Stack Info",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 营销

需要付费吗？

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

相关工作流推荐

AI YouTube分析助手：评论分析与洞察报告
AI YouTube分析助手：评论分析器与洞察报告生成器
If
Set
Code
+9
19 节点Yaron Been
人工智能
自动新闻摘要与邮件简报（GPT-4、NewsAPI 和 Gmail）
使用 GPT-4、NewsAPI 和 Gmail 自动生成新闻摘要与邮件简报
Gmail
Http Request
Google Sheets
+4
7 节点Yaron Been
人工智能
使用 GPT-4 自动生成并分发 LinkedIn 帖子到个人资料和群组
使用 GPT-4 自动生成并分发 LinkedIn 帖子到个人资料和群组
If
Code
Limit
+8
14 节点Yaron Been
人工智能
使用 Phantombuster 的 LinkedIn 帖子互动
使用 Phantombuster、OpenAI GPT 和 Google Sheets 跟踪自动化 LinkedIn 互动
Http Request
Google Sheets
Agent
+3
14 节点Yaron Been
人工智能
FireCrawl摘要机器人
Firecrawl AI驱动的市场情报机器人：自动新闻洞察交付
Code
Slack
Http Request
+4
10 节点Yaron Been
人工智能
YouTube 视频摘要生成器（GPT-4o、Slack 审批与 Reddit 发布）
使用 GPT-4o 生成 YouTube 视频摘要，支持 Slack 审批和 Reddit 发布
Code
Slack
Reddit
+6
15 节点Yaron Been
人工智能
工作流信息
难度等级
中级
节点数量12
分类1
节点类型8
难度说明

适合有一定经验的用户，包含 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 查看 →

分享此工作流