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
- 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
BEFORE YOU BEGIN
Click here to install the API Connector add-on from the Google Marketplace.
PART 1: GET YOUR COINAPI API KEY
- If you haven’t already, navigate to https://www.coinapi.io/ and click Get a Free API Key
- Fill out your details and click Get a Free API Key
- 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.
- Open up Google Sheets and click Add-ons > API Connector > Open.
- In the Create tab, enter the API URL we just created.
- Under Headers, enter the following set of key-value pairs:
Replace YOUR_API_KEY with your CoinAPI API Key.X-CoinAPI-Key YOUR_API_KEY Accept application/json - Create a new tab and click ‘Set current’ to use that tab as your data destination.
- 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
- 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
- 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
- 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.
