Import CoinAPI Data to Google Sheets

CoinAPI is a platform that provides crypto data through a cryptocurrency API. 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.

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 > Create New API Request.
    2. In the Create Request interface, enter the Request 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. You can call it whatever you like, but here we’ll call it ‘CoinAPI_BTC’. While still in that tab, click ‘Set’ to use that tab as your data destination.
    5. Name your request. Again we’ll call it ‘CoinAPI_BTC’
    6. Click Run and a moment later you’ll see a list of current BTC exchange rates in your Google Sheet:
      coinapi-img6

PART 4: COINAPI + GOOGLE SHEETS NOTES AND EXPANSIONS

  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. The free version of CoinAPI limits users to 100 API requests a day.

Leave a Comment