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
• Part 2: Create your API Request URL
• Part 3: Pull API Data into Sheets
• Part 4: Get more CoinAPI Data
• Appendix: Trending Now CoinAPI Dashboard

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
   
2. Fill out your details and click Get a Free API Key
   
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.
   

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.
   
3. Under Headers, enter the following set of key-value pairs:
   

   X-CoinAPI-Key	YOUR_API_KEY
   Accept	application/json

   Replace YOUR_API_KEY with your CoinAPI API Key.

   

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:
   

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.