"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.
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.
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.