Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Exchange currency

3760 4
Showing results for 
Search instead for 
Did you mean: 

Is any tips/hint for exchange from one currency to another ?

example is a sale of the same product in more currency around the world like $ (dollar) € (eur) £ (sterlin).
I like show the product value in only € (euro) and imput in table the product value sale around world with the sale currency ?
( like sho : on sale cookbook 25€ | but my input is : store in london 20£ | store in newyork is 22$ etc…etc…)


4 Replies 4
  1. Create an exchange table under google sheet

  2. Use googlefinance function to get exchange rate update (eg. =GoogleFinance(“CURRENCY:USDTWD” , “average”) … )

  3. Zapier to zap this record into airtable record.

Do you know what that zap in zapier would be?

I’ve been looking though and haven’t been able to figure out…


just tried to do it via Zapier. It seemed straightforward but then Zapier was buggy pulling the info from Google Sheets. gave up on this for now what a PITA