How To Import Data into Airtable When a Record is Updated

Oct 17, 2023Rosie Threlfall

In this guide, we'll import data to Airtable whenever a record is updated, using the Data Fetcher extension. This allows us to have up-to-date data in our Airtable base at all times.

We'll import currency conversion data whenever a record is updated, but you can use the same approach to import stock prices, crypto prices, enrich leads or any other data using one of Data Fetcher's Airtable integrations.

This tutorial is 100% no-code. Let's get started!

Create Rates Table

Create a new table in your Airtable base called 'Rates'. Add a Single select field with the name 'Currency'.

Currency1.png

Add the names of any currencies you wish to convert into the 'Currency' field. This needs to be the standard currency abbreviation, e.g. BRL, GBP, EUR & CAD.

exchangerate15.png

Add Data Fetcher Extension

Next, add Data Fetcher to your base from the Airtable marketplace. This free extension enables you to import many different types of data into Airtable.

After you have added the Data Fetcher to your Airtable base, you'll need to create a free Data Fetcher account. You can also sign in to your existing account using the 'Have an account?' button on the bottom left of the Data Fetcher screen.

You can also sign up to Data Fetcher with your Google account by selecting 'Continue with Google'. 

Data Fetcher Sign Up

Import Exchange Rate Data to Airtable

Select 'Create your first request' from the Data Fetcher home screen. Data Fetcher requests are used to import and send data. You can create multiple saved requests within one installation of Data Fetcher in an Airtable base.

Create your first request in Data Fetcher

On the create request screen, select 'exchangerate.host' for Application.

exchangerate3.png

For Endpoint choose 'Convert from one currency to another'.

exchangerate4-endpoint.png

Give your request a name such as 'Import currency data' and click 'Save & Continue'.

exchangerate5.png

Add a reference to your output table by clicking on the + button on the right-hand side of the From currency field and selecting your 'Rates' table and 'Currency' field.

Click 'Confirm'.

exchangerate6.png


For To currency select the currency you wish to convert into. For this example, we are using USD.

exchangerate7.png

exchangerate8.png

The Response field mapping modal will now open. This is how you configure how the fields from exchangerate.host will map to fields in your output table. 

For each imported field, you can either map it to an existing field in your output table or create a new one. You can also set the field type for each new field.

Click filter all to remove any pre-selected fields, then use the Find field search bar to easily locate the fields you want to import.

For this example, we are going to import the Result field and map this to a new field with type Currency. Click on the field type dropdown to change it from a number field to a currency field. Then click 'Save & Run'.

exchange rate host result RFM.png

You will now see a new field in your output table called 'Result' which has been populated with the exchange rates in USD for the specified currencies.

exchange rates in rates table.png

Import Data into Airtable When a Record is Updated

We can import data whenever a record is updated using Data Fetcher's Trigger feature.

Triggers are a paid Data Fetcher feature, so you will need to upgrade your account. To do this, in Data Fetcher, scroll to the Schedule | Trigger | Webhhok URL tabs and click 'Upgrade'.

Authorize.jpg

Select a plan from the options and enter your payment details to upgrade.

data fetcher upgrade pricing plans.png

Return to Data Fetcher and click 'I've done this'.

schedule-upgrade.png

Next, select the 'Trigger' tab and click '+ Authorize' underneath.

Authorize.jpg

Accept the prompt 'I understand, let's Authorize'.

Authorize2.jpg

Click '+ Add a base'.

Authorize3.jpg

By selecting 'All current and future bases in all current and future workspaces', we'll avoid the need to re-authorize access for individual bases in the future.

Click on 'Grant access'.

Authorize4.jpg

Back in Data Fetcher, ensure the Trigger tab is still selected. Select the trigger type of Record updated.

Select a Table to watch for changes - this should be the 'Rates' table you have been using for the rest of this tutorial. You can optionally select a View to watch as well, if you only watch to watch a certain view. Or, leave this set to 'None' to watch all records in your 'Rates' table.

Finally, select the fields to watch for changes. For this example, we'll select just the 'Currency' field, so that whenever it is updated, we fetch the latest exchange rate for that currency.

exchange rates trigger.png

Finally, click 'Save' in the bottom-right hand corner. Whenever a record is updated in our Rates table, the latest currency data will be imported and the record will be updated!

Related Posts

How to Run a Curl Command in Airtable

How to Run a Curl Command in Airtable

Jan 23, 2024

Andy Cloke

No-Code
Import Historical Exchange Rates in Airtable

Import Historical Exchange Rates in Airtable

Feb 20, 2022

Andy Cloke

FinanceCurrency Conversion
How to Convert Currency in Airtable

How to Convert Currency in Airtable

Jul 29, 2021

Andy Cloke

FinanceCurrency Conversion