Automate HS code lookup & enrichment with Google Sheets and customs API (beta)
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs when a chat message arrives (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When a chat message arrives (plus 1 other trigger).
- Customs Tariff API Query (HTTP Request): calls an HTTP API
- Read Item Descriptions (Google Sheets): uses Google Sheets
- Output Customs Tariff Number (Edit Fields (Set)): sets 1 field: text
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Aggregate: combines items into one
- Customs Tariff API Query Batch (HTTP Request): calls an HTTP API
- Send Completion Email (Gmail): uses Gmail
- prepare data (Edit Fields (Set)): sets 4 fields: Zolltarifnummer, Artikelbeschreibung, Beschreibung der Zolltarifnummer…
- Write Customs Tariff to Sheet (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail - Aggregate
n8n-nodes-base.aggregate - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
"I used to spend hours every week just copy-pasting product descriptions to find the right tariff codes for our international shipments. It was tedious and prone to errors." - Accounting specialist. This workflow eliminates that manual work entirely. It…