My workflow 4

Avancé

Ceci est unDocument Extraction, AI Summarizationworkflow d'automatisation du domainecontenant 25 nœuds.Utilise principalement des nœuds comme Set, Code, Merge, Switch, Webhook. Automatisation des journaux comptables SAP B1 avec JSON, Google Sheets et GPT-4o

Prérequis
  • Point de terminaison HTTP Webhook (généré automatiquement par n8n)
  • Peut nécessiter les informations d'identification d'authentification de l'API cible
  • Informations d'identification Google Sheets API
  • Clé API OpenAI
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1820,
        720
      ],
      "webhookId": "991024c1-f7fc-4515-99ef-2b53df96f8cb",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a85066bb-91fa-4e1f-bb09-d7164165b2f6",
      "name": "Connexion SAP",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1580,
        720
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "a53020c0-c167-4cf1-9597-95b07d7b87cd",
      "name": "Router par source",
      "type": "n8n-nodes-base.switch",
      "position": [
        -1300,
        720
      ],
      "parameters": {},
      "typeVersion": 3.2,
      "alwaysOutputData": false
    },
    {
      "id": "08c6fdef-b4e9-4f82-8080-7f8d06ba4336",
      "name": "Mapper les champs JSON",
      "type": "n8n-nodes-base.set",
      "position": [
        -720,
        480
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "ff7679dd-811c-4b83-9e35-f61c4a6ac2b2",
      "name": "Poster écriture (JSON)",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        -480,
        480
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "838b28c5-1ccb-40bc-9e07-88569e11287f",
      "name": "Journal succès (JSON)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -240,
        320
      ],
      "parameters": {},
      "typeVersion": 4.6,
      "alwaysOutputData": false
    },
    {
      "id": "1900cd98-9b64-41f7-af03-68018376e6da",
      "name": "Journal erreur (JSON)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -240,
        540
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "a9d367d5-cef4-40d8-8d13-dc0da04e424a",
      "name": "Transformation LLM (Manuel)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -780,
        1500
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "41f1f35e-a4b2-4510-8910-8b1742df417f",
      "name": "Poster écriture (Manuel)",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        -380,
        1500
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "2c445e36-67b3-44c1-912d-1225ab4d5077",
      "name": "Journal succès (Manuel)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -100,
        1360
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "42d94e4b-0a1d-482a-88bb-5397129dd29a",
      "name": "Journal erreur (Manuel)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -100,
        1580
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "fab58a6e-27c7-4021-9183-065d40f25e7d",
      "name": "Définir données SAP",
      "type": "n8n-nodes-base.set",
      "position": [
        -740,
        980
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "980fa23f-1850-4594-9e92-6aea0a6e62bb",
      "name": "Charger données feuille",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -480,
        1100
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "d83ac837-292a-4a5c-b537-e89d3671c23c",
      "name": "Structurer lignes feuille",
      "type": "n8n-nodes-base.set",
      "position": [
        -220,
        1100
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "532419b3-33fe-4b6d-8ec0-6db03126faa1",
      "name": "Analyser JSON feuille",
      "type": "n8n-nodes-base.code",
      "position": [
        20,
        1100
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "aa35f48c-7aee-4b57-85bc-1acaaace7324",
      "name": "Transformation LLM (Feuille)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        240,
        1100
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "0fda167e-545f-4b3d-ae86-366ca46f83c1",
      "name": "Construire corps écriture",
      "type": "n8n-nodes-base.set",
      "position": [
        580,
        1100
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
      "name": "Fusionner en-tête & lignes",
      "type": "n8n-nodes-base.merge",
      "position": [
        780,
        960
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "2ea523f5-16b4-4fa7-96e1-d3f0fd415d8c",
      "name": "Poster écriture (Feuille)",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        980,
        960
      ],
      "parameters": {},
      "typeVersion": 4.2,
      "alwaysOutputData": false
    },
    {
      "id": "470caa25-52dd-424e-a000-d07ebabcb6e5",
      "name": "Journal succès (Feuille)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        800
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "a17b7dd8-747e-4b5b-9f2f-dadd607e8b3f",
      "name": "Journal erreur (Feuille)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        1020
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "12d5eb01-d326-4b35-b922-5bb148b32fc4",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1880,
        560
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a621ad9e-20e1-454d-acb9-1ce7376da82c",
      "name": "Note adhésive 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2230580e-5800-4dc0-96f4-276152c330f3",
      "name": "Note adhésive 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        760
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "94b1309f-5a8f-479e-a82b-6dea66f4cf17",
      "name": "Note adhésive 3",
      "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
          }
        ]
      ]
    },
    "fab58a6e-27c7-4021-9183-065d40f25e7d": {
      "main": [
        [
          {
            "node": "980fa23f-1850-4594-9e92-6aea0a6e62bb",
            "type": "main",
            "index": 0
          },
          {
            "node": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
            "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": "fab58a6e-27c7-4021-9183-065d40f25e7d",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "a9d367d5-cef4-40d8-8d13-dc0da04e424a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6f3055d0-2612-49e5-8b70-ade568596658": {
      "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": "2fbf56de-2d73-46bb-851a-174ff3eedb73",
            "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
          }
        ]
      ]
    },
    "2fbf56de-2d73-46bb-851a-174ff3eedb73": {
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Extraction de documents, Résumé IA

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds25
Catégorie2
Types de nœuds9
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34