WA-机器人模块目录-v1-数据库销售完整版
高级
这是一个Sales, Marketing领域的自动化工作流，包含 22 个节点。主要使用 If, Set, Switch, Postgres, WhatsApp 等节点。 基于PostgreSQL数据库的WhatsApp产品目录机器人
前置要求
- •PostgreSQL 数据库连接信息
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "einrgpZs8WKQAqu1",
"meta": {
"instanceId": "888b5b52ac2aa3f8f1bab6800cae8fce6f3d7947e840e64245b5198449908655",
"templateCredsSetupCompleted": true
},
"name": "WA-机器人模块目录-v1-数据库销售完整版",
"tags": [
{
"id": "XPad0ERjSdqfxG52",
"name": "module",
"createdAt": "2025-03-31T08:11:00.151Z",
"updatedAt": "2025-03-31T08:11:00.151Z"
},
{
"id": "NeRMkUNq0sRVlL99",
"name": "whatsapp",
"createdAt": "2025-03-10T18:20:40.864Z",
"updatedAt": "2025-03-10T18:20:40.864Z"
},
{
"id": "2ocrWSzdKoCOU2AC",
"name": "sell",
"createdAt": "2025-04-19T15:39:51.859Z",
"updatedAt": "2025-04-19T15:39:51.859Z"
}
],
"nodes": [
{
"id": "9dbf0a91-9e4a-4757-bd40-e1399ab58865",
"name": "WhatsApp 触发器",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
40,
760
],
"webhookId": "6d38e6e2-569d-4255-af24-6fae951c98a0",
"parameters": {},
"typeVersion": 1
},
{
"id": "eb291d0c-62b4-4ab4-a156-b16c0d76ff86",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c1942b46-997c-4349-998b-798045c47b99",
"name": "开始",
"type": "n8n-nodes-base.whatsApp",
"position": [
480,
560
],
"webhookId": "97b1bb78-fe29-456b-8ee8-0cffe5514542",
"parameters": {},
"typeVersion": 1
},
{
"id": "9bfe4a0c-00fe-40b8-848b-a67658e05d2e",
"name": "更新插入机器人状态",
"type": "n8n-nodes-base.postgres",
"position": [
700,
560
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "d40ba34b-2d8d-4037-9dcf-a4431efd0adf",
"name": "获取机器人状态",
"type": "n8n-nodes-base.postgres",
"position": [
480,
760
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "cb4a1b1f-2954-42e7-b0cf-5f416d0934fd",
"name": "开始？",
"type": "n8n-nodes-base.if",
"position": [
700,
760
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "a8270c23-90c1-45a8-906b-c32308ce82c5",
"name": "命令",
"type": "n8n-nodes-base.switch",
"position": [
920,
760
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "e055dd17-081a-4df8-a1e2-ba53b7f56ddc",
"name": "主菜单",
"type": "n8n-nodes-base.whatsApp",
"position": [
1140,
560
],
"webhookId": "cd5df846-17b0-4db3-9eae-9071a64f4684",
"parameters": {},
"typeVersion": 1
},
{
"id": "01323750-e79b-4e21-88f5-d4df6960763d",
"name": "初始化",
"type": "n8n-nodes-base.set",
"position": [
260,
760
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d923afe8-8c33-4771-ac91-b9393baba338",
"name": "合并列表",
"type": "n8n-nodes-base.summarize",
"position": [
1800,
940
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "81b7379d-1990-4453-bf8b-b409cc50fe15",
"name": "带问题的合并号码",
"type": "n8n-nodes-base.set",
"position": [
1580,
940
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "53fc423b-9707-4cfb-9473-232980f83829",
"name": "获取卡片产品",
"type": "n8n-nodes-base.postgres",
"position": [
1360,
940
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "932bea53-611c-44aa-839c-5174c2741f62",
"name": "列出卡片",
"type": "n8n-nodes-base.whatsApp",
"position": [
2020,
940
],
"webhookId": "a68ee40b-a218-4e95-b423-d4a415e2e70c",
"parameters": {},
"typeVersion": 1
},
{
"id": "ebec012a-b17c-44ef-91fd-2c8a8fc5fbbd",
"name": "获取卡片产品",
"type": "n8n-nodes-base.postgres",
"position": [
1580,
1140
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "b8f8dae0-768c-4248-abc9-fa3a21656d14",
"name": "获取卡片产品",
"type": "n8n-nodes-base.postgres",
"position": [
1360,
1140
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "eb3efce7-3883-4340-bfd1-457ad08fc5c9",
"name": "列表？",
"type": "n8n-nodes-base.if",
"position": [
1140,
940
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c01e352a-55b8-4b6c-a695-59b5a6b888cc",
"name": "卡片",
"type": "n8n-nodes-base.whatsApp",
"position": [
2020,
1140
],
"webhookId": "6f71f250-0b46-4302-b0c0-bd741a1539da",
"parameters": {},
"typeVersion": 1
},
{
"id": "df165c25-5c02-43b6-858a-1a0659562111",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
760
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4e29ce66-eb53-4f81-b05e-0e6360c46faf",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6195e5dd-c8e1-4ba5-9a45-d2da789b296e",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
40,
1080
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6e40affe-50a5-4588-b7b3-f7afadb39a2f",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
1080
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ca246a5b-e4fa-4f90-8ba6-68090817e024",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
40,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"WhatsApp Trigger": [
{
"json": {
"field": "messages",
"contacts": [
{
"wa_id": "77771350073",
"profile": {
"name": "Андрей Б"
}
}
],
"messages": [
{
"id": "wamid.HBgLNzc3NzEzNTAwNzMVAgASGCA1NjYxQUU2OEIxNzg0MjI2M0VBRDQ1REE3M0YxOTY4MAA=",
"from": "77771350073",
"text": {
"body": "1"
},
"type": "text",
"timestamp": "1741972300"
}
],
"metadata": {
"phone_number_id": "626633947192831",
"display_phone_number": "15556349364"
},
"messaging_product": "whatsapp"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "53ceca69-2a22-4a99-b3d3-f78675c6df32",
"connections": {
"List?": {
"main": [
[
{
"node": "Get Card products",
"type": "main",
"index": 0
}
],
[
{
"node": "Get Card products ",
"type": "main",
"index": 0
}
]
]
},
"Start?": {
"main": [
[
{
"node": "Starts",
"type": "main",
"index": 0
}
],
[
{
"node": "Commands",
"type": "main",
"index": 0
}
]
]
},
"Starts": {
"main": [
[
{
"node": "Upsert Bot Status",
"type": "main",
"index": 0
}
]
]
},
"Commands": {
"main": [
[
{
"node": "Main Menu",
"type": "main",
"index": 0
}
],
[
{
"node": "List?",
"type": "main",
"index": 0
}
]
]
},
"Union list ": {
"main": [
[
{
"node": "List Cards",
"type": "main",
"index": 0
}
]
]
},
"Get Bot Status": {
"main": [
[
{
"node": "Start?",
"type": "main",
"index": 0
}
]
]
},
"Initialization": {
"main": [
[
{
"node": "Get Bot Status",
"type": "main",
"index": 0
}
]
]
},
"Get Card product": {
"main": [
[
{
"node": "Card",
"type": "main",
"index": 0
}
]
]
},
"WhatsApp Trigger": {
"main": [
[
{
"node": "Initialization",
"type": "main",
"index": 0
}
]
]
},
"Get Card products": {
"main": [
[
{
"node": "Union Number with Question ",
"type": "main",
"index": 0
}
]
]
},
"Get Card products ": {
"main": [
[
{
"node": "Get Card product",
"type": "main",
"index": 0
}
]
]
},
"Union Number with Question ": {
"main": [
[
{
"node": "Union list ",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
WA-机器人模块-测验-v1-数据库销售完整版
使用PostgreSQL自动化WhatsApp测验和结果排名（"测验"模块）
If
Set
Sort
+6
39 节点Andrew
销售
WA-机器人模块-预约-v1-数据库-销售-完整版
通过Telegram和PostgreSQL的自动化客户预约（"预约"模块）
If
Set
Merge
+6
49 节点Andrew
销售
WA-机器人-模块-问卷-v1-数据库-销售-完整版
在Postgres中收集WhatsApp问卷回复（"Anketa"模块）
If
Set
Switch
+4
32 节点Andrew
销售
TG-机器人模块-跨平台发布-v1-数据库-销售完整版
使用Postgres自动化Telegram频道帖子（"跨平台发布"模块）
If
Set
Switch
+5
47 节点Andrew
销售
TG-Bot-Module-Quiz-v4-db-sell-full
通过Telegram在Postgres中自动化测试和收集响应（"测验"模块）
If
Set
Code
+9
36 节点Andrew
销售
TG机器人-复选框模块-v2-数据库-销售完整版
Telegram机器人，用于多选项目并保存到PostgreSQL（"复选框"模块）
If
Set
Code
+6
46 节点Andrew
销售
