US tariff formulas for Google Sheets
Keep your landed-cost sheet, and put the US duty in it from the Zentria Flow tariff engine: =ZF_DUTY("6109.10.00", "China") returns the total rate, with every layer and the next scheduled change a formula away. Free, no account, no key.
Add it to a sheet (2 minutes)
- Open your Google Sheet, then Extensions, then Apps Script.
- Delete what is in the editor, paste the script and click Save.
- Go back to the sheet and type
=ZF_DUTY("6109.10.00", "CN")in a cell.
The script only reads the HTS codes and origins you pass to it and calls zentriaflow.com; it does not read or change anything else in your file. Open source (MIT).
The functions
ZF_DUTY
=ZF_DUTY("6109.10.00", "China")The total US duty rate in percent for an HTS code and country of origin (ISO code like CN, or an English name). A third argument, an entry date as YYYY-MM-DD up to 12 months ahead, gives the rate on that date.
ZF_LAYERS
=ZF_LAYERS(A2, B2)One row of five rates: MFN duty, China Section 301, the forced-labor Section 301 tariff, Section 232 and Section 338 on Canada.
ZF_NEXT_CHANGE
=ZF_NEXT_CHANGE(A2, B2)The date of the next scheduled change to the duty on that product, and the total rate after it. "None scheduled" when the engine has none in the next 12 months.
ZF_DESCRIPTION
=ZF_DESCRIPTION(A2)The official HTSUS description of the line, to check the code is the one you meant.
ZF_HTS_SEARCH
=ZF_HTS_SEARCH("steel cookware")Candidate 8-digit HTSUS lines for product words, code and description, one per row. A candidate, not a classification ruling.
Example, checked 20 Nov 2026: Rail-car air brake parts (HTS 8607.21.10) from China. =ZF_DUTY gives 16.1% today, and =ZF_NEXT_CHANGE shows 10 Jan 2027 and 41.1%, when a Section 301 exclusion ends unless it is extended again.
Limits
- Google's servers make the calls for every Sheets user, so all Sheets users share 300 tariff checks and 1,500 searches an hour. When they are used up, the cell says "Busy" and shows no rate.
- Each answer is kept for 6 hours, so a sheet that recalculates does not use the allowance again.
- For a whole product list at once, with every change scheduled for it and the dollar difference, use the bulk tariff check.
- Answers are planning estimates, not customs rulings. Anti-dumping and countervailing duties are not in any total. Confirm classification and rates with a licensed customs broker before entry.
Prefer an AI assistant? Use Zentria Flow in Claude. Building your own integration? See the developer hub.