批量删除上传Excel/CSV文件中的HubSpot联系人
中级
这是一个Sales, Marketing领域的自动化工作流，包含 11 个节点。主要使用 If, Set, Hubspot, Webhook, SplitInBatches 等节点。 批量删除上传Excel/CSV文件中的HubSpot联系人
前置要求
- •HubSpot API Key
- •HTTP Webhook 端点（n8n 会自动生成）
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "7d8066d2f56a07000fe7d753d3eeabf0ecdf68413466f30d10afe0906f058427",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "4ea0189c-83eb-4c95-92f8-db9b3dd9b521",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
20,
150
],
"webhookId": "abf99fbe-fa03-4f55-b978-db7cba42a565",
"parameters": {
"path": "abf99fbe-fa03-4f55-b978-db7cba42a565",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "0f8a3ab7-8fae-4d94-8721-05239e402a34",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
680,
150
],
"parameters": {
"options": {
"reset": "={{ false }}"
}
},
"typeVersion": 3
},
{
"id": "7027161a-72ee-47b7-b393-a71a0e9d37f9",
"name": "替换我",
"type": "n8n-nodes-base.noOp",
"position": [
1560,
150
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a376ab8e-d925-4c06-a019-1da903a4a5c4",
"name": "删除联系人",
"type": "n8n-nodes-base.hubspot",
"position": [
1340,
0
],
"parameters": {
"contactId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"operation": "delete",
"authentication": "appToken"
},
"credentials": {
"hubspotAppToken": {
"id": "IpprhyuB3yZtaB5z",
"name": "HubSpot App Token account"
}
},
"typeVersion": 2.1
},
{
"id": "b7fb3731-255b-4a06-8bb0-51a896721bd5",
"name": "搜索联系人",
"type": "n8n-nodes-base.hubspot",
"onError": "continueRegularOutput",
"position": [
900,
75
],
"parameters": {
"limit": 1,
"operation": "search",
"authentication": "appToken",
"filterGroupsUi": {
"filterGroupsValues": [
{
"filtersUi": {
"filterValues": [
{
"value": "={{ $json.email }}",
"propertyName": "email|string"
}
]
}
}
]
},
"additionalFields": {}
},
"credentials": {
"hubspotAppToken": {
"id": "IpprhyuB3yZtaB5z",
"name": "HubSpot App Token account"
}
},
"typeVersion": 2.1,
"alwaysOutputData": true
},
{
"id": "7f7059cc-cd26-43d5-9006-cd56cf020bce",
"name": "如果联系人存在",
"type": "n8n-nodes-base.if",
"position": [
1120,
75
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "dbb5bafc-0939-492f-811f-4bbbfcbbf09d",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.id }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b1e62cd8-5745-4912-9303-2982fa0a26f5",
"name": "解析数据",
"type": "n8n-nodes-base.set",
"position": [
460,
150
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "40719114-6df6-47b5-ba76-ff7f5dbf16db",
"name": "email",
"type": "string",
"value": "={{ $json.emails }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "59ef516b-9237-4085-9e88-a76608c0e70b",
"name": "提取文件数据",
"type": "n8n-nodes-base.extractFromFile",
"position": [
240,
150
],
"parameters": {
"options": {},
"operation": "xlsx"
},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "bfef804a-d87d-4f49-90c3-844ba010bf2d",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
20
],
"parameters": {
"height": 120,
"content": "## 启动工作流"
},
"typeVersion": 1
},
{
"id": "ff6f02b4-0495-43d3-b6b6-a11cf0dd4ceb",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
320
],
"parameters": {
"color": 4,
"width": 320,
"height": 100,
"content": "## 更改输入文件格式"
},
"typeVersion": 1
},
{
"id": "4e23de5c-85a4-40cb-94a1-6216a820bdad",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
360,
0
],
"parameters": {
"color": 4,
"width": 320,
"height": 140,
"content": "## 更改字段名称"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Webhook": {
"main": [
[
{
"node": "Extract File Data",
"type": "main",
"index": 0
}
]
]
},
"Parse Data": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Replace Me": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Delete Contact": {
"main": [
[
{
"node": "Replace Me",
"type": "main",
"index": 0
}
]
]
},
"Search Contact": {
"main": [
[
{
"node": "If contact exists",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Search Contact",
"type": "main",
"index": 0
}
]
]
},
"Extract File Data": {
"main": [
[
{
"node": "Parse Data",
"type": "main",
"index": 0
}
]
]
},
"If contact exists": {
"main": [
[
{
"node": "Delete Contact",
"type": "main",
"index": 0
}
],
[
{
"node": "Replace Me",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 销售, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
[模板] AI宠物店 v8
🐶 AI宠物店助手 - 集成GPT-4o、Google日历和WhatsApp/Instagram/Facebook
If
N8n
Set
+38
244 节点Amanda Benks
销售
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+19
51 节点Cyril Nicko Gaspar
销售
会议反馈收集与Excel OneDrive记录及Outlook通知
通过表单收集会议反馈，记录到Excel OneDrive，并发送Outlook通知
If
Set
Code
+7
13 节点Akhil Varma Gadiraju
营销
使用ExactBuyer通过联系人和公司数据丰富新Hubspot联系人
使用ExactBuyer通过联系人和公司数据丰富新Hubspot联系人
If
Set
Hubspot
+4
12 节点Mutasem
销售
Overpass 潜在客户生成系统
使用 OpenStreetMap 数据生成商业线索并保存到 Google Sheets
If
Set
Code
+12
27 节点Akram Kadri
销售
