In this guide, you'll learn to import cryptocurrency prices to Airtable using the Coinranking API. Coinranking provides prices for all cryptocurrencies through their free API.
We'll use this API and the Data Fetcher Airtable extension to create a crypto portfolio tracker in Airtable.
Based on the Coinranking API documentation the base URL for all API requests is 'https://api.coinranking.com/v2/'. We'll use the '/coins' endpoint to get prices for each cryptocurrency.
By default, Coinranking gives returns 50 coins, but we can fetch more by turning on pagination.
At the moment, we have to fetch prices from Coinranking's API by clicking the 'Run' button. However, we can use Data Fetcher's (paid) scheduled requests feature to automate this.
To upgrade your account, In Data Fetcher, scroll to Schedule and click 'Upgrade'.
Choose a plan from the different options depending on your needs and enter your payment details.
In Data Fetcher, click 'I've done this'.
Under Schedule click '+ Authorize'.
A window will open where you'll be prompted to authorize which 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 avoid any issues with unauthorized bases in the future.
Click 'Grant access'.
Back in Data Fetcher, you'll see Schedule this request is now toggled on.
Select a schedule for the Coinranking Airtable integration to run. You can choose intervals of 'Minutes', 'Hours', 'Days' or 'Months', then click 'Save'.
Now any changes to your Coinranking data will be imported into Airtable automatically on your chosen schedule.
Oct 11, 2022•