8
n8n Françaisamn8n.com

Recherche de numéros de douane V2

Intermédiaire

Ceci est unDocument Extraction, Multimodal AIworkflow d'automatisation du domainecontenant 14 nœuds.Utilise principalement des nœuds comme Set, Gmail, Aggregate, HttpRequest, GoogleSheets. Automatiser la recherche et l'enrichissement du code HS avec Google Sheets et une API douanière

Prérequis
  • •Compte Google et informations d'identification Gmail API
  • •Peut nécessiter les informations d'identification d'authentification de l'API cible
  • •Informations d'identification Google Sheets API

Nœuds utilisés (14)

Set
Gmail
Aggregate
StickyNote
HttpRequest
GoogleSheets
ManualTrigger
SplitInBatches
ChatTrigger

Catégorie

Extraction de documents
IA Multimodale
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "id": "LdR1WNr3yM5Lw9X8",
  "meta": {
    "instanceId": "509eaff0b96002e800c9adf0e9388b12a38c09e15983331392a1f621addc4db4"
  },
  "name": "Customs_Tariff_Number_Research V2",
  "tags": [],
  "nodes": [
    {
      "id": "ec7c3dd9-74ee-4008-b32c-da57d6069e30",
      "name": "Déclencheur de chat",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -336,
        336
      ],
      "webhookId": "170756e8-3be9-43f5-81ce-284e8cf78635",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "0f817acd-9c17-4756-90ba-ff1106edad53",
      "name": "Customs Tariff API Query",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -144,
        336
      ],
      "parameters": {
        "url": "=https://www.zolltarifnummern.de/api/v2/cnSuggest?term={{ encodeURIComponent($json.chatInput) }}&lang=de",
        "options": {
          "timeout": 10000,
          "response": {
            "response": {
              "responseFormat": "json"
            }
          },
          "allowUnauthorizedCerts": true
        },
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Accept",
              "value": "application/json"
            },
            {
              "name": "User-Agent",
              "value": "n8n-workflow/1.0"
            }
          ]
        }
      },
      "typeVersion": 4.2,
      "continueOnFail": true
    },
    {
      "id": "8d670dda-9b23-4542-bb8f-ce7074beac64",
      "name": "Output Customs Tariff Number",
      "type": "n8n-nodes-base.set",
      "position": [
        48,
        336
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "assignment-1",
              "name": "text",
              "type": "string",
              "value": "={{ $json.suggestions[1].code }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "9b92a873-ecb8-43cc-929f-9514bed35c5e",
      "name": "Read Item Descriptions",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        128,
        560
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs/edit?usp=drivesdk",
          "cachedResultName": "Customs Numbers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "axR2eMzXvoqKjDp2",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "f95221b2-9d6d-4dd2-bd22-7faab04341f9",
      "name": "Boucler sur les éléments",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        384,
        560
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "60ddfdb2-b326-4cae-bc20-10cf2631a6ae",
      "name": "Write Customs Tariff to Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        992,
        576
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Artikelbeschreibung",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Artikelbeschreibung",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Zolltarifnummer",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Zolltarifnummer",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [
            "Artikelbeschreibung"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs/edit?usp=drivesdk",
          "cachedResultName": "Customs Numbers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "axR2eMzXvoqKjDp2",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "9b5f275d-136a-4227-9a62-120bc32e0c0e",
      "name": "Customs Tariff API Query Batch",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        592,
        576
      ],
      "parameters": {
        "url": "=https://www.zolltarifnummern.de/api/v2/cnSuggest?term={{ encodeURIComponent($json['Artikelbeschreibung']) }}&lang=de",
        "options": {
          "timeout": 10000,
          "response": {
            "response": {
              "responseFormat": "json"
            }
          },
          "allowUnauthorizedCerts": true
        },
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Accept",
              "value": "application/json"
            },
            {
              "name": "User-Agent",
              "value": "n8n-workflow/1.0"
            }
          ]
        }
      },
      "typeVersion": 4.2,
      "continueOnFail": true
    },
    {
      "id": "653ef025-1c47-4115-94f3-867138e1f654",
      "name": "Send Completion E-mail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        784,
        352
      ],
      "webhookId": "efe6ce0f-0470-4be7-9056-af5752cf2798",
      "parameters": {
        "sendTo": "test@example.com",
        "message": "Job completed successfully",
        "options": {},
        "subject": "Completed: Customs Tariff Number Research Finished"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "a26hQ5L1HIRZTOqY",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "b02dc4a3-b4e0-4bb1-9d8a-112ac0301b87",
      "name": "Agréger",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        560,
        352
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "bb6f42bd-de6e-4adb-97d2-b89867709d5c",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        256
      ],
      "parameters": {
        "color": 6,
        "width": 640,
        "height": 256,
        "content": "## Manual Single Query for Customs Tariff Number\nEnter item description and receive suggestion #1 from the API query"
      },
      "typeVersion": 1
    },
    {
      "id": "6229ef15-b823-48f2-82bb-f81d07f7f976",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        528
      ],
      "parameters": {
        "width": 1552,
        "height": 256,
        "content": "## Batch Query from List\nAll entries in column A \nwill be enriched with customs \ntariff numbers in column B\n(select Google Sheet and tab)"
      },
      "typeVersion": 1
    },
    {
      "id": "7c9e9844-9995-41d6-9ec2-db4a3af10160",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 896,
        "height": 256,
        "content": "## Completion\nNotification email that process \nis finished (configure desired email address)"
      },
      "typeVersion": 1
    },
    {
      "id": "18289af3-a07a-46ef-abed-10d4bc6aec29",
      "name": "Début Query",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -48,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "31ef430b-a463-4742-bf36-57509464a684",
      "name": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        256
      ],
      "parameters": {
        "color": 3,
        "width": 416,
        "height": 256,
        "content": "### [Video Tutorial](https://youtu.be/UccIqmMmq7w)\n@[youtube](UccIqmMmq7w)"
      },
      "typeVersion": 1
    },
    {
      "id": "18d3e9ef-6168-482f-bcd7-d05ae1789975",
      "name": "prepare data",
      "type": "n8n-nodes-base.set",
      "position": [
        800,
        576
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "assignment-1",
              "name": "Zolltarifnummer",
              "type": "string",
              "value": "={{ $json.suggestions && $json.suggestions[1] ? $json.suggestions[1].code : 'Nicht gefunden' }}"
            },
            {
              "id": "assignment-3",
              "name": "Artikelbeschreibung",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json['Artikelbeschreibung'] }}"
            },
            {
              "id": "bb2fbbce-b66b-42b6-a639-baa949b763e8",
              "name": "Beschreibung der Zolltarifnummer",
              "type": "string",
              "value": "={{ $json.suggestions[1].value.split(/<br\\s*\\/?>/i)[1].trim() }}"
            },
            {
              "id": "f4389d75-a1f3-4ccd-9a62-0f7544923e02",
              "name": "Score",
              "type": "string",
              "value": "={{ ($json.suggestions[1].score * 100).toFixed(1) + '%' }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "7e35bde7-5057-41a1-a1a9-e332db984cff",
  "connections": {
    "Aggregate": {
      "main": [
        [
          {
            "node": "Send Completion Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start Query": {
      "main": [
        [
          {
            "node": "9b92a873-ecb8-43cc-929f-9514bed35c5e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Chat Trigger": {
      "main": [
        [
          {
            "node": "0f817acd-9c17-4756-90ba-ff1106edad53",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "18d3e9ef-6168-482f-bcd7-d05ae1789975": {
      "main": [
        [
          {
            "node": "60ddfdb2-b326-4cae-bc20-10cf2631a6ae",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "9b5f275d-136a-4227-9a62-120bc32e0c0e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9b92a873-ecb8-43cc-929f-9514bed35c5e": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0f817acd-9c17-4756-90ba-ff1106edad53": {
      "main": [
        [
          {
            "node": "8d670dda-9b23-4542-bb8f-ce7074beac64",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "60ddfdb2-b326-4cae-bc20-10cf2631a6ae": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9b5f275d-136a-4227-9a62-120bc32e0c0e": {
      "main": [
        [
          {
            "node": "18d3e9ef-6168-482f-bcd7-d05ae1789975",
            "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é ?

Intermédiaire - Extraction de documents, IA Multimodale

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.

Workflows recommandés

AI-Deepseek-R1t Approbation des déplacements pour réunions et demande d'autorisation de dépenses
Automatisation de l'approbation des voyages et des réunions avec Deepseek AI, Gmail et Google Sheets
If
Set
Code
+
If
Set
Code
24 NœudsCheng Siong Chin
Extraction de documents
Génération d'e-mails de vente personnalisés à partir de données LinkedIn via Claude 3.5 Sonnet et OpenRouter
Basé sur les données LinkedIn, utiliser OpenRouter avec Claude 3.7 pour générer des e-mails de vente personnalisés
If
Set
Gmail
+
If
Set
Gmail
23 NœudsAdam Janes
Nurturing de leads
PDF vers commande
Utiliser l'IA pour automatiser la conversion des commandes d'achat PDF en commandes de vente Adobe Commerce
If
Set
Code
+
If
Set
Code
96 NœudsJKingma
Extraction de documents
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
Automatisation de la configuration de projet agile avec GPT-5 Mini, Jira et une interface de formulaire
Utiliser GPT-5 Mini, Jira et une interface de formulaire pour automatiser la configuration de projets Agile
Set
Jira
Gmail
+
Set
Jira
Gmail
42 NœudsBilly Christi
IA Multimodale
Reclassement #1
Automatisation du marketing téléphonique avec le web scraping, GPT-4o et WhatsApp
Set
Code
Webhook
+
Set
Code
Webhook
48 NœudsKhaisa Studio
Nurturing de leads
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds14
Catégorie2
Types de nœuds9
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
Thomas

Thomas

@thomas-z
Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34