While Airtable doesn’t support direct API calls in automations, there’s a clever workaround using Integromat (now Make). I’ve implemented this solution for a client recently.
Set up a scenario in Integromat that fetches currency rates from a reliable API (like Alpha Vantage or Fixer.io) on a daily schedule. Configure it to update a dedicated ‘Exchange Rates’ table in your Airtable base.
Then, create an Airtable automation that triggers when the ‘Exchange Rates’ table is updated. This automation can perform your desired calculations using the latest rates.
This method maintains data integrity within Airtable and allows for more complex operations if needed. Just ensure you’re within the API’s usage limits for your chosen provider.