The Scenario
Your company is migrating to tax-inclusive pricing across all markets. Before you can update the pricing model, you need to know the correct VAT or sales tax rate for every customer. Your billing manager has 300 customer rows in a Google Sheet — column A is ISO country code, column B is postal code or region — and the new prices have to be set before the quarter rolls over.
The bad version:
- Open Quaderno's tax calculator, enter the first country code and region, note the rate percentage and the tax name, switch back to the sheet, paste both values into columns C and D
- Realize Quaderno's UI shows the rate as a decimal but your formula expects a percentage, so you have to convert each one as you go
- Hit row 50 and discover that three rows have country codes that don't match any Quaderno jurisdiction, which you only catch because the result field stays blank
You're supposed to be driving the pricing migration, not manually routing tax lookups through a compliance tool. The deadline for the new prices is not flexible.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the data and talks to Quaderno's tax calculation endpoint for you.
For each row, use the country code in column A and region in column B to look up the applicable Quaderno tax rate and write the rate percentage and tax name into columns C and D
What You Get
- Quaderno's tax rate for each country/region combination resolves and lands in columns C and D
- The rate is written as a percentage (e.g., 20 for 20% VAT) so your existing formulas work without conversion
- Rows where the jurisdiction combination returns no result get flagged in column E so you can follow up
- The entire 300-row column resolves in one operation without any UI interaction on your part
What If the Data Is Not Quite Ready
Some rows have only a country code — no region or postal code
For rows in the Tax Rates tab where column B is blank, look up the standard Quaderno tax rate for the country in column A only and write the rate to column C, note No Region in column D
The country codes are spelled out as full country names, not ISO codes
In the Tax Rates tab, the values in column A are full country names (e.g., Germany, France). Convert each to an ISO country code, then look up the Quaderno tax rate for that country and region in column B, write the ISO code to column A, rate to column C, tax name to column D
I need the breakdown by tax type — VAT versus sales tax — not just the rate
For each row in the Tax Rates tab, look up the applicable Quaderno tax rate for country in A and region in B, write the rate to column C, the tax type (VAT, GST, Sales Tax, etc.) to column D, and the jurisdiction name to column E
Resolve all rates, flag any anomalies, and add a pricing column in one shot
For each row in the Tax Rates tab: look up the Quaderno tax rate for country in A and region in B, write the rate to C and tax name to D; if the rate is above 25%, write High Rate to column E; then calculate the tax-inclusive price by multiplying column F (base price) by (1 + C/100) and write the result to column G
Combining the lookup, the flag, and the derived calculation in one prompt means you get a ready-to-use pricing column without an intermediate cleanup step.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your customer addresses or market data live, then ask it to resolve the tax rates for all rows using Quaderno. Also see: bulk-validating customer tax IDs from a sheet, and the hub overview of all Quaderno connection methods.