How to Create an Airtable Crypto Tracker

In this tutorial, we'll create a crypto tracker in Airtable. Using the Data Fetcher extension, we'll import various cryptocurrency data from CoinGecko into Airtable such as the current price of coins and their price changes over 24 hours and use this data to create the crypto tracker.

Install Data Fetcher

Install Data Fetcher from the Airtable marketplace. After the extension launches, sign up for a free Data Fetcher account by entering a password and clicking 'Sign up for free'.

Import Crypto Prices to Airtable

Requests in Data Fetcher are how you import data to or send data from your Airtable base. We will create a request to import prices from CoinGecko which we'll then use to create a crypto tracker in Airtable.

On the home screen of the Data Fetcher extension, click 'Create your first request'.

On the create request screen in Data Fetcher, for Application, select 'CoinGecko'.

For Endpoint, select 'Get latest market data for one or more cryptocurrencies'. This determines what data we will import from CoinGecko into Airtable in order to create a crypto tracker.

Enter a Name for your request, e.g. 'Import Crypto Prices'. Then click 'Save & Continue'.

Select the Currency you want to get market prices in, e.g. 'USD'.

Select the type of Coins you want to import into your crypto tracker for, e.g. 'Bitcoin', 'Ethereum' etc. You can also search for types of cryptocurrency by typing in this box.

Select the Output Table & View in Airtable where you want to create your Airtable crypto tracker.

Click 'Save & Run'.

The request will run and the Response field mapping modal will open. This is where you set which fields to import from CoinGecko and how they should map to the fields in the output table.

You can easily find the fields you want to import using the 'Find field' search bar.

We are going to import the 'Name', 'Symbol', 'Current price' and 'Price change 24h' fields into our crypto tracker.

You can choose whether to add these to existing Airtable fields or to create new ones. You can also choose the type of any new field. For 'Current price' and 'Price change 24h' we can choose the 'currency' type using the field type drop-down menu.

Click 'Save & Run'.

Data Fetcher will create any new fields that need to be created in the output table, then run the request again and import the crypto prices from Coingecko to Airtable.

Build a Crypto Tracker in Airtable

Once we have our table of coin prices we can now build a crypto tracker in Airtable. This will track the value of our crypto portfolio based on the amount we hold plus the latest prices and their change over the past 24hrs.

Create a second table in your base called 'Portfolio'. Add a field called 'Coin' that is linked to the first table (ie the table you imported CoinGecko prices into) and add the cryptocurrencies you want to track.

Create a lookup field called 'Price' and set it to look up the current price of your cryptocurrencies.

Add a Number field called 'Balance' and enter in the total number of each coin you hold.

Add a formula field called 'Value' with the formula {Price}*Balance and select 'Currency' on the formatting tab.

Add a lookup field called 'Price Change 24h' and set it to look up the Price Change 24h for your cryptocurrencies.

We now have built a crypto tracker that updates when we run the request. You can see the total value of your portfolio in the Airtable summary bar

Import Crypto Tracker Data Automatically

We can also use Data Fetcher's scheduled requests feature to automatically update the values in our crypto tracker every 15 minutes/ hour/ day etc. To do this you'll need a paid Data Fetcher account.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

A new tab will open where you can select a plan and enter your payment details to upgrade.

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

Under Schedule click '+ Authorize'.

A new window will prompt you to authorize the Airtable bases you want Data Fetcher to have access to.

We recommended selecting 'All current and future bases in all current and future workspaces' to save you having to authorize other bases in the future.

Click 'Grant access'.

Schedule this request is now toggled on in Data Fetcher.

Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save'. The request will now run on the schedule and update our Airtable crypto tracker automatically.