Detector automático de anomalías de ventas de QuickBooks (con alertas de correo profesional) (En revisión)

Avanzado

Este es unCRMflujo de automatización del dominio deautomatización que contiene 26 nodos.Utiliza principalmente nodos como If, Set, Code, Merge, Filter. Detector automatizado de anomalías en ventas de QuickBooks con recordatorios profesionales por correo

Requisitos previos
  • Pueden requerirse credenciales de autenticación para la API de destino

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": "oM2nqKei3FUejaPF",
  "meta": {
    "instanceId": "e727f992f69a44655d3d4d5a1d4a30ca3ec1573139240bc4d84b17b8f66642c8",
    "templateCredsSetupCompleted": true
  },
  "name": "Automated QuickBooks Sales Anomaly Detector with Professional Email Alerts (Under Review)",
  "tags": [],
  "nodes": [
    {
      "id": "d2715036-0d78-47cb-84e1-c52f1e5a1cfc",
      "name": "Crear_Rango_Fechas",
      "type": "n8n-nodes-base.set",
      "position": [
        -656,
        288
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "f14d7155-0e5c-406b-9723-53ba805465f1",
      "name": "Obtener_Facturas_30Días",
      "type": "n8n-nodes-base.quickbooks",
      "position": [
        -432,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "90c27fd1-a826-4713-a8f6-ad3ba1d235df",
      "name": "Filtrar_Facturas_Pagadas_30Días",
      "type": "n8n-nodes-base.filter",
      "position": [
        -144,
        0
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "bc270132-a495-4a9a-90c5-934f983780a7",
      "name": "Obtener_RecibosVenta_30Días",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -432,
        192
      ],
      "parameters": {},
      "typeVersion": 4.3
    },
    {
      "id": "982dc6ef-130f-4d09-affb-a5fb225f73fb",
      "name": "Sumar_Totales_30Días",
      "type": "n8n-nodes-base.summarize",
      "position": [
        368,
        96
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "792d5926-e700-4d60-8710-6a36ee0480af",
      "name": "Calcular_Promedio_30Días",
      "type": "n8n-nodes-base.set",
      "position": [
        592,
        96
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "9813b1fa-3095-4b52-8f74-f2ae38fb31d4",
      "name": "Calcular_Desviación",
      "type": "n8n-nodes-base.set",
      "position": [
        1264,
        288
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "28d2c1ce-3f68-4787-ac9b-a8d7a8a0139b",
      "name": "Verificar_Si_Anomalía",
      "type": "n8n-nodes-base.if",
      "position": [
        1568,
        288
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f670c98c-040f-4740-b04a-9b9c5412d5ed",
      "name": "Preparar_Contenido_Correo",
      "type": "n8n-nodes-base.set",
      "position": [
        1920,
        288
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "d09e3d54-5f14-4fbd-8c97-ccd4dd972db5",
      "name": "Enviar_Correo_Alerta",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2320,
        288
      ],
      "webhookId": "9189369f-15ba-4b9c-a29e-175985e248e0",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "3b550e06-6309-4f04-a206-7294402593e3",
      "name": "Obtener_Facturas_Ayer",
      "type": "n8n-nodes-base.quickbooks",
      "position": [
        -432,
        384
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bdd0ff43-2844-4925-b973-6cd874f167a1",
      "name": "Obtener_RecibosVenta_Ayer",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -432,
        576
      ],
      "parameters": {},
      "typeVersion": 4.3
    },
    {
      "id": "dc0f316e-5c09-48e8-a680-58fcefb9e9b0",
      "name": "Filtrar_Facturas_Pagadas_Ayer",
      "type": "n8n-nodes-base.filter",
      "position": [
        -144,
        384
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "420a7697-9548-4bd4-9756-f455f6c80766",
      "name": "Total_RecibosVenta_30Días",
      "type": "n8n-nodes-base.code",
      "position": [
        -144,
        192
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "95cd9852-11e6-4ca8-9f93-5dd5b3bdfe5d",
      "name": "Combinar_Facturas_RecibosVenta_30Días",
      "type": "n8n-nodes-base.merge",
      "position": [
        144,
        96
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "afceb5d0-b0d1-435e-8280-08d9e9d4f932",
      "name": "Combinar_Facturas_RecibosVenta_Ayer",
      "type": "n8n-nodes-base.merge",
      "position": [
        144,
        480
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "132df91a-b498-4e48-9551-4f3ab1f2d4ee",
      "name": "Sumar_Totales_Ayer",
      "type": "n8n-nodes-base.summarize",
      "position": [
        368,
        480
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "11b1c80d-ecf6-444f-a5b9-0158d3aa5b1c",
      "name": "Combinar_Facturas_RecibosVenta_Totales",
      "type": "n8n-nodes-base.code",
      "position": [
        1040,
        288
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "989164aa-eece-4c7e-bcf2-b2217315f4f4",
      "name": "Ejecutar_Cada_Mañana",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -880,
        288
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "d38f399e-7d94-4888-b4a4-b62776eac1e1",
      "name": "Extraer_RecibosVenta_Ayer",
      "type": "n8n-nodes-base.code",
      "position": [
        -144,
        576
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "8b5c6c01-e634-4279-bfc7-10aa302e1239",
      "name": "Combinar_Totales_Finales",
      "type": "n8n-nodes-base.merge",
      "position": [
        816,
        288
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "c1d915d4-ab91-4286-b69d-1387fdd49bdb",
      "name": "Nota_Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2256,
        -160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "992f43e4-9c63-45e6-8494-e9f8e45b7dc5",
      "name": "Nota_Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -976,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b6c86e28-2007-4391-9f05-be4ae843ffed",
      "name": "Nota_Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        -160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "63f83511-8da5-48db-bb9c-3af22c749dfe",
      "name": "Nota_Adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1456,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c467e9e5-4df1-482f-a102-c52e4ee16f0f",
      "name": "Nota_Adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2208,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "9dc17266-ea65-459c-9efb-affbd6b0aa96",
  "connections": {
    "28d2c1ce-3f68-4787-ac9b-a8d7a8a0139b": {
      "main": [
        [
          {
            "node": "f670c98c-040f-4740-b04a-9b9c5412d5ed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "982dc6ef-130f-4d09-affb-a5fb225f73fb": {
      "main": [
        [
          {
            "node": "792d5926-e700-4d60-8710-6a36ee0480af",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d2715036-0d78-47cb-84e1-c52f1e5a1cfc": {
      "main": [
        [
          {
            "node": "f14d7155-0e5c-406b-9723-53ba805465f1",
            "type": "main",
            "index": 0
          },
          {
            "node": "bc270132-a495-4a9a-90c5-934f983780a7",
            "type": "main",
            "index": 0
          },
          {
            "node": "3b550e06-6309-4f04-a206-7294402593e3",
            "type": "main",
            "index": 0
          },
          {
            "node": "bdd0ff43-2844-4925-b973-6cd874f167a1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "989164aa-eece-4c7e-bcf2-b2217315f4f4": {
      "main": [
        [
          {
            "node": "d2715036-0d78-47cb-84e1-c52f1e5a1cfc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9813b1fa-3095-4b52-8f74-f2ae38fb31d4": {
      "main": [
        [
          {
            "node": "28d2c1ce-3f68-4787-ac9b-a8d7a8a0139b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8b5c6c01-e634-4279-bfc7-10aa302e1239": {
      "main": [
        [
          {
            "node": "11b1c80d-ecf6-444f-a5b9-0158d3aa5b1c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f14d7155-0e5c-406b-9723-53ba805465f1": {
      "main": [
        [
          {
            "node": "90c27fd1-a826-4713-a8f6-ad3ba1d235df",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "132df91a-b498-4e48-9551-4f3ab1f2d4ee": {
      "main": [
        [
          {
            "node": "8b5c6c01-e634-4279-bfc7-10aa302e1239",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "f670c98c-040f-4740-b04a-9b9c5412d5ed": {
      "main": [
        [
          {
            "node": "d09e3d54-5f14-4fbd-8c97-ccd4dd972db5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "792d5926-e700-4d60-8710-6a36ee0480af": {
      "main": [
        [
          {
            "node": "8b5c6c01-e634-4279-bfc7-10aa302e1239",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3b550e06-6309-4f04-a206-7294402593e3": {
      "main": [
        [
          {
            "node": "dc0f316e-5c09-48e8-a680-58fcefb9e9b0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bc270132-a495-4a9a-90c5-934f983780a7": {
      "main": [
        [
          {
            "node": "420a7697-9548-4bd4-9756-f455f6c80766",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "90c27fd1-a826-4713-a8f6-ad3ba1d235df": {
      "main": [
        [
          {
            "node": "95cd9852-11e6-4ca8-9f93-5dd5b3bdfe5d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "420a7697-9548-4bd4-9756-f455f6c80766": {
      "main": [
        [
          {
            "node": "95cd9852-11e6-4ca8-9f93-5dd5b3bdfe5d",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "bdd0ff43-2844-4925-b973-6cd874f167a1": {
      "main": [
        [
          {
            "node": "d38f399e-7d94-4888-b4a4-b62776eac1e1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dc0f316e-5c09-48e8-a680-58fcefb9e9b0": {
      "main": [
        [
          {
            "node": "afceb5d0-b0d1-435e-8280-08d9e9d4f932",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d38f399e-7d94-4888-b4a4-b62776eac1e1": {
      "main": [
        [
          {
            "node": "afceb5d0-b0d1-435e-8280-08d9e9d4f932",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "95cd9852-11e6-4ca8-9f93-5dd5b3bdfe5d": {
      "main": [
        [
          {
            "node": "982dc6ef-130f-4d09-affb-a5fb225f73fb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "11b1c80d-ecf6-444f-a5b9-0158d3aa5b1c": {
      "main": [
        [
          {
            "node": "9813b1fa-3095-4b52-8f74-f2ae38fb31d4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "afceb5d0-b0d1-435e-8280-08d9e9d4f932": {
      "main": [
        [
          {
            "node": "132df91a-b498-4e48-9551-4f3ab1f2d4ee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
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 - CRM

¿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 nodos26
Categoría1
Tipos de nodos11
Descripción de la dificultad

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

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34