Exchange currency

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…)

thankyou

  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…

thanks!

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

Does this app Currency Converter - Apps - Airtable Marketplace solve it?