WooCommerce废弃购物车恢复
中级
这是一个Social Media领域的自动化工作流，包含 11 个节点。主要使用 Code, DateTime, EmailSend, HttpRequest, GoogleSheets 等节点。 使用Google表格邮件提醒的自动化WooCommerce废弃购物车恢复
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "70dLD2GDb2VSXLjF",
"meta": {
"instanceId": "cd438fd1eca1b4215129611b59e2a783bbecd4a7fc04e24e9ac21de3d46ce6cc",
"templateCredsSetupCompleted": true
},
"name": "WooCommerce 废弃购物车恢复",
"tags": [],
"nodes": [
{
"id": "684c3f0b-9ef5-459f-a221-6d7e6ba2d381",
"name": "由 Github 模型提供支持",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1264,
0
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c780c6b1-1bf3-4284-a6ab-95c0cbbab24d",
"name": "计划触发器1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1216,
352
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "a777804c-bcd7-4821-800e-25785a2dc906",
"name": "日期与时间",
"type": "n8n-nodes-base.dateTime",
"position": [
-624,
352
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e96dcd48-58f7-4336-a2fd-3214a3f776f4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1296,
-176
],
"parameters": {
"content": "## 重要说明"
},
"typeVersion": 1
},
{
"id": "b9724f32-e22f-48a2-b679-f54838ad18d0",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1296,
224
],
"parameters": {
"content": "## 重要说明"
},
"typeVersion": 1
},
{
"id": "9579d2f4-fa35-4176-9b2d-ec7925623856",
"name": "HTTP 请求1",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1088,
0
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "93375dcd-fceb-4da7-a0ac-6c83580c6308",
"name": "转换数据",
"type": "n8n-nodes-base.code",
"position": [
-912,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a1d137a4-3a7c-4211-b5e7-07f445470343",
"name": "将订单添加到 Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-720,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "caa2b8cf-b75f-455b-82b0-5f8c33d272ee",
"name": "获取待处理状态的订单",
"type": "n8n-nodes-base.googleSheets",
"position": [
-992,
352
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "407435eb-4bf3-46c8-895f-571e37635908",
"name": "提醒已发送邮件更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
-448,
352
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "4b2f6389-42bf-4e5c-84a5-bb1525a18681",
"name": "发送提醒邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
-800,
352
],
"webhookId": "b21c2743-f858-4f2d-b1d5-28ed41203383",
"parameters": {},
"typeVersion": 2.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "bab8b6c4-e419-48d9-b3f9-20f35ad25263",
"connections": {
"Date & Time": {
"main": [
[
{
"node": "Reminder Sent Email Update",
"type": "main",
"index": 0
}
]
]
},
"Convert data": {
"main": [
[
{
"node": "Adding orders to Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request1": {
"main": [
[
{
"node": "Convert data",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "HTTP Request1",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Get order with pending status",
"type": "main",
"index": 0
}
]
]
},
"Send remider email": {
"main": [
[
{
"node": "Date & Time",
"type": "main",
"index": 0
}
]
]
},
"Reminder Sent Email Update": {
"main": [
[
{
"node": "Get order with pending status",
"type": "main",
"index": 0
}
]
]
},
"Get order with pending status": {
"main": [
[
{
"node": "Send remider email",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 社交媒体
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Facebook广告报告自动化
使用Facebook Graph API和Google Sheets实现Facebook广告报告自动化
If
Code
Merge
+6
17 节点Jacob
市场调研
通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+7
22 节点Oneclick AI Squad
社交媒体
AI生成LinkedIn帖子含人工审批
使用GPT-4、GoToHuman和Blotato的AI生成LinkedIn帖子含人工审批
Code
Merge
Filter
+10
19 节点Robert Breen
社交媒体
X 推文和 Meta Threads 发布器
使用 Late API 和 Google Sheets 自动发布平台优化内容到 X 和 Threads
If
Set
Code
+6
20 节点Fariez
社交媒体
使用Claude、OpenAI和Perplexity自动生成和安排品牌LinkedIn内容
使用Claude、OpenAI和Perplexity自动生成和安排品牌LinkedIn内容
Code
Limit
Linked In
+10
23 节点Abdul Mir
社交媒体
X上的印度教节日帖子
使用Google Gemini和GPT-4o Mini自动发布每日印度教节日帖子到X
Code
Twitter
Http Request
+8
30 节点Harsh Maniya
社交媒体
