Search API Connector Documentation

Print

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.

BEFORE YOU BEGIN

Click here to install the API Connector add-on from the Google Marketplace.

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
Previous Import Clickbank Data to Google Sheets
Next Import Coinbase Data to Google Sheets

Leave a Comment