通过 Rapiwa API 发送 WooCommerce 新分类 WhatsApp 提醒
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 19 个节点。主要使用 If, Code, Wait, Limit, Webhook 等节点。 通过 Rapiwa API 和 Google Sheets 发送 WooCommerce 分类提醒到 WhatsApp
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "SKKy045wmeQJJw0r",
"meta": {
"instanceId": "cb9a1e5321767b6316634728341237e564b2587ab15b74ca0a89eb02a53484d6"
},
"name": "通过 Rapiwa API 发送 WooCommerce 新分类 WhatsApp 提醒",
"tags": [],
"nodes": [
{
"id": "a541b71e-e2c2-4996-ac24-254cac3b1520",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
784,
0
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "b8aa1d94-1cde-49cd-bcfa-dd2888491155",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-128,
0
],
"webhookId": "1c217a0f-503f-49a4-b0c5-1aa431616177",
"parameters": {
"path": "1c217a0f-503f-49a4-b0c5-1aa431616177",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "08e7182d-9173-44a1-8619-e1132003bfdb",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
1360,
64
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3ab8725a-9268-45fd-b91c-0e055fe6fa7c",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.data.exists }}",
"rightValue": "=\"true\""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2c2889d2-31a2-43a0-9ddd-bc0245fb65cb",
"name": "未验证的追加行到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1600,
192
],
"parameters": {
"columns": {
"value": {
"email": "={{ $('Clean Number').item.json.email }}",
"name ": "={{ $('Clean Number').item.json.name }}",
"number": "={{ $('Clean Number').item.json.number }}",
"status": "unverified",
"address": "={{ $('Clean Number').item.json.address }}",
"catagoris": "={{ $('Format Webhook Response Data').item.json.name }}",
"description": "={{ $('Format Webhook Response Data').item.json.description }}"
},
"schema": [
{
"id": "name ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "number",
"type": "string",
"display": true,
"required": false,
"displayName": "number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "catagoris",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "catagoris",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SbBOtdqaA9eUmgv2W4MXU0-TODjHix-IrmQmuapiSJA/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1SbBOtdqaA9eUmgv2W4MXU0-TODjHix-IrmQmuapiSJA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SbBOtdqaA9eUmgv2W4MXU0-TODjHix-IrmQmuapiSJA/edit?usp=drivesdk",
"cachedResultName": "Sales - Send product catalog"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gFH3Wjq6yYqSEAei",
"name": "Google Sheets"
}
},
"typeVersion": 4.6
},
{
"id": "c13d178c-44d1-43b9-abb4-b2ef2fd4339c",
"name": "已验证的追加行到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1824,
-112
],
"parameters": {
"columns": {
"value": {
"email": "={{ $('Clean Number').item.json.email }}",
"name ": "={{ $('Clean Number').item.json.name }}",
"number": "={{ $('Check valid whatsapp number Using Rapiwa').item.json.data.number }}",
"status": "verified",
"address": "={{ $('Clean Number').item.json.address }}",
"catagoris": "={{ $('Format Webhook Response Data').item.json.name }}",
"description": "={{ $('Format Webhook Response Data').item.json.description }}"
},
"schema": [
{
"id": "name ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "number",
"type": "string",
"display": true,
"required": false,
"displayName": "number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "catagoris",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "catagoris",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yTxkAM1kq2udndvG5M2jUuQCY8SkvoLgrspQ100LvKs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1SbBOtdqaA9eUmgv2W4MXU0-TODjHix-IrmQmuapiSJA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SbBOtdqaA9eUmgv2W4MXU0-TODjHix-IrmQmuapiSJA/edit?usp=drivesdk",
"cachedResultName": "Sales - Send product catalog"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gFH3Wjq6yYqSEAei",
"name": "Google Sheets"
}
},
"typeVersion": 4.6
},
{
"id": "57be7f7a-83a3-4d90-8482-dde77c36af9c",
"name": "限制",
"type": "n8n-nodes-base.limit",
"position": [
592,
0
],
"parameters": {
"maxItems": 10
},
"typeVersion": 1
},
{
"id": "ef0dd016-434e-4ebf-8702-3873296e9d15",
"name": "获取多个客户",
"type": "n8n-nodes-base.wooCommerce",
"position": [
368,
0
],
"parameters": {
"filters": {},
"resource": "customer",
"operation": "getAll",
"returnAll": true
},
"credentials": {
"wooCommerceApi": {
"id": "BZ5Lp9IB4Phney4R",
"name": "WooCommerce (get customer)"
}
},
"typeVersion": 1
},
{
"id": "06ea3912-3b01-45c3-907b-68d40574f6c3",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1888,
-624
],
"parameters": {
"color": 4,
"width": 1568,
"height": 4048,
"content": "# 通过 Rapiwa API 发送 WooCommerce 新分类 WhatsApp 提醒"
},
"typeVersion": 1
},
{
"id": "f4e1ca03-818e-46a9-8638-ea516a43ee62",
"name": "格式化 Webhook 响应数据",
"type": "n8n-nodes-base.code",
"position": [
80,
0
],
"parameters": {
"jsCode": "const data = items[0].json.body;\n\nconst category = {\n id: data.id,\n name: data.name,\n slug: data.slug,\n description: data.description,\n parent: data.parent,\n display_type: data.args?.display_type,\n thumbnail_id: data.args?.product_cat_thumbnail_id\n};\n\nreturn [\n {\n json: category\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "b4337fa3-2263-431c-bf80-13af7754dd24",
"name": "使用 Rapiwa 检查有效的 WhatsApp 号码",
"type": "n8n-nodes-base.httpRequest",
"position": [
1184,
64
],
"parameters": {
"url": "=https://app.rapiwa.com/api/verify-whatsapp",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "number",
"value": "={{ $json.number }}"
}
]
},
"genericAuthType": "httpBearerAuth"
},
"credentials": {
"httpBearerAuth": {
"id": "jnaHCyYia9OAFozh",
"name": "Rapiwa Bearer Auth"
}
},
"typeVersion": 4.2
},
{
"id": "558447c8-a3e5-43b2-8e5a-dbb82041f7a1",
"name": "使用 Rapiwa 发送消息",
"type": "n8n-nodes-base.httpRequest",
"position": [
1600,
-112
],
"parameters": {
"url": "=https://app.rapiwa.com/api/send-message",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "number",
"value": "={{ $json.data.number }}"
},
{
"name": "message_type",
"value": "text"
},
{
"name": "message",
"value": "=Hey {{ $('Clean Number').item.json.name }},\n\nWe just launched a new category: *{{ $('Format Webhook Response Data').item.json.name }}*! \nExplore now👉 https://rahim.spagreen.info/product-category/{{ $('Format Webhook Response Data').item.json.slug }}\nDon’t miss it!\n\nCheers, \nTeam SpaGreen Creative"
}
]
},
"genericAuthType": "httpBearerAuth"
},
"credentials": {
"httpBearerAuth": {
"id": "jnaHCyYia9OAFozh",
"name": "Rapiwa Bearer Auth"
}
},
"typeVersion": 4.2
},
{
"id": "1d88ede8-16a5-463a-87c6-b9004a4249ed",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
1824,
192
],
"webhookId": "6c474e54-eb3c-4fcd-b455-948322cd0121",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "2e148087-cfa0-48a5-a290-7ea909e4c84e",
"name": "清理号码",
"type": "n8n-nodes-base.code",
"position": [
1008,
64
],
"parameters": {
"jsCode": "const items = $input.all();\n\nconst updatedItems = items.map((item) => {\n const billing = item?.json?.billing || {};\n\n // number extract & clean\n const waNo = billing.phone;\n const waNoStr = typeof waNo === 'string' ? waNo : (waNo !== undefined && waNo !== null ? String(waNo) : \"\");\n const cleanedNumber = waNoStr.replace(/\\D/g, \"\");\n\n // Email extract\n const email = billing.email || item?.json?.email || \"\";\n\n // Full address generate\n const addressParts = [\n billing.address_1,\n billing.address_2,\n billing.city,\n billing.state,\n billing.postcode,\n billing.country\n ].filter(Boolean); // remove empty values\n const fullAddress = addressParts.join(', ');\n\n // Output format\n return {\n json: {\n number: cleanedNumber,\n email: email,\n address: fullAddress,\n name: `${billing.first_name || ''} ${billing.last_name || ''}`.trim()\n }\n };\n});\n\nreturn updatedItems;\n"
},
"typeVersion": 2
},
{
"id": "836df614-c61d-4ca8-8b9f-f5029fbbf33f",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
-336
],
"parameters": {
"color": 2,
"width": 528,
"height": 736,
"content": "## Webhook"
},
"typeVersion": 1
},
{
"id": "a083b897-58f2-447c-81c2-3e7d4b24e9ca",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
304,
-336
],
"parameters": {
"color": 6,
"height": 736,
"content": "## 获取多个客户"
},
"typeVersion": 1
},
{
"id": "5f9330bf-928d-4b65-bb80-2a0d679c3356",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
560,
-336
],
"parameters": {
"color": 4,
"width": 384,
"height": 736,
"content": "## 限制"
},
"typeVersion": 1
},
{
"id": "5f6e6d5f-60ee-4bbd-91f9-46a6ce25c2ff",
"name": "便签说明5",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
-624
],
"parameters": {
"color": 5,
"width": 544,
"height": 1024,
"content": "## 清理号码"
},
"typeVersion": 1
},
{
"id": "e7d53496-d99d-448f-9470-50788743d86e",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1520,
-624
],
"parameters": {
"color": 4,
"width": 720,
"height": 1024,
"content": "## 使用 Rapiwa 发送消息"
},
"typeVersion": 1
},
{
"id": "0c112f0e-e944-43d9-87cb-8e1419c77d64",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
-624
],
"parameters": {
"color": 3,
"width": 1184,
"height": 272,
"content": "## 流程摘要："
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Webhook": [
{
"json": {
"body": {
"id": 28,
"args": {
"name": "Electronics",
"slug": "electronics",
"action": "add-tag",
"filter": "db",
"parent": 0,
"screen": "edit-product_cat",
"alias_of": "",
"tag-name": "Electronics",
"taxonomy": "product_cat",
"post_type": "product",
"description": "Shop top-brand Electronics with warranty and excellent customer support. Discover everything you need from audio devices to wearable tech.",
"display_type": "both",
"_wp_http_referer": "/wp-admin/edit-tags.php?taxonomy=product_cat&post_type=product",
"_wpnonce_add-tag": "7f11e02afb",
"product_cat_thumbnail_id": "414"
},
"name": "Electronics",
"slug": "electronics",
"action": "created",
"parent": 0,
"secret": "1c217a0f-503f-49a4-b0c5-1aa431616177",
"description": "Shop top-brand Electronics with warranty and excellent customer support. Discover everything you need from audio devices to wearable tech."
},
"query": {},
"params": {},
"headers": {
"via": "1.1 Caddy",
"host": "n8.spagreen.net",
"accept": "*/*",
"user-agent": "WordPress/6.8.2; https://rahim.spagreen.info",
"content-type": "application/json",
"content-length": "821",
"accept-encoding": "deflate, gzip",
"x-forwarded-for": "45.76.159.14",
"x-forwarded-host": "n8.spagreen.net",
"x-forwarded-proto": "https"
},
"webhookUrl": "https://n8.spagreen.net/webhook-test/1c217a0f-503f-49a4-b0c5-1aa431616177",
"executionMode": "test"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "31c2db81-7d7e-4a63-87ba-24b015f2b040",
"connections": {
"If": {
"main": [
[
{
"node": "Send Message Using Rapiwa",
"type": "main",
"index": 0
}
],
[
{
"node": "unverified append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Format Webhook Response Data",
"type": "main",
"index": 0
}
]
]
},
"Clean Number": {
"main": [
[
{
"node": "Check valid whatsapp number Using Rapiwa",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Clean Number",
"type": "main",
"index": 0
}
]
]
},
"Get many customers": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Send Message Using Rapiwa": {
"main": [
[
{
"node": "verified append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Format Webhook Response Data": {
"main": [
[
{
"node": "Get many customers",
"type": "main",
"index": 0
}
]
]
},
"verified append row in sheet": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"unverified append row in sheet": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Check valid whatsapp number Using Rapiwa": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Rapiwa API从Shopify发送自动WhatsApp订单确认
使用Rapiwa和Google Sheets从Shopify发送自动WhatsApp订单确认
If
Code
Wait
+5
18 节点SpaGreen Creative
内容创作
Shopify自动发送WhatsApp感谢消息和忠诚度优惠券（使用Rapiwa API）
使用Rapiwa从Shopify自动发送WhatsApp感谢消息和忠诚度优惠券
If
Code
Wait
+5
17 节点SpaGreen Creative
内容创作
使用Rapiwa自动化Shopify弃购车WhatsApp提醒（含产品链接）
自动化Shopify弃购车WhatsApp提醒：通过Rapiwa包含产品链接
If
Code
Wait
+5
19 节点SpaGreen Creative
内容创作
使用Rapiwa API实现Shopify订单履约并通过WhatsApp发送跟踪链接
通过WhatsApp自动化Shopify订单履约通知
If
Code
Wait
+5
17 节点SpaGreen Creative
内容创作
使用Rapiwa API从Google表格自动化发送WhatsApp欢迎消息
使用Google表格和Rapiwa为销售线索自动化发送WhatsApp欢迎消息
If
Code
Wait
+6
17 节点SpaGreen Creative
客户培育
使用Rapiwa API的批量WhatsApp营销自动化（非官方集成）
使用Rapiwa API从Google Sheets批量发送WhatsApp消息
If
Code
Wait
+6
20 节点SpaGreen Creative
社交媒体
工作流信息
难度等级
高级
节点数量19
分类2
节点类型10
作者
SpaGreen Creative
@spagreenSpaGreen Creative is a leading software company specializing in SaaS solutions, AI automation, and Laravel/Vue.js development. With 800+ eCommerce platforms and 8,000+ global clients, we deliver powerful tools for OTT, CRM, ERP, and WhatsApp marketing. We combine innovation and tech to build scalable digital products.
外部链接
在 n8n.io 查看 →
分享此工作流