抓取 Crunchbase 近期融资轮次
中级
这是一个Sales领域的自动化工作流，包含 13 个节点。主要使用 Set, Code, Merge, ItemLists, HttpRequest 等节点。 抓取 Crunchbase 近期融资轮次
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "f0a68da631efd4ed052a324b63ff90f7a844426af0398a68338f44245d1dd9e5"
},
"nodes": [
{
"id": "0d901abb-f11b-4fdc-88d0-1bbd906ff332",
"name": "拆分结果",
"type": "n8n-nodes-base.itemLists",
"position": [
1040,
460
],
"parameters": {
"options": {},
"fieldToSplitOut": "results"
},
"typeVersion": 1
},
{
"id": "b522f5bc-480c-4a6a-a44b-55ca68c66ad5",
"name": "Piloterr - 获取近期融资 - A 轮",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
460
],
"parameters": {
"url": "https://piloterr.com/api/v2/crunchbase/funding_rounds",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "days_since_announcement",
"value": "1"
},
{
"name": "investment_type",
"value": "series_a"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "123",
"name": "Pilotr"
}
},
"typeVersion": 3
},
{
"id": "5965b7cd-66f4-4c5b-82a2-e9526fb4b366",
"name": "Piloterr - 获取近期融资 - B 轮",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
660
],
"parameters": {
"url": "https://piloterr.com/api/v2/crunchbase/funding_rounds",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "days_since_announcement",
"value": "1"
},
{
"name": "investment_type",
"value": "series_b"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "123",
"name": "Pilotr"
}
},
"typeVersion": 3
},
{
"id": "04ab7fe9-6422-45c3-b165-139577a0e27f",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2360,
480
],
"parameters": {
"columns": {
"value": {
"link": "={{ $json.link }}",
"type": "={{ $json.type }}",
"country": "={{ $json.country }}",
"event_link": "={{ $json.event_link }}",
"website_url": "={{ $json.website_url }}",
"announced_on": "={{ $json.announced_on }}",
"company_name": "={{ $json.company_name }}",
"founded_date": "={{ $json.founded_date }}",
"linkedin_url": "={{ $json.linkedin_url }}",
"money_raised": "={{ $json.money_raised }}",
"funding_total": "={{ $json.funding_total }}",
"employee_count": "={{ $json.employee_count }}",
"investment_type": "={{ $json.investment_type }}",
"monthly_traffic_semrush": "={{ $json.monthly_traffic_semrush }}"
},
"schema": [
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "website_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "money_raised",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "money_raised",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "announced_on",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "announced_on",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_total",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "funding_total",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "monthly_traffic_semrush",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "monthly_traffic_semrush",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "event_link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "event_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employee_count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "employee_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "founded_date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "founded_date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"event_link"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1IZ7BJUtBdezesDS5oBDzFeW-btiH7qB4gdIcwcC01xs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/1IZ7BJUtBdezesDS5oBDzFeW-btiH7qB4gdIcwcC01xs/edit#gid=0",
"__regex": "https:\\/\\/(?:drive|docs)\\.google\\.com\\/\\w+\\/d\\/([0-9a-zA-Z\\-_]+)(?:\\/.*|)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Google Sheets account lucas"
}
},
"typeVersion": 4
},
{
"id": "f88a862c-c413-4248-b061-2a449c6ee0fb",
"name": "Piloterr - 获取近期融资 - 种子轮",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
860
],
"parameters": {
"url": "https://piloterr.com/api/v2/crunchbase/funding_rounds",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "days_since_announcement",
"value": "1"
},
{
"name": "investment_type",
"value": "seed"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "123",
"name": "Pilotr"
}
},
"typeVersion": 3
},
{
"id": "38521229-d315-4bb3-bece-72ff64f602e8",
"name": "准备数据",
"type": "n8n-nodes-base.set",
"position": [
1280,
460
],
"parameters": {
"values": {
"string": [
{
"name": "type",
"value": "={{ $json.investment_type }}"
},
{
"name": "money_raised",
"value": "={{ $json.money_raised.value_usd }}"
},
{
"name": "announced_on",
"value": "={{ $json.announced_on }}"
},
{
"name": "company_name",
"value": "={{ $json.funded_organization_identifier.value }}"
},
{
"name": "link",
"value": "={{ $json.funded_organization_identifier.permalink }}"
},
{
"name": "event_link",
"value": "={{ $json.identifier.permalink }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 2
},
{
"id": "8fad9822-dfe3-4106-981f-f2c8163ce8a0",
"name": "Piloterr - 完善公司信息",
"type": "n8n-nodes-base.httpRequest",
"position": [
1520,
580
],
"parameters": {
"url": "https://piloterr.com/api/v2/crunchbase/company/info",
"options": {
"batching": {
"batch": {
"batchSize": 3
}
}
},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "query",
"value": "=https://www.crunchbase.com/organization/{{ $json[\"link\"] }}"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "123",
"name": "Pilotr"
}
},
"typeVersion": 3,
"continueOnFail": true
},
{
"id": "78289f0d-5721-4615-a883-38a1e48ebb34",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
2100,
480
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1
},
{
"id": "d5e659d7-28ba-4cd7-a6bf-ea7b48d5f34c",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
280
],
"parameters": {
"width": 318.8857938718665,
"height": 287.01949860724255,
"content": "## 说明文档"
},
"typeVersion": 1
},
{
"id": "888f5bf2-4a7f-4f84-95c8-4173fa8d8f83",
"name": "计划触发器 - 每日运行工作流",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
460,
460
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1
},
{
"id": "84f02477-b19c-405f-abde-3e32280208e9",
"name": "导入 Gsheets 前准备数据",
"type": "n8n-nodes-base.set",
"position": [
1860,
580
],
"parameters": {
"values": {
"string": [
{
"name": "website_url",
"value": "={{ $json.website.match(/https?:\\/\\/(?:www\\.)?([^\\/]+)/)[1] }}"
},
{
"name": "monthly_traffic_semrush",
"value": "={{ $json.semrush_summary.semrush_visits_latest_month }}"
},
{
"name": "funding_total",
"value": "={{ $json.funding_rounds_headline.funding_total.value }}"
},
{
"name": "linkedin_url",
"value": "={{ $json.linkedin_url }}"
},
{
"name": "employee_count",
"value": "={{ $json.employee_count }}"
},
{
"name": "country",
"value": "={{ $json.location[2].name }}"
},
{
"name": "founded_date",
"value": "={{ $json.founded }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 2
},
{
"id": "b4952b2f-7202-4b6a-81ec-7251b0d6c308",
"name": "从对象中获取 Linkedin URL",
"type": "n8n-nodes-base.code",
"position": [
1680,
580
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Find the LinkedIn object\nlet linkedinObject = $json.social_networks.find(e => e.name === 'linkedin');\n\n// If the LinkedIn object exists, get the URL; otherwise, set to null or handle error\n$input.item.json.linkedin_url = linkedinObject ? linkedinObject.url : null;\n\n// Check if the URL was set\nif (!$input.item.json.linkedin_url) {\n console.error('No LinkedIn URL found!');\n // Handle the error as required for your application\n}\n\nreturn $input.item;"
},
"typeVersion": 1
},
{
"id": "9e98198d-b9f1-42e4-b703-153f98ffce7c",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
254.26329864271463
],
"parameters": {
"height": 818.134682564936,
"content": "在 piloterr.com 创建账户以获取 API 密钥"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Prepare data": {
"main": [
[
{
"node": "Piloterr - Enrich company",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Split results": {
"main": [
[
{
"node": "Prepare data",
"type": "main",
"index": 0
}
]
]
},
"Piloterr - Enrich company": {
"main": [
[
{
"node": "Get Linkedin URL from object",
"type": "main",
"index": 0
}
]
]
},
"Get Linkedin URL from object": {
"main": [
[
{
"node": "Prepare data before importing to Gsheets",
"type": "main",
"index": 0
}
]
]
},
"Piloterr - Get Recent Fundraise - Seed": {
"main": [
[
{
"node": "Split results",
"type": "main",
"index": 0
}
]
]
},
"Prepare data before importing to Gsheets": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Piloterr - Get Recent Fundraise - Serie A": {
"main": [
[
{
"node": "Split results",
"type": "main",
"index": 0
}
]
]
},
"Piloterr - Get Recent Fundraise - Serie B": {
"main": [
[
{
"node": "Split results",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger - Run Workflow Every Day": {
"main": [
[
{
"node": "Piloterr - Get Recent Fundraise - Serie A",
"type": "main",
"index": 0
},
{
"node": "Piloterr - Get Recent Fundraise - Serie B",
"type": "main",
"index": 0
},
{
"node": "Piloterr - Get Recent Fundraise - Seed",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 销售
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
销售AI网络研究员
销售用AI网络研究员
Set
Merge
Google Sheets
+9
22 节点Lucas Perret
销售
Smartlead 至 HubSpot 性能分析
Smartlead 至 HubSpot 性能分析
If
Set
Code
+8
23 节点victor de coster
销售
Webflow实时线索路由
Webflow实时线索路由
Set
Code
Webhook
+3
10 节点Lucas Perret
销售
AI房地产经纪人：端到端运营自动化（网络、数据、语音）
AI房地产经纪人：端到端运营自动化（网络、数据、语音）
If
Set
Code
+16
45 节点Sam Yassine
销售
电话销售循环
AI驱动电话销售自动化，集成Vapi.ai、GPT-4o和Google Sheets
If
Set
Wait
+8
38 节点Amit Mehta
销售
使用 OpenAI、Google Sheets、Jina AI 和 Slack 的 AI 驱动信息监控
基于AI的信息监控，集成OpenAI、Google Sheets、Jina AI和Slack
If
Set
Code
+10
31 节点Dataki
销售
