AutomationMart
Home/Browse/Automate HS code lookup & enrichment with Google Sheets and customs API (beta)
n8n

Automate HS code lookup & enrichment with Google Sheets and customs API (beta)

n8nn8n11 modulesv1.0
GmailGoogle Sheets

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 automatically finds customs tariff numbers (also known as HS Codes or "Zolltarifnummern") for your products and enriches your data in Google Sheets. It offers two powerful modes: bulk processing for entire product lists and an on-demand chat

At a glance

Automate HS code lookup & enrichment with Google Sheets and customs API (beta) is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets
Modules
11
Price
Free
Version
v1.0
Automate HS code lookup & enrichment with Google Sheets and customs API (beta) workflow diagram

About this workflow

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 automatically finds customs tariff numbers (also known as HS Codes or "Zolltarifnummern") for your products and enriches your data in Google Sheets. It offers two powerful modes: bulk processing for entire product lists and an on-demand chat interface for quick single lookups. new features - added the API score in percentage (80 to 100% is perfect, 70-80% still good) - added description of the found HS Code to better verify the accuracy -please keep in mind, that is still a beta What this workflow does - Bulk Enrichment from Google Sheets: Reads a list of product descriptions from a specified Google Sheet. - External API Lookup: For each product, it queries the zolltarifnummern.de API to find the most relevant customs tariff number. - Automated Data Update: Writes the found tariff numbers back into the correct row in your Google Sheet. - On-Demand Single Lookup: Use the integrated Chat Trigger to instantly look up a tariff number for a single product description without leaving n8n. - Completion Notification: Sends a confirmation email via Gmail once the bulk processing job is finished. Nodes Used 1. Google Sheets 2. HTTP Request 3. Loop Over Items (Split in Batches) 4. Set 5. Gmail 6. Chat Trigger 7. Manual Trigger Preparation A Google Sheet prepared with at least two columns: one for your product descriptions (e.g., ProductDescription) and an empty one for the results (e.g., TariffCode). How to set up this workflow Configure Google Sheets (Read): Open the "Read Item Descriptions" node. Select your Google Sheets credentials. Enter your Spreadsheet ID and the name of the sheet containing your product data. Make sure the "Columns to Read" field includes the name of your product description column. Configure Google Sheets (Update): Open the "Write Customs Tariff to Sheet" node. Select the same Google Sheets credentials. Enter the same Spreadsheet ID and Sheet Name. Under Columns, set Matching Columns to your product description column name. This is crucial for updating the correct rows. Configure Email Notification: Open the "Send Completion Email" (Gmail) node. Select your Gmail credentials. In the Send To field, enter the email address where you want to receive the completion notification. Run the Workflow: For Bulk Processing: Activate the workflow and execute the "Abfrage starten" (Start Query) Manual Trigger. For a Single Lookup: Use the Chat Trigger. Open the chat pane, type a product description, and hit send. The workflow will return the suggested tariff number.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Find the best food deals automatically with Bright Data & n8n

Description This workflow automatically scans food delivery platforms and restaurant websites to find the best deals and discounts. It helps you save money on meals by aggregating special offers and promotions in one place. Overview This workflow automates finding the best food deals and discounts from various websites. It uses Bright Data to scrape deal information and can be configured to send you notifications or save the deals to a spreadsheet. Tools Used n8n: The automation platform that o

Free

Send a Telegram message with data from Google Sheets cell

Automatically send a Telegram message with specific data from a Google Sheets cell. Ideal for instant updates or notifications directly from your spreadsheet.

Free

Automate Gmail inbox organization with rule-based categorization and smart actions

How it works: The organizer continuously monitors your Gmail inbox. It analyzes sender and subject to categorize emails (Work, Purchases, Newsletter) and automatically applies labels. Based on the category, it performs specific actions, such as marking important emails or archiving newsletters. - Set up steps: The initial setup requires Gmail access permission and defining the categorization rules and desired actions for each email type. This process can be configured in approximately 5 to 10 mi

Free

Automate social media posts with AI content and images across Twitter, LinkedIn & Facebook

Auto-generate & post content using AI This workflow helps you create daily content using just a topic prompt. It writes a tweet, generates an image, and publishes across Twitter, Facebook, and LinkedIn — all on autopilot. --- How it works - Triggers daily at 10 PM to start the flow - Uses OpenAI to generate a niche topic title - Writes a short-form post (tweet style) with hashtags - Generates a Japanese anime-style image for visual context - Saves everything in Google Sheets

Free

Analyze images & PDFs from Google Drive with Gemini 3 AI

Gemini 3 Image & PDF Extractor (Google Drive → Gemini 3 → Summary) Automatically summarize newly uploaded images or PDF reports using Google Gemini 3, triggered directly from a Google Drive folder. Perfect for anyone who needs fast AI-powered analysis of financial reports, charts, screenshots, or scanned documents. 🎥 Watch the full step-by-step video tutorial: What this template does This workflow watches a Google Drive folder for new files and automatically: 1. Detects new uploaded files - Uses

Free

Automate bug reports with Gemini AI: Jotform to GitHub with Telegram alerts

Execution video: This workflow automates the process of handling bug reports submitted through a form, from checking for duplicates on GitHub to logging the report and sending a notification. --- 1. A Bug is Reported 🐛 Trigger: The entire process kicks off when a user submits a bug report through a JotForm. This form collects the user's name, email, and a description of the bug. --- 2. The AI Agent Gets to Work 🤖 Action: The submitted bug description is sent to an AI Agent powered by Google G

Free

Extract and organize receipt data for expense tracking with VLM Run and Google

Transform your expense tracking with automated AI receipt processing that extracts data and organizes it instantly. What this workflow does 1. Monitors Google Drive for new receipt uploads (images/PDFs) 2. Downloads and processes files automatically 3. Extracts key data using verified VLM Run node (merchant, amount, currency, date) 4. Saves structured data to Google Sheets for easy tracking Setup Prerequisites: Google Drive/Sheets accounts, VLM Run API credentials, n8n instance. Install the ver

Free

Unify multiple triggers into a single workflow

Stop duplicating your work! This template demonstrates a powerful design pattern to handle multiple triggers (e.g., Form, Webhook, Sub-workflow) within a single, unified workflow. By using a "normalize and consolidate" technique, your core logic becomes independent of the trigger that started it, making your automations cleaner, more scalable, and far easier to maintain. Who is this for? n8n developers & architects: Build robust, enterprise-grade workflows that are easy to maintain. Automatio

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free