Import CoinAPI Data to Google Sheets

In this guide, we’ll walk through how to pull cryptocurrency data from CoinAPI directly into Google Sheets, using the free API Connector add-on. We’ll first get an API key from CoinAPI, and then set up a request to pull in cryptocurrency exchange rate details to your spreadsheet.

For a quick start, feel free to skip ahead to the pre-built dashboard after getting your API key.

PART 1: GET YOUR COINAPI API KEY

  1. If you haven’t already, navigate to https://www.coinapi.io/ and click Get a Free API Key
    coinapi-img1
  2. Fill out your details and click Get a Free API Key
    coinapi-img2
  3. A few minutes later you’ll receive an email containing your API key. Congrats! You now have access to CoinAPI. Keep this key handy as we’ll need it in a moment.
    coinapi-img3

PART 2: CREATE YOUR API REQUEST URL

We’ll follow the CoinAPI documentation to access Bitcoin (BTC) exchange rates.

  • API root: https://rest.coinapi.io/v1
  • Endpoint: /exchangerate/BTC

Putting it all together, we get the full API Request URL:

https://rest.coinapi.io/v1/exchangerate/BTC

PART 3: PULL COINAPI DATA INTO SHEETS

We can now enter all our values into API Connector and import Bitcoin data into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Open.
  2. In the Create tab, enter the API URL we just created.
    coinapi-img4
  3. Under Headers, enter the following set of key-value pairs:
    X-CoinAPI-KeyYOUR_API_KEY
    Acceptapplication/json
    Replace YOUR_API_KEY with your CoinAPI API Key.

    coinapi-img5

  4. Create a new tab and click ‘Set current’ to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see a list of current BTC exchange rates in your Google Sheet:
    coinapi-img6

PART 4: GET MORE COINAPI DATA

  1. Experiment with endpoints and query strings as described in the documentation to see other types of cryptocurrency data. For example, you can see a detailed list of all exchanges tracked by CoinAPI with this URL:
    https://rest.coinapi.io/v1/exchanges
  2. For more complex API requests, CoinAPI uses a system to clump exchange-type-trading pairs into a single “symbol” for use in their API. As an example, if you wanted to call the BTC-USD trading pair on the spot market of Kraken, you would formulate the symbol like this: KRAKEN_SPOT_BTC_USD. As an example call would look something like this:

    https://rest.coinapi.io/v1/trades/KRAKEN_SPOT_BTC_USD/latest?limit=10
  3. The free version of CoinAPI limits users to 100 API requests a day.

APPENDIX: TRENDING NOW COINAPI DASHBOARD

Wanna get a peek at some of the exchanges and trading pairs that are hot across CoinAPI’s web-scrapers? Look no further! Take a peek at our pre-built dashboard. Just plug in your API key and hit “refresh-all” to pull in fresh exchange quote data.

coinapi-img7

Leave a Comment