Mein Workflow 4

Experte

Dies ist ein Document Extraction, AI Summarization-Bereich Automatisierungsworkflow mit 25 Nodes. Hauptsächlich werden Set, Code, Merge, Switch, Webhook und andere Nodes verwendet. Automatisierung von SAP B1-Tagebuchbuchungen mit JSON, Google Sheets und GPT-4o

Voraussetzungen
  • HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • Google Sheets API-Anmeldedaten
  • OpenAI API Key
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": "6f68qrMxAD14jS4i",
  "meta": {
    "instanceId": "558d88703fb65b2d0e44613bc35916258b0f0bf983c5d4730c00c424b77ca36a"
  },
  "name": "My workflow 4",
  "tags": [
    {
      "id": "GvklsLWXMBUjgBiK",
      "name": "SAPB1-2=Finanzas",
      "createdAt": "2025-07-03T12:55:09.224Z",
      "updatedAt": "2025-07-03T12:55:09.224Z"
    }
  ],
  "nodes": [
    {
      "id": "6f3055d0-2612-49e5-8b70-ade568596658",
      "name": "Webhook-Trigger Trigger",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1820,
        720
      ],
      "webhookId": "991024c1-f7fc-4515-99ef-2b53df96f8cb",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a85066bb-91fa-4e1f-bb09-d7164165b2f6",
      "name": "SAP Login",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1580,
        720
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "a53020c0-c167-4cf1-9597-95b07d7b87cd",
      "name": "Route by Source",
      "type": "n8n-nodes-base.switch",
      "position": [
        -1300,
        720
      ],
      "parameters": {},
      "typeVersion": 3.2,
      "alwaysOutputData": false
    },
    {
      "id": "08c6fdef-b4e9-4f82-8080-7f8d06ba4336",
      "name": "Map JSON Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -720,
        480
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "ff7679dd-811c-4b83-9e35-f61c4a6ac2b2",
      "name": "Post Journal (JSON)",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        -480,
        480
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "838b28c5-1ccb-40bc-9e07-88569e11287f",
      "name": "Log Success (JSON)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -240,
        320
      ],
      "parameters": {},
      "typeVersion": 4.6,
      "alwaysOutputData": false
    },
    {
      "id": "1900cd98-9b64-41f7-af03-68018376e6da",
      "name": "Log Error (JSON)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -240,
        540
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "a9d367d5-cef4-40d8-8d13-dc0da04e424a",
      "name": "LLM Transform (Manual)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -780,
        1500
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "41f1f35e-a4b2-4510-8910-8b1742df417f",
      "name": "Post Journal (Manual)",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        -380,
        1500
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "2c445e36-67b3-44c1-912d-1225ab4d5077",
      "name": "Log Success (Manual)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -100,
        1360
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "42d94e4b-0a1d-482a-88bb-5397129dd29a",
      "name": "Log Error (Manual)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -100,
        1580
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "fab58a6e-27c7-4021-9183-065d40f25e7d",
      "name": "Setzen SAP Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -740,
        980
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "980fa23f-1850-4594-9e92-6aea0a6e62bb",
      "name": "Load Sheet Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -480,
        1100
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "d83ac837-292a-4a5c-b537-e89d3671c23c",
      "name": "Shape Sheet Lines",
      "type": "n8n-nodes-base.set",
      "position": [
        -220,
        1100
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "532419b3-33fe-4b6d-8ec0-6db03126faa1",
      "name": "Parse Sheet JSON",
      "type": "n8n-nodes-base.code",
      "position": [
        20,
        1100
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "aa35f48c-7aee-4b57-85bc-1acaaace7324",
      "name": "LLM Transform (Sheet)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        240,
        1100
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "0fda167e-545f-4b3d-ae86-366ca46f83c1",
      "name": "Build Journal Body",
      "type": "n8n-nodes-base.set",
      "position": [
        580,
        1100
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
      "name": "Zusammenführen Header & Lines",
      "type": "n8n-nodes-base.merge",
      "position": [
        780,
        960
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c",
      "name": "Post Journal (Sheet)",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        980,
        960
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "470caa25-52dd-424e-a000-d07ebabcb6e5",
      "name": "Log Success (Sheet)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        800
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "a17b7dd8-747e-4b5b-9f2f-dadd607e8b3f",
      "name": "Log Error (Sheet)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        1020
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "12d5eb01-d326-4b35-b922-5bb148b32fc4",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1880,
        560
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a621ad9e-20e1-454d-acb9-1ce7376da82c",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2230580e-5800-4dc0-96f4-276152c330f3",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        760
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "94b1309f-5a8f-479e-a82b-6dea66f4cf17",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        1320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a7b337d9-989c-45b5-bb73-457c480ce81c",
  "connections": {
    "a85066bb-91fa-4e1f-bb09-d7164165b2f6": {
      "main": [
        [
          {
            "node": "a53020c0-c167-4cf1-9597-95b07d7b87cd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set SAP Data": {
      "main": [
        [
          {
            "node": "980fa23f-1850-4594-9e92-6aea0a6e62bb",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge Header & Lines",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "980fa23f-1850-4594-9e92-6aea0a6e62bb": {
      "main": [
        [
          {
            "node": "d83ac837-292a-4a5c-b537-e89d3671c23c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "08c6fdef-b4e9-4f82-8080-7f8d06ba4336": {
      "main": [
        [
          {
            "node": "ff7679dd-811c-4b83-9e35-f61c4a6ac2b2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a53020c0-c167-4cf1-9597-95b07d7b87cd": {
      "main": [
        [
          {
            "node": "08c6fdef-b4e9-4f82-8080-7f8d06ba4336",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Set SAP Data",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "a9d367d5-cef4-40d8-8d13-dc0da04e424a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook Trigger": {
      "main": [
        [
          {
            "node": "a85066bb-91fa-4e1f-bb09-d7164165b2f6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "532419b3-33fe-4b6d-8ec0-6db03126faa1": {
      "main": [
        [
          {
            "node": "aa35f48c-7aee-4b57-85bc-1acaaace7324",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d83ac837-292a-4a5c-b537-e89d3671c23c": {
      "main": [
        [
          {
            "node": "532419b3-33fe-4b6d-8ec0-6db03126faa1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0fda167e-545f-4b3d-ae86-366ca46f83c1": {
      "main": [
        [
          {
            "node": "Merge Header & Lines",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ff7679dd-811c-4b83-9e35-f61c4a6ac2b2": {
      "main": [
        [
          {
            "node": "838b28c5-1ccb-40bc-9e07-88569e11287f",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "1900cd98-9b64-41f7-af03-68018376e6da",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Header & Lines": {
      "main": [
        [
          {
            "node": "2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c": {
      "main": [
        [
          {
            "node": "470caa25-52dd-424e-a000-d07ebabcb6e5",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "a17b7dd8-747e-4b5b-9f2f-dadd607e8b3f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "aa35f48c-7aee-4b57-85bc-1acaaace7324": {
      "main": [
        [
          {
            "node": "0fda167e-545f-4b3d-ae86-366ca46f83c1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "41f1f35e-a4b2-4510-8910-8b1742df417f": {
      "main": [
        [
          {
            "node": "2c445e36-67b3-44c1-912d-1225ab4d5077",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "42d94e4b-0a1d-482a-88bb-5397129dd29a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a9d367d5-cef4-40d8-8d13-dc0da04e424a": {
      "main": [
        [
          {
            "node": "41f1f35e-a4b2-4510-8910-8b1742df417f",
            "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 - Dokumentenextraktion, KI-Zusammenfassung

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 Nodes25
Kategorie2
Node-Typen9
Schwierigkeitsbeschreibung

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

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34