Automate HS Code Lookup & Enrichment with Google Sheets & Customs API

This workflow streamlines customs tariff code (HS Code) lookup and data enrichment for international shipments. It reads product descriptions from a Google Sheet, queries the Customs API for the best-matching HS codes, and updates the sheet with tariff numbers, confidence scores (70-100%), and descriptions for verification. A beta version with recent enhancements for better accuracy assessment.

Key features include bulk processing for entire product lists via Manual Trigger and instant single lookups through the Chat Trigger, eliminating manual copy-pasting and errors. Upon completion, it sends a Gmail notification. Ideal for accounting, logistics, and e-commerce teams handling exports.

Benefits: Saves hours weekly on tariff research, reduces errors in shipments, supports compliance with customs regulations. Use cases: Enriching product catalogs for global trade, verifying codes before invoicing, or quick ad-hoc queries during sales processes. Requires API key from zolltarifnummern.de and Google Sheets setup with ProductDescription and HS Code columns.