Automate Cryptocurrency Market Data Imports To Google Sheets Using CoinAPI

Reading Time: 4 minutes

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.

Latest crypto quote prices

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.

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.

Click here to install

Install Amigo Data to import crypto prices to Google Sheets

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.

Automate cryptocurrency market data imports to Google Sheets using CoinAPI

Enter your credentials to sign up to get a CoinAPI API key.

Get your CoinAPI key

You will receive your CoinAPI API key via e-mail.

CoinAPI API key in email

Get the endpoint of the data to import to Google Sheets

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.

Select the market data option

There are a number of data endpoints within that API category. Let’s select Current data from Quotes.

Select the current data option

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.

Copy the endpoint URL

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.

Launching Amigo Data to pull crypto prices to Google Sheets

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Enter the CoinAPI endpoint URL in the API URL field.

Enter the CoinAPI endpoint URL

In the Details tab, add a header. Enter the key and value pairs as follows:

Key: X-CoinAPI-Key
Value: Your API key
CoinAPI API headers

Click on the PREVIEW button to retrieve the crypto data and preview them.

Preview the crypto data to import to Google Sheets

Flatten the nested datasets and click IMPORT.

Preview of the crypto data to import to Google Sheets

After a couple of seconds, the data from CoinAPI will be successfully imported to Google Sheets. Here’s a snippet of imported data.

Snippet of imported CoinAPI 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:

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:

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

Import CoinMarketCap Data To Google Sheets

Import Data From Nasdaq To Google Sheets

Leave a Reply