漏洞赏金信息采集器
中级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 8 个节点。主要使用 Code, HttpRequest, GoogleSheets, ScheduleTrigger 等节点。 Twitter漏洞赏金提示自动收集至Google表格
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "Hl5YR8MHd1AyDYXk",
"meta": {
"instanceId": "c5257b5cf4d48704d636909c07c4408a69d6799d0a855eab46287eeb702c84b0",
"templateCredsSetupCompleted": true
},
"name": "漏洞赏金信息采集器",
"tags": [],
"nodes": [
{
"id": "95247308-430c-4f13-bc7d-98beecb5b945",
"name": "由 Github 模型提供支持",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
320,
80
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 4
}
]
}
},
"typeVersion": 1.2
},
{
"id": "6b347ec0-fb37-4ce8-889f-2b29bc1b2e1b",
"name": "📒 工作流概览",
"type": "n8n-nodes-base.stickyNote",
"position": [
-272,
16
],
"parameters": {
"color": 4,
"width": 480,
"height": 232,
"content": "## 🎯 漏洞赏金信息采集器"
},
"typeVersion": 1
},
{
"id": "fa97a28d-cb1c-4e37-8272-3b6efc7f1a44",
"name": "HTTP请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
544,
80
],
"parameters": {
"url": "https://api.twitterapi.io/twitter/tweet/advanced_search",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "query",
"value": "(#bugbountytips OR #bugbounty OR #bugbountytip) -Writeups -discount -phishing -fuck"
},
{
"name": "queryType",
"value": "Latest"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "OlMRj5cL1g7C7eNH",
"name": "Twitterapi.io Xcal"
}
},
"typeVersion": 4.2
},
{
"id": "d7ef4868-ef6b-4a57-95f4-b987dbcea50c",
"name": "📒 Twitter API",
"type": "n8n-nodes-base.stickyNote",
"position": [
496,
-256
],
"parameters": {
"color": 2,
"width": 348,
"height": 198,
"content": "## 🔐 Twitter API设置"
},
"typeVersion": 1
},
{
"id": "e76166b2-e6e4-4543-aad2-68bc8885d231",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
752,
80
],
"parameters": {
"jsCode": "// This approach handles both single tweets and collections\n// It focuses on properly formatting the output for n8n\n\nconsole.log(\"Input item structure:\", JSON.stringify($input.item, null, 2));\n\n// Function to format the date in a more human-readable way\nfunction formatDate(dateString) {\n if (!dateString) return '';\n\n try {\n const date = new Date(dateString);\n // Format: \"March 13, 2025 at 19:25\"\n return date.toLocaleString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit',\n });\n } catch (error) {\n console.log(\"Error formatting date:\", error);\n return dateString; // Return original if parsing fails\n }\n}\n\n// Check if this is a Twitter Search result with multiple tweets\nif ($input.item.json.tweets && Array.isArray($input.item.json.tweets)) {\n const items = $input.item.json.tweets.map(tweet => {\n return {\n json: {\n tweetId: tweet.id || '',\n url: tweet.url || '',\n content: tweet.text || '',\n likeCount: tweet.likeCount || 0,\n retweetCount: tweet.retweetCount || 0,\n replyCount: tweet.replyCount || 0,\n quoteCount: tweet.quoteCount || 0,\n viewCount: tweet.viewCount || 0,\n createdAt: formatDate(tweet.createdAt),\n }\n };\n });\n\n console.log(`Processing ${items.length} tweets`);\n // Return all items\n return items;\n} else {\n // This is a single tweet. Just extract and return its data\n const tweetData = {\n tweetId: $input.item.json.id || '',\n url: $input.item.json.url || '',\n content: $input.item.json.text || '',\n likeCount: $input.item.json.likeCount || 0,\n retweetCount: $input.item.json.retweetCount || 0,\n replyCount: $input.item.json.replyCount || 0,\n quoteCount: $input.item.json.quoteCount || 0,\n viewCount: $input.item.json.viewCount || 0,\n createdAt: formatDate($input.item.json.createdAt)\n };\n\n console.log(\"Processing single tweet\");\n\n // Return as a single item\n return {\n json: tweetData\n };\n}"
},
"typeVersion": 2
},
{
"id": "ca01565b-ded3-42af-832c-0662f0ea2c4d",
"name": "📒 处理",
"type": "n8n-nodes-base.stickyNote",
"position": [
736,
368
],
"parameters": {
"color": 3,
"width": 376,
"height": 168,
"content": "## ⚙️ 数据处理"
},
"typeVersion": 1
},
{
"id": "ed06b8aa-c7ac-4e69-8e19-c2ce422f2bdb",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
992,
80
],
"parameters": {
"columns": {
"value": {
"Url": "={{ $json.url }}",
"Date": "={{ \n (() => {\n const raw = $json.createdAt; // e.g. \"July 7, 2025 at 04:43 AM\"\n const [monthStr, day, yearTime, , time, meridian] = raw.split(/[\\s,]+/);\n const months = {\n January: \"01\", February: \"02\", March: \"03\", April: \"04\", May: \"05\", June: \"06\",\n July: \"07\", August: \"08\", September: \"09\", October: \"10\", November: \"11\", December: \"12\"\n };\n\n const [hour, minute] = time.split(\":\").map(Number);\n let hh = meridian === \"PM\" && hour !== 12 ? hour + 12 : (meridian === \"AM\" && hour === 12 ? 0 : hour);\n const formattedHour = String(hh).padStart(2, '0');\n\n return `${yearTime}-${months[monthStr]}-${String(day).padStart(2, '0')} ${formattedHour}:${minute}:00`;\n })() \n}}",
"Content": "={{ $json.content }}",
"TweetID": "={{ $json.tweetId }}",
"Created At": "={{ $json.createdAt }}"
},
"schema": [
{
"id": "Content",
"type": "string",
"display": true,
"required": false,
"displayName": "Content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TweetID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TweetID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Url",
"type": "string",
"display": true,
"required": false,
"displayName": "Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created At",
"type": "string",
"display": true,
"required": false,
"displayName": "Created At",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"TweetID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "Your Google Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GniS74XmPh4KjdoT",
"name": "Google Sheets beethical"
}
},
"typeVersion": 4.6
},
{
"id": "462cb2c0-136f-454e-9e32-f7fe734c51a9",
"name": "📊 Google Sheets",
"type": "n8n-nodes-base.stickyNote",
"position": [
1248,
-64
],
"parameters": {
"color": 5,
"width": 448,
"height": 198,
"content": "## 📊 Google Sheets设置"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "65c1d539-9a53-41ed-af0a-330c314826b9",
"connections": {
"Code": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 市场调研, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
MetaAds创意洞察研究员v1.4
使用Google Vision和Video Intelligence API分析Meta广告创意
If
Set
Code
+9
32 节点Kirill Khatkevich
市场调研
YouTube评论情感和关键词提取器
使用Gemini AI分析YouTube评论情感和关键词并通过Telegram报告
Set
Code
Telegram
+10
20 节点Budi SJ
市场调研
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
Set
Code
Limit
+9
18 节点Cong Nguyen
市场调研
10 - 商业版图追踪器
使用SerpAPI、Google表格和Airtable的每日竞争对手研究自动化
If
Code
Airtable
+5
15 节点Avkash Kakdiya
市场调研
每日Google广告表现同步到Notion和Google Sheets
每日Google广告表现同步到Notion和Google Sheets
Set
Code
Merge
+5
19 节点Aziz dev
市场调研
使用RapidAPI和Google Sheets报告分析竞争对手关键词
使用RapidAPI和Google Sheets报告分析竞争对手关键词
Code
Form Trigger
Http Request
+2
9 节点Evoort Solutions
市场调研
