Flujo de trabajo automatizado de correo electrónico para recuperación de carritos abandonados

Avanzado

Este es unSalesflujo de automatización del dominio deautomatización que contiene 60 nodos.Utiliza principalmente nodos como If, Set, Wait, Gmail, Twilio. Recuperación de carritos abandonados de Shopify con Gmail, Google Sheets y Twilio (sin código)

Requisitos previos
  • Cuenta de Google y credenciales de API de Gmail
  • Punto final de HTTP Webhook (n8n generará automáticamente)
  • Clave de API de Airtable
  • Pueden requerirse credenciales de autenticación para la API de destino
  • Credenciales de API de Google Sheets
  • Credenciales de API de Admin de Shopify

Categoría

Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "id": "DW3ksS9uXl0bZqpA",
  "meta": {
    "instanceId": "24539f9a60f2589a40df65a44a58187a87f093d6d32a1d8c6b277455f0a7c574"
  },
  "name": "Abandoned Cart Recovery Email Automation Workflow",
  "tags": [],
  "nodes": [
    {
      "id": "dbcb5a20-ffab-448c-a3ac-1d7b1266a161",
      "name": "Obtener carrito",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1480,
        -140
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "41ac1023-1875-4036-8f5a-61002acecc83",
      "name": "Enviar correo (Gmail)",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2360,
        -140
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "18129749-d33a-47ea-b7fd-7ab1034b0a6c",
      "name": "Esperar 24 horas",
      "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": "Enviar SMS (Twilio)",
      "type": "n8n-nodes-base.twilio",
      "disabled": true,
      "position": [
        2700,
        460
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "75a6bdf0-a76d-4e69-b0f1-43fb9858e13c",
      "name": "Registrar en hoja Google",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2840,
        -140
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "0843ecb9-1ee5-4d7b-8218-31fab02cd2cf",
      "name": "Activador 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": "GET Estado de checkout",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        860,
        -140
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "5ea4e065-2a7a-4104-a2b0-c773f47c9d74",
      "name": "¿Checkout completado?",
      "type": "n8n-nodes-base.if",
      "position": [
        1080,
        -140
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "a2650e46-464b-4781-93a5-03a3e5464bf7",
      "name": "Marcar como \"Recuperado naturalmente\"",
      "type": "n8n-nodes-base.googleSheets",
      "disabled": true,
      "position": [
        800,
        840
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "84ae9b4f-0dfc-4082-92f2-2e38bf176424",
      "name": "Extraer valores clave",
      "type": "n8n-nodes-base.set",
      "position": [
        140,
        -140
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "f5f92cb4-2877-407c-b70d-18b764f18ea2",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -840,
        -580
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "187a22d7-9eed-4120-ad7e-07260789478b",
      "name": "Nota adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        -660
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "88e3aa40-3a4a-459e-8602-9c1d20cbbc04",
      "name": "Nota adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1640,
        -820
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "97a284e8-dd3f-438b-a1fc-5ec69662c9e1",
      "name": "Nota adhesiva3",
      "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": "Nota adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7330df7b-49af-4d8e-8150-e5a746d5fc01",
      "name": "Nota adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -820,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3de41525-1e55-4841-8376-32d73c21f031",
      "name": "Nota adhesiva6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -400
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "23ce859c-ada9-4146-853d-e91747fffc75",
      "name": "Nota adhesiva7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "61a233e5-9c8d-46c0-b3e5-f6e36d5efcc8",
      "name": "Nota adhesiva9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "090bb1ac-8169-46fa-8b38-7fad10b9d328",
      "name": "Nota adhesiva10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        360,
        -740
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "814a3f7b-3e5b-4cfa-8c2a-04150e8e9649",
      "name": "Nota adhesiva11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "24dc49f2-2253-4787-ba16-a2c6d1df500f",
      "name": "Nota adhesiva12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -400
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "94e7faa2-6496-4a17-834a-ce8345ebdfdd",
      "name": "Nota adhesiva13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        760,
        -1000
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f62ce466-2417-483b-8118-0e30c585ee80",
      "name": "Nota adhesiva14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        760,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7ceb6745-5581-4ccb-9c01-89e3d661aebb",
      "name": "Nota adhesiva15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "52b21512-635e-4655-814b-9f11e91941cd",
      "name": "Nota adhesiva16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        780,
        -640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c0191d35-5107-47fe-b573-d660392d3139",
      "name": "Nota adhesiva17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        -520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "10fae9e4-833b-42d1-991d-7faf8546fc37",
      "name": "Nota adhesiva18",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6bc23e15-de2b-4b15-8fcb-4e0b04c297c1",
      "name": "Nota adhesiva19",
      "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": "Nota adhesiva20",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1340,
        -1120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9a3f776b-6e1f-4313-8e88-8f0fe62870f1",
      "name": "Nota adhesiva21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1420,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fa1ba6f9-8a00-472f-a731-5711bb27f3ca",
      "name": "Nota adhesiva22",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1360,
        -640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "068a63c5-ab3e-405d-b61a-29e46a791c0b",
      "name": "Nota adhesiva23",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1340,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "36dcbbda-2c4a-4e1d-a5a5-c1509a154e71",
      "name": "Nota adhesiva24",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        -1260
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fde98405-859a-4022-8a79-e2f550833ff8",
      "name": "Nota adhesiva25",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1860,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "22cfecf9-1988-4016-8b07-3fec67082457",
      "name": "Nota adhesiva26",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1800,
        -760
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9b721f12-ca57-44df-a84b-a9500bb546a2",
      "name": "Nota adhesiva27",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fa06a2f6-9209-4608-b5be-66e77164ed97",
      "name": "Nota adhesiva28",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "50bceea4-ca69-4c5f-8500-3057c1814b27",
      "name": "Nota adhesiva29",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        1180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c7b6737c-d7a6-47cb-8e32-0c46465e1717",
      "name": "Aplicar código de descuento global",
      "type": "n8n-nodes-base.set",
      "position": [
        1920,
        -140
      ],
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 3.4
    },
    {
      "id": "9f42e402-4850-4a34-bbb0-585f26f6a8cc",
      "name": "Nota adhesiva30",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2220,
        -1380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fbc42590-c833-436a-8f48-8846cef0cbe8",
      "name": "Nota adhesiva31",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2300,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c2859ff4-4867-472a-a790-6a5f10776550",
      "name": "Nota adhesiva32",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2240,
        -820
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a01cbb1a-f02e-4c95-998f-96c3e28b2cee",
      "name": "Nota adhesiva33",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2220,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d9d57bb6-4a96-4bd2-a1f0-3afd87b2cb2c",
      "name": "Nota adhesiva34",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2220,
        640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3dbc18de-6e44-4805-be96-f3a40b13a854",
      "name": "Nota adhesiva35",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2660,
        -1600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0305e2f6-3212-4172-8731-7e43df65962a",
      "name": "Nota adhesiva36",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2740,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "971196b7-d84a-41cb-997d-a339d2a7f123",
      "name": "Nota adhesiva37",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2680,
        -1180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "20dc36d2-74cb-484e-9a2e-829888ab4dfe",
      "name": "Nota adhesiva38",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3140,
        -560
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f36e17cf-ff68-4d3b-800b-a1faff1b7f12",
      "name": "Nota adhesiva39",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2660,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1c779e0d-a8d1-4e18-864e-8a8cc4a169d7",
      "name": "Nota adhesiva40",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2660,
        640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6515c0ff-09aa-4d35-a999-be06198cf02d",
      "name": "Esperar algunas horas",
      "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": "Esperar algunos días",
      "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": "Iterar sobre elementos",
      "type": "n8n-nodes-base.splitInBatches",
      "disabled": true,
      "position": [
        2840,
        1080
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "53ef93d0-4a1d-4b07-8f88-3487b2a391db",
      "name": "GET Estado de checkout1",
      "type": "n8n-nodes-base.httpRequest",
      "disabled": true,
      "position": [
        3040,
        1180
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "03231319-5aa5-48e9-aaa8-fb210ad17c21",
      "name": "¿Listo para llevar esto al siguiente nivel? ¡En Innovatio te apoyamos! ¡Mucha suerte y grandes éxitos para todos! <3 Velebit de Innovatio",
      "type": "n8n-nodes-base.noOp",
      "disabled": true,
      "position": [
        3540,
        -160
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "007fe0ad-d301-49c4-8039-4909baff7ff6",
      "name": "Nota adhesiva8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3720,
        -820
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c743633f-ad54-4dc0-81c6-3e3049ab2e66",
      "name": "Nota adhesiva41",
      "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": {
    "dbcb5a20-ffab-448c-a3ac-1d7b1266a161": {
      "main": [
        [
          {
            "node": "c7b6737c-d7a6-47cb-8e32-0c46465e1717",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "aa2b3690-c86f-473b-a908-3f81e660db7a": {
      "main": [
        [
          {
            "node": "d8ed04f0-2860-4ba6-9b60-b04dc2ff047e",
            "type": "main",
            "index": 0
          },
          {
            "node": "03231319-5aa5-48e9-aaa8-fb210ad17c21",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "70381b8c-0553-4104-ba61-fc18d3f86900": {
      "main": [
        [],
        [
          {
            "node": "53ef93d0-4a1d-4b07-8f88-3487b2a391db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0843ecb9-1ee5-4d7b-8218-31fab02cd2cf": {
      "main": [
        [
          {
            "node": "84ae9b4f-0dfc-4082-92f2-2e38bf176424",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6515c0ff-09aa-4d35-a999-be06198cf02d": {
      "main": [
        [
          {
            "node": "a05b26e8-81c5-434c-b66c-073601f4110d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d8ed04f0-2860-4ba6-9b60-b04dc2ff047e": {
      "main": [
        [
          {
            "node": "18129749-d33a-47ea-b7fd-7ab1034b0a6c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "84ae9b4f-0dfc-4082-92f2-2e38bf176424": {
      "main": [
        [
          {
            "node": "6515c0ff-09aa-4d35-a999-be06198cf02d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "41ac1023-1875-4036-8f5a-61002acecc83": {
      "main": [
        [
          {
            "node": "75a6bdf0-a76d-4e69-b0f1-43fb9858e13c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5ea4e065-2a7a-4104-a2b0-c773f47c9d74": {
      "main": [
        [
          {
            "node": "a2650e46-464b-4781-93a5-03a3e5464bf7",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "dbcb5a20-ffab-448c-a3ac-1d7b1266a161",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a05b26e8-81c5-434c-b66c-073601f4110d": {
      "main": [
        [
          {
            "node": "5ea4e065-2a7a-4104-a2b0-c773f47c9d74",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "75a6bdf0-a76d-4e69-b0f1-43fb9858e13c": {
      "main": [
        [
          {
            "node": "aa2b3690-c86f-473b-a908-3f81e660db7a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "53ef93d0-4a1d-4b07-8f88-3487b2a391db": {
      "main": [
        [
          {
            "node": "70381b8c-0553-4104-ba61-fc18d3f86900",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c7b6737c-d7a6-47cb-8e32-0c46465e1717": {
      "main": [
        [
          {
            "node": "41ac1023-1875-4036-8f5a-61002acecc83",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a2650e46-464b-4781-93a5-03a3e5464bf7": {
      "main": [
        []
      ]
    }
  }
}
Preguntas frecuentes

¿Cómo usar este flujo de trabajo?

Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.

¿En qué escenarios es adecuado este flujo de trabajo?

Avanzado - Ventas

¿Es de pago?

Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.

Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos60
Categoría1
Tipos de nodos13
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Autor
Velebit from Innovatio

Velebit from Innovatio

@innovatio

I 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

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34