Automatisierter QuickBooks-Verkaufsabweichungsdetektor (mit professioneller E-Mail-Erinnerung) (In Prüfung)

Experte

Dies ist ein CRM-Bereich Automatisierungsworkflow mit 26 Nodes. Hauptsächlich werden If, Set, Code, Merge, Filter und andere Nodes verwendet. Automatisierter QuickBooks-Verkäufe-Anomalie-Detektor mit professionellen E-Mail-Erinnerungen

Voraussetzungen
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "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": "Datumsbereich_erstellen",
      "type": "n8n-nodes-base.set",
      "position": [
        -656,
        288
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "f14d7155-0e5c-406b-9723-53ba805465f1",
      "name": "30-Tage-Rechnungen_abrufen",
      "type": "n8n-nodes-base.quickbooks",
      "position": [
        -432,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "90c27fd1-a826-4713-a8f6-ad3ba1d235df",
      "name": "Bezahlte_30-Tage-Rechnungen_filtern",
      "type": "n8n-nodes-base.filter",
      "position": [
        -144,
        0
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "bc270132-a495-4a9a-90c5-934f983780a7",
      "name": "30-Tage-Verkaufsbelege_abrufen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -432,
        192
      ],
      "parameters": {},
      "typeVersion": 4.3
    },
    {
      "id": "982dc6ef-130f-4d09-affb-a5fb225f73fb",
      "name": "30-Tage-Gesamtbeträge_summieren",
      "type": "n8n-nodes-base.summarize",
      "position": [
        368,
        96
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "792d5926-e700-4d60-8710-6a36ee0480af",
      "name": "30-Tage-Durchschnitt_berechnen",
      "type": "n8n-nodes-base.set",
      "position": [
        592,
        96
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "9813b1fa-3095-4b52-8f74-f2ae38fb31d4",
      "name": "Abweichung_berechnen",
      "type": "n8n-nodes-base.set",
      "position": [
        1264,
        288
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "28d2c1ce-3f68-4787-ac9b-a8d7a8a0139b",
      "name": "Auf_Anomalie_prüfen",
      "type": "n8n-nodes-base.if",
      "position": [
        1568,
        288
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f670c98c-040f-4740-b04a-9b9c5412d5ed",
      "name": "E-Mail-Inhalt_vorbereiten",
      "type": "n8n-nodes-base.set",
      "position": [
        1920,
        288
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "d09e3d54-5f14-4fbd-8c97-ccd4dd972db5",
      "name": "Warn-E-Mail_senden",
      "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": "Gestrigen_Rechnungen_abrufen",
      "type": "n8n-nodes-base.quickbooks",
      "position": [
        -432,
        384
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bdd0ff43-2844-4925-b973-6cd874f167a1",
      "name": "Gestrigen_Verkaufsbelege_abrufen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -432,
        576
      ],
      "parameters": {},
      "typeVersion": 4.3
    },
    {
      "id": "dc0f316e-5c09-48e8-a680-58fcefb9e9b0",
      "name": "Bezahlte_gestrige_Rechnungen_filtern",
      "type": "n8n-nodes-base.filter",
      "position": [
        -144,
        384
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "420a7697-9548-4bd4-9756-f455f6c80766",
      "name": "30-Tage-Verkaufsbelege_gesamt",
      "type": "n8n-nodes-base.code",
      "position": [
        -144,
        192
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "95cd9852-11e6-4ca8-9f93-5dd5b3bdfe5d",
      "name": "30-Tage_Rechnungen_Verkaufsbelege_zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        144,
        96
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "afceb5d0-b0d1-435e-8280-08d9e9d4f932",
      "name": "Gestrige_Rechnungen_Verkaufsbelege_zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        144,
        480
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "132df91a-b498-4e48-9551-4f3ab1f2d4ee",
      "name": "Gestrige_Gesamtbeträge_summieren",
      "type": "n8n-nodes-base.summarize",
      "position": [
        368,
        480
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "11b1c80d-ecf6-444f-a5b9-0158d3aa5b1c",
      "name": "Gesamte_Rechnungen_Verkaufsbelege_kombinieren",
      "type": "n8n-nodes-base.code",
      "position": [
        1040,
        288
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "989164aa-eece-4c7e-bcf2-b2217315f4f4",
      "name": "Jeden_Morgen_ausführen",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -880,
        288
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "d38f399e-7d94-4888-b4a4-b62776eac1e1",
      "name": "Gestrige_Verkaufsbelege_extrahieren",
      "type": "n8n-nodes-base.code",
      "position": [
        -144,
        576
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "8b5c6c01-e634-4279-bfc7-10aa302e1239",
      "name": "Endgültige_Gesamtbeträge_kombinieren",
      "type": "n8n-nodes-base.merge",
      "position": [
        816,
        288
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "c1d915d4-ab91-4286-b69d-1387fdd49bdb",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2256,
        -160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "992f43e4-9c63-45e6-8494-e9f8e45b7dc5",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -976,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b6c86e28-2007-4391-9f05-be4ae843ffed",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        -160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "63f83511-8da5-48db-bb9c-3af22c749dfe",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1456,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c467e9e5-4df1-482f-a102-c52e4ee16f0f",
      "name": "Haftnotiz4",
      "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
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Experte - Kundenbeziehungsmanagement

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes26
Kategorie1
Node-Typen11
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34