Re-activación de clientes inactivos de Shopify a Beex

• •Credenciales de API de Admin de Shopify
• •Pueden requerirse credenciales de autenticación para la API de destino

{
  "id": "Hro9POa9cP9U8HVd",
  "meta": {
    "instanceId": "ac2da03b571df9a735ad2de1e61d5f202359008d03eb1b0f3a16081cfda79307",
    "templateCredsSetupCompleted": true
  },
  "name": "Re-engage inactive Shopify customers to Beex",
  "tags": [],
  "nodes": [
    {
      "id": "54a24002-a493-4022-b1bc-339411141d7e",
      "name": "API Request",
      "type": "n8n-nodes-base.httpRequest",
      "notes": "Shopify - Customers",
      "position": [
        304,
        80
      ],
      "parameters": {
        "url": "http://shopify.com",
        "options": {}
      },
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "06d5b7c5-a86e-4514-b456-7e43333fcc6d",
      "name": "Dividir Registros",
      "type": "n8n-nodes-base.splitOut",
      "notes": "Tabular Format",
      "position": [
        528,
        80
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "customers"
      },
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "id": "d4e15c5f-9613-4b6c-a4ee-9002800ab4a0",
      "name": "Filtrar por Días",
      "type": "n8n-nodes-base.filter",
      "notes": "days without purchase > 30",
      "position": [
        1840,
        416
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "48901d94-8928-4101-9e57-532b5ee38a68",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.timeDifference.days }}",
              "rightValue": 30
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "3bede028-9fd7-408f-9414-5f921341dec7",
      "name": "1. Shopify",
      "type": "n8n-nodes-base.shopify",
      "notes": "Get Last Order",
      "position": [
        1008,
        80
      ],
      "parameters": {
        "options": {},
        "orderId": "={{ $json.last_order_id }}",
        "operation": "get",
        "authentication": "accessToken"
      },
      "credentials": {
        "shopifyAccessTokenApi": {
          "id": "FUiMKb8kpUnrpqpc",
          "name": "Shopify Access Token account"
        }
      },
      "executeOnce": false,
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "id": "4e19063a-fb2d-4ba4-a8d8-c01ce5b49787",
      "name": "2. Shopify",
      "type": "n8n-nodes-base.shopify",
      "notes": "Get Product",
      "position": [
        1312,
        80
      ],
      "parameters": {
        "resource": "product",
        "operation": "get",
        "productId": "={{ $json.line_items[0].product_id }}",
        "authentication": "accessToken",
        "additionalFields": {}
      },
      "credentials": {
        "shopifyAccessTokenApi": {
          "id": "FUiMKb8kpUnrpqpc",
          "name": "Shopify Access Token account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "id": "f78b1383-1712-4a60-af4d-47cacee79a83",
      "name": "Crear Lead",
      "type": "n8n-nodes-beex.beex",
      "position": [
        2064,
        416
      ],
      "parameters": {
        "email": "={{ $json.email }}",
        "priority": 1,
        "resource": "leads",
        "code_client": "={{ $json.client_id }}",
        "sequence_id": 22,
        "code_country": "={{ $json.wsp.slice(0,3) }}",
        "phone_number": "={{ $json.wsp.slice(3,100) }}",
        "portfolio_id": 81,
        "additionalParameters": {
          "text_01": "={{ $json.closed_at.slice(0,10) }}",
          "text_02": "={{ $json.product_type }}",
          "text_03": "Inactive",
          "first_name": "={{ $json.first_name }}",
          "paternal_surname": "={{ $json.last_name }}"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "4343c05d-152e-4c71-93de-6d10011153e7",
      "name": "Filtrar Clientes",
      "type": "n8n-nodes-base.filter",
      "notes": "With Last Orders",
      "position": [
        736,
        80
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c100217e-d6b5-45b5-94c1-ced1eccdb708",
              "operator": {
                "type": "number",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.last_order_id }}",
              "rightValue": ""
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "b7af6a7b-71c0-40a8-b3f5-76e8513afe57",
      "name": "Calcular Días",
      "type": "n8n-nodes-base.dateTime",
      "notes": "Last Order vs Today",
      "position": [
        1616,
        416
      ],
      "parameters": {
        "endDate": "={{ $now }}",
        "options": {
          "includeInputFields": true
        },
        "operation": "getTimeBetweenDates",
        "startDate": "={{ $json.closed_at }}"
      },
      "notesInFlow": true,
      "typeVersion": 2
    },
    {
      "id": "2ad62037-1ab5-411d-9099-13b96968410b",
      "name": "Extraer Datos de Cliente",
      "type": "n8n-nodes-base.set",
      "position": [
        736,
        432
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b3de839f-2ace-4d1f-84b5-81e476b6637f",
              "name": "client_id",
              "type": "number",
              "value": "={{ $json.id }}"
            },
            {
              "id": "6259d2bb-132e-499a-bb87-ac17b9f7df1d",
              "name": "first_name",
              "type": "string",
              "value": "={{ $json.first_name }}"
            },
            {
              "id": "4f49d283-d2db-4294-8c50-b6ecbc5db10a",
              "name": "last_name",
              "type": "string",
              "value": "={{ $json.last_name }}"
            },
            {
              "id": "a200ca34-cb37-419e-8fe6-0355f5a07b5c",
              "name": "email",
              "type": "string",
              "value": "={{ $json.email }}"
            },
            {
              "id": "c011620d-ec00-4534-a5c1-f6d8d5c77862",
              "name": "wsp",
              "type": "string",
              "value": "={{ $json.phone }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "2de1c05a-1f67-480f-8760-5e7b8b20ab3e",
      "name": "Combinar Datos",
      "type": "n8n-nodes-base.merge",
      "notes": "Client/Product",
      "position": [
        1312,
        416
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition"
      },
      "notesInFlow": true,
      "typeVersion": 3.1
    },
    {
      "id": "7196ebbd-1f85-43bc-ada6-b048aacb65fa",
      "name": "Activador Programado",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        80,
        80
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "months"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "60ad1675-2281-44cc-b7fd-cd904d491f51",
      "name": "Nota Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        16,
        -80
      ],
      "parameters": {
        "color": 7,
        "width": 672,
        "height": 384,
        "content": "## Get the Customer List from Shopify\n- Extracts the customer list for a specific Shopify store via API on a monthly basis.\n- Splits the records to create a tabular format."
      },
      "typeVersion": 1
    },
    {
      "id": "791f703b-4de3-4f8c-b7cb-589abc8d9798",
      "name": "Nota Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        688,
        -80
      ],
      "parameters": {
        "color": 6,
        "width": 208,
        "height": 384,
        "content": "## Filter Customers\n- We discard customers with a null **last_order_id** field."
      },
      "typeVersion": 1
    },
    {
      "id": "88e8493a-4c52-40e7-a027-1f7ce23ecd16",
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        -80
      ],
      "parameters": {
        "color": 7,
        "width": 640,
        "height": 384,
        "content": "## Extract Features from the Last Order\n- We must consider the closing date of the last order.\n- The type of product ordered in the order is also considered."
      },
      "typeVersion": 1
    },
    {
      "id": "a04a9039-c89c-464b-bf14-ec88aaf9f1b1",
      "name": "Nota Adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1536,
        -80
      ],
      "parameters": {
        "color": 7,
        "height": 384,
        "content": "## Extract Data Product"
      },
      "typeVersion": 1
    },
    {
      "id": "594d951d-3ada-4ab8-9f61-f84bfb535428",
      "name": "Nota Adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        688,
        304
      ],
      "parameters": {
        "color": 7,
        "width": 848,
        "height": 304,
        "content": "## Attach Along with the Relevant Customer Data\n- Relevant customer data is merged with data extracted from the order and product.\n- Combine By Position"
      },
      "typeVersion": 1
    },
    {
      "id": "bcdb9b2b-8160-4dd1-bb98-dc743dc55bcd",
      "name": "Nota Adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2000,
        304
      ],
      "parameters": {
        "color": 2,
        "width": 272,
        "height": 304,
        "content": "## Capture Lead in Beex\n- A sequence of steps is prepared for contact."
      },
      "typeVersion": 1
    },
    {
      "id": "7df173d8-7e5f-425f-bb89-9360ce1ab285",
      "name": "Nota Adhesiva6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1536,
        304
      ],
      "parameters": {
        "color": 5,
        "width": 464,
        "height": 304,
        "content": "## Calculate Customer Inactivity Days\n- We obtain the number of days elapsed from the date of the last purchase until today. We filter according to what is obtained"
      },
      "typeVersion": 1
    },
    {
      "id": "388a02a4-6378-492a-8ec1-c57528b1aead",
      "name": "Nota Adhesiva8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        -304
      ],
      "parameters": {
        "width": 572,
        "height": 1040,
        "content": "## Re-engage inactive Shopify customers to Beex\n\n- ⚠️ **Disclaimer**: This workflow uses the community node `n8n-nodes-beex`.  \n- It is only available in **self-hosted** n8n instances.  \n\n![Workflow preview](https://i.imgur.com/grICvWZ.png)\n\n### What this workflow does\nThis n8n template identifies customers on Shopify who haven't purchased in a defined period and automatically reconnects them by creating new leads in Beex.\n\n### How it works\n1. The workflow retrieves customer data from Shopify.\n2. It checks the date of each customer's last order and the type of product they purchased.\n3. If customers exceed the inactivity threshold (for example, 30 days), they are marked as inactive.\n4. Inactive customers are sent to Beex as new leads, injecting the relevant data.\n5. From there, you can run reconnection campaigns directly in Beex, using email sequences, WhatsApp, etc.\n\n### How to use\n- The template can use manual activation for demonstration purposes, but in this case, it was set up using a scheduled trigger.\n- You can adjust the inactivity threshold to match your business rules.\n- Map Shopify customer fields to the corresponding lead fields in Beex.\n\nRequirements\n- A Shopify account with API credentials for the respective store.\n- A Beex account with permission to generate leads + Bearer Token.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "63f920b6-bd16-4558-8285-5932a63fe9ec",
      "name": "Extraer Datos de Producto",
      "type": "n8n-nodes-base.set",
      "position": [
        1616,
        80
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "f1d9ca4d-7180-4401-a885-33ff8b956221",
              "name": "closed_at",
              "type": "string",
              "value": "={{ $('1. Shopify').item.json.closed_at }}"
            },
            {
              "id": "70f70368-78a1-4de4-b8a2-844711a46bca",
              "name": "product_type",
              "type": "string",
              "value": "={{ $json.product_type }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "09030ddd-803f-41af-b8ae-44d8626956fd",
  "connections": {
    "3bede028-9fd7-408f-9414-5f921341dec7": {
      "main": [
        [
          {
            "node": "4e19063a-fb2d-4ba4-a8d8-c01ce5b49787",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4e19063a-fb2d-4ba4-a8d8-c01ce5b49787": {
      "main": [
        [
          {
            "node": "63f920b6-bd16-4558-8285-5932a63fe9ec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2de1c05a-1f67-480f-8760-5e7b8b20ab3e": {
      "main": [
        [
          {
            "node": "b7af6a7b-71c0-40a8-b3f5-76e8513afe57",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "54a24002-a493-4022-b1bc-339411141d7e": {
      "main": [
        [
          {
            "node": "06d5b7c5-a86e-4514-b456-7e43333fcc6d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "06d5b7c5-a86e-4514-b456-7e43333fcc6d": {
      "main": [
        [
          {
            "node": "4343c05d-152e-4c71-93de-6d10011153e7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b7af6a7b-71c0-40a8-b3f5-76e8513afe57": {
      "main": [
        [
          {
            "node": "d4e15c5f-9613-4b6c-a4ee-9002800ab4a0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d4e15c5f-9613-4b6c-a4ee-9002800ab4a0": {
      "main": [
        [
          {
            "node": "f78b1383-1712-4a60-af4d-47cacee79a83",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4343c05d-152e-4c71-93de-6d10011153e7": {
      "main": [
        [
          {
            "node": "3bede028-9fd7-408f-9414-5f921341dec7",
            "type": "main",
            "index": 0
          },
          {
            "node": "2ad62037-1ab5-411d-9099-13b96968410b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7196ebbd-1f85-43bc-ada6-b048aacb65fa": {
      "main": [
        [
          {
            "node": "54a24002-a493-4022-b1bc-339411141d7e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "63f920b6-bd16-4558-8285-5932a63fe9ec": {
      "main": [
        [
          {
            "node": "2de1c05a-1f67-480f-8760-5e7b8b20ab3e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2ad62037-1ab5-411d-9099-13b96968410b": {
      "main": [
        [
          {
            "node": "2de1c05a-1f67-480f-8760-5e7b8b20ab3e",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}