废弃购物车恢复邮件自动化工作流
高级
这是一个Sales领域的自动化工作流，包含 60 个节点。主要使用 If, Set, Wait, Gmail, Twilio 等节点。 通过Gmail、Google表格和Twilio实现Shopify废弃购物车恢复（无代码）
前置要求
- •Google 账号和 Gmail API 凭证
- •HTTP Webhook 端点（n8n 会自动生成）
- •Airtable API Key
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Shopify Admin API 凭证
使用的节点 (60)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "DW3ksS9uXl0bZqpA",
"meta": {
"instanceId": "24539f9a60f2589a40df65a44a58187a87f093d6d32a1d8c6b277455f0a7c574"
},
"name": "废弃购物车恢复邮件自动化工作流",
"tags": [],
"nodes": [
{
"id": "dbcb5a20-ffab-448c-a3ac-1d7b1266a161",
"name": "获取购物车",
"type": "n8n-nodes-base.httpRequest",
"position": [
1480,
-140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "41ac1023-1875-4036-8f5a-61002acecc83",
"name": "发送邮件 (Gmail)",
"type": "n8n-nodes-base.gmail",
"position": [
2360,
-140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "18129749-d33a-47ea-b7fd-7ab1034b0a6c",
"name": "等待24小时",
"type": "n8n-nodes-base.wait",
"disabled": true,
"position": [
2900,
460
],
"webhookId": "88efe41a-61e6-446a-8dd4-2d6ecbc9f4e4",
"parameters": {},
"typeVersion": 1
},
{
"id": "d8ed04f0-2860-4ba6-9b60-b04dc2ff047e",
"name": "发送短信 (Twilio)",
"type": "n8n-nodes-base.twilio",
"disabled": true,
"position": [
2700,
460
],
"parameters": {},
"typeVersion": 1
},
{
"id": "75a6bdf0-a76d-4e69-b0f1-43fb9858e13c",
"name": "记录到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2840,
-140
],
"parameters": {},
"typeVersion": 3
},
{
"id": "0843ecb9-1ee5-4d7b-8218-31fab02cd2cf",
"name": "Shopify 触发器",
"type": "n8n-nodes-base.shopifyTrigger",
"position": [
-460,
-140
],
"webhookId": "ba10bbdd-dc67-4eae-919c-8eff9e197b00",
"parameters": {},
"typeVersion": 1
},
{
"id": "a05b26e8-81c5-434c-b66c-073601f4110d",
"name": "获取结账状态",
"type": "n8n-nodes-base.httpRequest",
"position": [
860,
-140
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "5ea4e065-2a7a-4104-a2b0-c773f47c9d74",
"name": "结账完成？",
"type": "n8n-nodes-base.if",
"position": [
1080,
-140
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "a2650e46-464b-4781-93a5-03a3e5464bf7",
"name": "标记为\"自然恢复\"",
"type": "n8n-nodes-base.googleSheets",
"disabled": true,
"position": [
800,
840
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "84ae9b4f-0dfc-4082-92f2-2e38bf176424",
"name": "提取关键值",
"type": "n8n-nodes-base.set",
"position": [
140,
-140
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "f5f92cb4-2877-407c-b70d-18b764f18ea2",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-840,
-580
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "187a22d7-9eed-4120-ad7e-07260789478b",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
-660
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "88e3aa40-3a4a-459e-8602-9c1d20cbbc04",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1640,
-820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "97a284e8-dd3f-438b-a1fc-5ec69662c9e1",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-840,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "848abc27-e2e4-4b64-a8d4-8ecd27b9bcff",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"disabled": true,
"position": [
-640,
500
],
"webhookId": "e0e91b87-88af-4815-92a9-49db03c9a6bb",
"parameters": {},
"typeVersion": 2
},
{
"id": "f84d8c8a-66d4-4fdc-a5e8-c8b3b877dd09",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7330df7b-49af-4d8e-8150-e5a746d5fc01",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-820,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3de41525-1e55-4841-8376-32d73c21f031",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
-400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "23ce859c-ada9-4146-853d-e91747fffc75",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "61a233e5-9c8d-46c0-b3e5-f6e36d5efcc8",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "090bb1ac-8169-46fa-8b38-7fad10b9d328",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
360,
-740
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "814a3f7b-3e5b-4cfa-8c2a-04150e8e9649",
"name": "便利贴11",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "24dc49f2-2253-4787-ba16-a2c6d1df500f",
"name": "便利贴12",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
-400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "94e7faa2-6496-4a17-834a-ce8345ebdfdd",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
-1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f62ce466-2417-483b-8118-0e30c585ee80",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7ceb6745-5581-4ccb-9c01-89e3d661aebb",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "52b21512-635e-4655-814b-9f11e91941cd",
"name": "便签16",
"type": "n8n-nodes-base.stickyNote",
"position": [
780,
-640
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c0191d35-5107-47fe-b573-d660392d3139",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
-520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "10fae9e4-833b-42d1-991d-7faf8546fc37",
"name": "便签18",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6bc23e15-de2b-4b15-8fcb-4e0b04c297c1",
"name": "便签19",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
420
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cb906b46-aa88-4373-8106-4c33fba5f0e8",
"name": "Airtable",
"type": "n8n-nodes-base.airtable",
"disabled": true,
"position": [
1120,
840
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "9b237c7c-567c-404b-8d03-738061457925",
"name": "便签20",
"type": "n8n-nodes-base.stickyNote",
"position": [
1340,
-1120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9a3f776b-6e1f-4313-8e88-8f0fe62870f1",
"name": "便签21",
"type": "n8n-nodes-base.stickyNote",
"position": [
1420,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fa1ba6f9-8a00-472f-a731-5711bb27f3ca",
"name": "便签22",
"type": "n8n-nodes-base.stickyNote",
"position": [
1360,
-640
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "068a63c5-ab3e-405d-b61a-29e46a791c0b",
"name": "便签23",
"type": "n8n-nodes-base.stickyNote",
"position": [
1340,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "36dcbbda-2c4a-4e1d-a5a5-c1509a154e71",
"name": "便签24",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
-1260
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fde98405-859a-4022-8a79-e2f550833ff8",
"name": "便签 25",
"type": "n8n-nodes-base.stickyNote",
"position": [
1860,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "22cfecf9-1988-4016-8b07-3fec67082457",
"name": "便签 26",
"type": "n8n-nodes-base.stickyNote",
"position": [
1800,
-760
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9b721f12-ca57-44df-a84b-a9500bb546a2",
"name": "便签27",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fa06a2f6-9209-4608-b5be-66e77164ed97",
"name": "便签28",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "50bceea4-ca69-4c5f-8500-3057c1814b27",
"name": "便签29",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
1180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c7b6737c-d7a6-47cb-8e32-0c46465e1717",
"name": "应用全局折扣码",
"type": "n8n-nodes-base.set",
"position": [
1920,
-140
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 3.4
},
{
"id": "9f42e402-4850-4a34-bbb0-585f26f6a8cc",
"name": "Sticky Note30",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
-1380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fbc42590-c833-436a-8f48-8846cef0cbe8",
"name": "便签31",
"type": "n8n-nodes-base.stickyNote",
"position": [
2300,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c2859ff4-4867-472a-a790-6a5f10776550",
"name": "便签32",
"type": "n8n-nodes-base.stickyNote",
"position": [
2240,
-820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a01cbb1a-f02e-4c95-998f-96c3e28b2cee",
"name": "便签33",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d9d57bb6-4a96-4bd2-a1f0-3afd87b2cb2c",
"name": "便签34",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
640
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3dbc18de-6e44-4805-be96-f3a40b13a854",
"name": "便签35",
"type": "n8n-nodes-base.stickyNote",
"position": [
2660,
-1600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0305e2f6-3212-4172-8731-7e43df65962a",
"name": "便签36",
"type": "n8n-nodes-base.stickyNote",
"position": [
2740,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "971196b7-d84a-41cb-997d-a339d2a7f123",
"name": "便签37",
"type": "n8n-nodes-base.stickyNote",
"position": [
2680,
-1180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "20dc36d2-74cb-484e-9a2e-829888ab4dfe",
"name": "Sticky Note38",
"type": "n8n-nodes-base.stickyNote",
"position": [
3140,
-560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f36e17cf-ff68-4d3b-800b-a1faff1b7f12",
"name": "Sticky Note39",
"type": "n8n-nodes-base.stickyNote",
"position": [
2660,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1c779e0d-a8d1-4e18-864e-8a8cc4a169d7",
"name": "Sticky Note40",
"type": "n8n-nodes-base.stickyNote",
"position": [
2660,
640
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6515c0ff-09aa-4d35-a999-be06198cf02d",
"name": "等待数小时",
"type": "n8n-nodes-base.wait",
"position": [
480,
-140
],
"webhookId": "8d36d0c3-ea44-47a7-a1c1-e3f128dcc82e",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "aa2b3690-c86f-473b-a908-3f81e660db7a",
"name": "等待数天",
"type": "n8n-nodes-base.wait",
"position": [
3220,
-160
],
"webhookId": "8d36d0c3-ea44-47a7-a1c1-e3f128dcc82e",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "70381b8c-0553-4104-ba61-fc18d3f86900",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"disabled": true,
"position": [
2840,
1080
],
"parameters": {},
"typeVersion": 3
},
{
"id": "53ef93d0-4a1d-4b07-8f88-3487b2a391db",
"name": "获取结账状态1",
"type": "n8n-nodes-base.httpRequest",
"disabled": true,
"position": [
3040,
1180
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "03231319-5aa5-48e9-aaa8-fb210ad17c21",
"name": "准备好进入下一阶段了吗？我们 Innovatio 团队为你们加油！！！祝大家好运并取得巨大成功 <3 来自 Innovatio 的 Velebit",
"type": "n8n-nodes-base.noOp",
"disabled": true,
"position": [
3540,
-160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "007fe0ad-d301-49c4-8039-4909baff7ff6",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
3720,
-820
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c743633f-ad54-4dc0-81c6-3e3049ab2e66",
"name": "Sticky Note41",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
-820
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Fetch Cart": [
{
"json": {
"checkout": {
"id": 1234567890,
"note": null,
"email": "jane.doe@example.com",
"token": "8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"currency": "USD",
"customer": {
"id": 1092837465,
"note": null,
"email": "jane.doe@example.com",
"phone": "+14155552671",
"state": "enabled",
"last_name": "Doe",
"created_at": "2025-01-15T10:00:00Z",
"first_name": "Jane",
"updated_at": "2025-04-01T12:00:00Z",
"total_spent": "200.00",
"orders_count": 5,
"last_order_id": 123456,
"verified_email": true,
"default_address": {
"id": 54321,
"zip": "M4B1B3",
"city": "Toronto",
"name": "Jane Doe",
"phone": "+14155552671",
"company": null,
"country": "Canada",
"default": true,
"address1": "123 Maple Street",
"address2": null,
"province": "Ontario",
"last_name": "Doe",
"first_name": "Jane",
"customer_id": 1092837465,
"country_code": "CA",
"country_name": "Canada",
"province_code": "ON"
},
"accepts_marketing": false
},
"order_id": null,
"tax_lines": [
{
"rate": 0.13,
"price": "6.00",
"title": "HST"
}
],
"total_tax": "6.00",
"cart_token": "15ec3c4e98ab1231cba93a84d6b08ea6",
"created_at": "2025-04-02T14:23:45Z",
"line_items": [
{
"id": 987654321,
"sku": "LANTERN-001",
"grams": 500,
"price": "45.00",
"title": "Glow-in-the-Dark Lantern",
"vendor": "Lantern Co.",
"taxable": true,
"quantity": 1,
"gift_card": false,
"product_id": 5432109876,
"properties": {},
"variant_id": 1112131415,
"variant_title": "Default Title",
"applied_discount": null,
"requires_shipping": true,
"fulfillment_service": "manual"
},
{
"id": 987654322,
"sku": "MUG-002",
"grams": 300,
"price": "44.00",
"title": "Cozy Campfire Mug",
"vendor": "Mug Makers",
"taxable": true,
"quantity": 1,
"gift_card": false,
"product_id": 5432109877,
"properties": {},
"variant_id": 1617181920,
"variant_title": "Default Title",
"applied_discount": null,
"requires_shipping": true,
"fulfillment_service": "manual"
}
],
"updated_at": "2025-04-02T14:30:00Z",
"total_price": "95.00",
"checkout_url": "https://example.myshopify.com/1234567890/checkouts/8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"completed_at": null,
"discount_codes": [],
"shipping_lines": [
{
"id": 1234567,
"code": null,
"phone": null,
"price": "6.00",
"title": "Standard Shipping",
"source": "shopify",
"discounted_price": "6.00",
"delivery_category": null,
"carrier_identifier": null,
"requested_fulfillment_service_id": null
}
],
"subtotal_price": "89.00",
"taxes_included": false,
"billing_address": {
"zip": "M4B1B3",
"city": "Toronto",
"name": "Jane Doe",
"phone": "+14155552671",
"country": "Canada",
"address1": "123 Maple Street",
"address2": null,
"province": "Ontario",
"last_name": "Doe",
"first_name": "Jane",
"country_code": "CA",
"country_name": "Canada",
"province_code": "ON"
},
"note_attributes": [],
"order_status_url": null,
"shipping_address": {
"zip": "M4B1B3",
"city": "Toronto",
"name": "Jane Doe",
"phone": "+14155552671",
"country": "Canada",
"address1": "123 Maple Street",
"address2": null,
"province": "Ontario",
"last_name": "Doe",
"first_name": "Jane",
"country_code": "CA",
"country_name": "Canada",
"province_code": "ON"
},
"payment_gateway_names": [
"visa",
"paypal"
]
}
}
}
],
"Shopify Trigger": [
{
"json": {
"id": 389472938472,
"note": null,
"email": "jane.doe@example.com",
"token": "8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"currency": "USD",
"customer": {
"id": 1092837465,
"email": "jane.doe@example.com",
"phone": "+14155552671",
"last_name": "Doe",
"first_name": "Jane"
},
"tax_lines": [
{
"rate": 0.13,
"price": "5.85",
"title": "HST"
}
],
"total_tax": "5.85",
"cart_token": "15ec3c4e98ab1231cba93a84d6b08ea6",
"created_at": "2025-04-02T10:23:45-04:00",
"line_items": [
{
"id": 928374928,
"sku": "LANTERN-001",
"price": "45.00",
"title": "Glow-in-the-Dark Lantern",
"vendor": "Lantern Co.",
"quantity": 1,
"variant_id": 123456789,
"variant_title": "Default Title"
}
],
"updated_at": "2025-04-02T10:23:45-04:00",
"total_price": "50.85",
"checkout_url": "https://example.myshopify.com/1234567890/checkouts/8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"completed_at": null,
"shipping_lines": [
{
"code": "Standard",
"price": "5.00",
"title": "Standard Shipping"
}
],
"subtotal_price": "45.00",
"billing_address": {
"zip": "M5V2T6",
"city": "Toronto",
"country": "Canada",
"address1": "456 Oak Avenue",
"province": "Ontario",
"last_name": "Doe",
"first_name": "Jane"
},
"total_discounts": "0.00",
"shipping_address": {
"zip": "M4B1B3",
"city": "Toronto",
"country": "Canada",
"address1": "123 Maple Street",
"province": "Ontario",
"last_name": "Doe",
"first_name": "Jane"
},
"presentment_currency": "USD"
}
}
],
"Wait some hours": [
{
"json": {
"email": "jane.doe@example.com",
"token": "8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"customer": {
"phone": "+14155552671",
"first_name": "Jane"
},
"line_items": [
{
"id": 928374928,
"sku": "LANTERN-001",
"price": "45.00",
"title": "Glow-in-the-Dark Lantern",
"quantity": 1,
"variant_id": 123456789
}
],
"checkout_url": "https://example.myshopify.com/1234567890/checkouts/8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"subtotal_price": "45.00"
}
}
],
"Extract Key Values": [
{
"json": {
"email": "jane.doe@example.com",
"token": "8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"customer": {
"phone": "+14155552671",
"first_name": "Jane"
},
"line_items": [
{
"id": 928374928,
"sku": "LANTERN-001",
"price": "45.00",
"title": "Glow-in-the-Dark Lantern",
"quantity": 1,
"variant_id": 123456789
}
],
"checkout_url": "https://example.myshopify.com/1234567890/checkouts/8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"subtotal_price": "45.00"
}
}
],
"Send Email (Gmail)": [
{
"json": {
"id": "17f02fc12cd7f8b1",
"labelIds": [
"SENT"
],
"threadId": "17f02fc12cd7f8b1",
"discount_url": "https://389472938472.myshopify.com/discount/ABANDONED10",
"discount_code": "ABANDONED10",
"raw_cart_data": {
"email": "jane.doe@example.com",
"token": "8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"customer": {
"phone": "+14155552671",
"first_name": "Jane"
},
"line_items": [
{
"id": 928374928,
"sku": "LANTERN-001",
"price": "45.00",
"title": "Glow-in-the-Dark Lantern",
"quantity": 1
},
{
"id": 928374929,
"sku": "MUG-002",
"price": "44.00",
"title": "Cozy Campfire Mug",
"quantity": 1
}
],
"checkout_url": "https://example.myshopify.com/1234567890/checkouts/8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"completed_at": null,
"subtotal_price": "89.00"
},
"discount_value": "10%",
"discount_description": "Use code ABANDONED10 for 10% off your entire order!"
}
}
],
"GET Checkout Status": [
{
"json": {
"checkout": {
"id": 901236587,
"note": null,
"email": "jane.doe@example.com",
"token": "8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"currency": "USD",
"customer": {
"id": 654321987,
"email": "jane.doe@example.com",
"phone": "+14155552671",
"last_name": "Doe",
"created_at": "2025-03-15T10:15:20-00:00",
"first_name": "Jane",
"updated_at": "2025-04-01T08:30:25-00:00",
"total_spent": "450.00",
"orders_count": 5,
"verified_email": true
},
"tax_lines": [
{
"rate": 0.13,
"price": "6.00",
"title": "HST"
}
],
"total_tax": "6.00",
"cart_token": "15ec3c4e98ab1231cba93a84d6b08ea6",
"created_at": "2025-04-02T14:23:45-00:00",
"line_items": [
{
"id": 123456789,
"sku": "LANTERN-001",
"grams": 500,
"price": "45.00",
"title": "Glow-in-the-Dark Lantern",
"vendor": "Lantern Co.",
"taxable": true,
"quantity": 1,
"gift_card": false,
"tax_lines": [
{
"rate": 0.05,
"price": "2.25",
"title": "State Tax"
}
],
"product_id": 111222333,
"variant_id": 987654321,
"variant_title": "Default Title",
"total_discount": "0.00",
"origin_location": {
"id": 4455667788,
"zip": "90001",
"city": "Los Angeles",
"name": "Main Warehouse",
"address1": "123 Warehouse Lane",
"address2": "",
"country_code": "US",
"province_code": "CA"
},
"requires_shipping": true,
"fulfillment_status": null,
"fulfillment_service": "manual"
},
{
"id": 987654321,
"sku": "MUG-002",
"grams": 300,
"price": "44.00",
"title": "Cozy Campfire Mug",
"vendor": "Mug Makers",
"taxable": true,
"quantity": 1,
"gift_card": false,
"tax_lines": [
{
"rate": 0.05,
"price": "2.20",
"title": "County Tax"
}
],
"product_id": 444555666,
"variant_id": 123456789,
"variant_title": "Default Title",
"total_discount": "0.00",
"origin_location": {
"id": 4455667789,
"zip": "94103",
"city": "San Francisco",
"name": "Secondary Warehouse",
"address1": "456 Storage Drive",
"address2": "Suite 200",
"country_code": "US",
"province_code": "CA"
},
"requires_shipping": true,
"fulfillment_status": null,
"fulfillment_service": "manual"
}
],
"updated_at": "2025-04-02T14:25:30-00:00",
"total_price": "95.00",
"checkout_url": "https://example.myshopify.com/1234567890/checkouts/8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"completed_at": null,
"discount_codes": [
{
"code": "SUMMER20",
"type": "percentage",
"amount": "20.00"
}
],
"shipping_lines": [
{
"code": "Standard",
"price": "5.00",
"title": "Standard Shipping"
}
],
"subtotal_price": "89.00",
"taxes_included": false,
"billing_address": {
"zip": "M5V2T6",
"city": "Toronto",
"phone": "+14155552671",
"country": "Canada",
"address1": "456 Oak Avenue",
"address2": "",
"province": "Ontario",
"last_name": "Doe",
"first_name": "Jane"
},
"note_attributes": [],
"total_discounts": "0.00",
"shipping_address": {
"zip": "M4B1B3",
"city": "Toronto",
"phone": "+14155552671",
"country": "Canada",
"address1": "123 Maple Street",
"address2": "Apt 4B",
"province": "Ontario",
"last_name": "Doe",
"first_name": "Jane"
},
"presentment_currency": "USD"
}
}
}
],
"Log to Google Sheet": [
{
"json": {
"Email": "jane.doe@example.com",
"Status": "EMAIL_SENT",
"Timestamp": "2025-04-02T14:00:23.143+00:00",
"Cart Value": "89.00",
"First Name": "Jane",
"Discount Code": "ABANDONED10"
}
}
],
"GET Checkout Status1": [
{
"json": {
"checkout": {
"email": "jane.doe@example.com",
"token": "8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"customer": {
"phone": "+14155552671",
"first_name": "Jane"
},
"line_items": [
{
"id": 928374928,
"sku": "LANTERN-001",
"price": "45.00",
"title": "Glow-in-the-Dark Lantern",
"quantity": 1
}
],
"checkout_url": "https://example.myshopify.com/1234567890/checkouts/8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"completed_at": null,
"subtotal_price": "45.00"
}
}
}
],
"Apply Global Discount Code": [
{
"json": {
"discount_url": "https://389472938472.myshopify.com/discount/ABANDONED10",
"discount_code": "ABANDONED10",
"raw_cart_data": {
"email": "jane.doe@example.com",
"token": "8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"customer": {
"phone": "+14155552671",
"first_name": "Jane"
},
"line_items": [
{
"id": 928374928,
"sku": "LANTERN-001",
"price": "45.00",
"title": "Glow-in-the-Dark Lantern",
"quantity": 1
},
{
"id": 928374929,
"sku": "MUG-002",
"price": "44.00",
"title": "Cozy Campfire Mug",
"quantity": 1
}
],
"checkout_url": "https://example.myshopify.com/1234567890/checkouts/8a1d3ec4f63a4b4db7f29bc1d86dddbb",
"completed_at": null,
"subtotal_price": "89.00"
},
"discount_value": "10%",
"discount_description": "Use code ABANDONED10 for 10% off your entire order!"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "4e663998-3ff1-4920-8686-05b60dad1e93",
"connections": {
"Fetch Cart": {
"main": [
[
{
"node": "Apply Global Discount Code",
"type": "main",
"index": 0
}
]
]
},
"Wait some days": {
"main": [
[
{
"node": "Send SMS (Twilio)",
"type": "main",
"index": 0
},
{
"node": "Ready to take this to the next level? We at Innovatio are cheering for you!!! Best of luck and great successes to you all <3 Velebit from Innovatio",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "GET Checkout Status1",
"type": "main",
"index": 0
}
]
]
},
"Shopify Trigger": {
"main": [
[
{
"node": "Extract Key Values",
"type": "main",
"index": 0
}
]
]
},
"Wait some hours": {
"main": [
[
{
"node": "GET Checkout Status",
"type": "main",
"index": 0
}
]
]
},
"Send SMS (Twilio)": {
"main": [
[
{
"node": "Wait 24 Hours",
"type": "main",
"index": 0
}
]
]
},
"Extract Key Values": {
"main": [
[
{
"node": "Wait some hours",
"type": "main",
"index": 0
}
]
]
},
"Send Email (Gmail)": {
"main": [
[
{
"node": "Log to Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Completed Checkout?": {
"main": [
[
{
"node": "Mark as \"Recovered Naturally\"",
"type": "main",
"index": 0
}
],
[
{
"node": "Fetch Cart",
"type": "main",
"index": 0
}
]
]
},
"GET Checkout Status": {
"main": [
[
{
"node": "Completed Checkout?",
"type": "main",
"index": 0
}
]
]
},
"Log to Google Sheet": {
"main": [
[
{
"node": "Wait some days",
"type": "main",
"index": 0
}
]
]
},
"GET Checkout Status1": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Apply Global Discount Code": {
"main": [
[
{
"node": "Send Email (Gmail)",
"type": "main",
"index": 0
}
]
]
},
"Mark as \"Recovered Naturally\"": {
"main": [
[]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Gumroad Clientbell
Gumroad Clientbell：自动记录销售、Telegram通知和邮件感谢
If
Set
Gmail
+12
43 节点Velebit from Innovatio
销售
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+19
51 节点Cyril Nicko Gaspar
销售
使用 RetellAI 构建电话代理用于外呼潜在客户资格认证和呼入电话处理 -视频
使用 RetellAI 电话代理、OpenAI GPT-4 和 Google Sheets 自动进行潜在客户资格认定
If
Wait
Gmail
+9
18 节点Dr. Firas
销售
工作流信息
难度等级
高级
节点数量60
分类1
节点类型13
作者
Velebit from Innovatio
@innovatioI design modular (no-code, low-code, AI) automation workflows for creators, marketers, and lean SaaS teams. Founder of [Innovatio](https://innovatio.design) — empowering humans with AI-powered systems that save time, boost revenue, and scale with heart. 🚀 Want custom automation? Let's talk → velebit@innovatio.design
外部链接
在 n8n.io 查看 →
分享此工作流