CoinAPI is a platform that provides information about cryptocurrency market data. The critical endpoints include exchange rate data, trades data, OHLCV data, orders data, and many more.
All this can be imported in just a blink of an eye using the Amigo add-on that automatically imports data from multiple sources. With Amigo you import the data once successfully and you don’t have to import successively as Amigo does the rest for you.
Below are the latest quote prices of some cryptocurrencies imported to Google Sheets using CoinAPI.
So, let’s learn how to use CoinAPI to pull real-time crypto data to Google Sheets and automate the data imports.
Steps to live cryptocurrency prices in Google Sheets using CoinAPI.
- Install the Amigo Data add-on
- Get the CoinAPI API key
- Choose the data endpoint
- Import the data to Google Sheets
Cryptocurrency market data imports to Google Sheets
Install the Amigo Data add-on
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace to pull cryptocurrency data to Google Sheets with CoinAPI.
Alternatively, you can get it from Google Sheets.
- Open Google Sheets
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo Data and install it.
Get the CoinAPI API key
Visit coinapi.io and click on the GET A FREE API KEY button.
Enter your credentials to sign up to get a CoinAPI API key.
You will receive your CoinAPI API key via e-mail.
Get the endpoint of the data to import to Google Sheets
Visit the CoinAPI documentation.
On the left side of the CoinAPI documentation, we’ll see the list of cryptocurrency data that we can retrieve using CoinAPI.
Cryptocurrency market data can be found in the Market Data – Rest API.
There are a number of data endpoints within that API category. Let’s select Current data from Quotes.
On the right side are the CoinAPI endpoint URL and the headers. Copy the endpoint URL and note down the header. We’ll use these to pull crypto prices to Google Sheets.
Import the data to Google Sheets
Now go back to Google Sheets and launch Amigo Data to import the cryptocurrency market data to Google Sheets by clicking Extensions→Amigo Data→Connect.
Select Custom API from the list of sources.
Enter the CoinAPI endpoint URL in the API URL field.
In the Details tab, add a header. Enter the key and value pairs as follows:
Key: X-CoinAPI-Key
Value: Your API key
Click on the PREVIEW button to retrieve the crypto data and preview them.
Flatten the nested datasets and click IMPORT.
After a couple of seconds, the data from CoinAPI will be successfully imported to Google Sheets. Here’s a snippet of imported data.
Other types of data can also be imported to Google Sheets with CoinAPI in a similar manner.
Exchange rate
It fetches the current market price of any cryptocurrency. The endpoint URL is as follows:
https://rest.coinapi.io/v1/exchangerate/{asset_id_base}/{asset_id_quote}
Asset_id_base: It stands for the base cryptocurrency whose market price we wish to determine
Asset_id_quote: It stands for the target currency i.e the value of a base currency expressed in terms of target currency
For example, we wish to find the exchange rate of BTC in terms of USD. The API endpoint URL should look like this:
https://rest.coinapi.io/v1/exchangerate/BTC/USD
Similarly, you can also explore other endpoints. CoinAPI has so much to offer. You can import any kind of currency market data using this interface. To explore more endpoints go through the documentation of CoinAPI.
After importing the data, you can also set a refresh schedule so that the data are updated automatically at regular intervals. By this, you can automate importing financial market data to Google Sheets. To learn how to set a refresh schedule, follow this link.
There are several other types of data that you can import into Google Sheets using Amigo Data such as Marketstack data, Coinmarketcap data, Nasdaq data, and many more.
Some related articles you may be interested in:
Get Real-time Stock Data In Google Sheets Using MarketStack API