Search API Connector Documentation

Print

Import CoinAPI Data to Google Sheets

Last Updated On
byAna
< Knowledge Base

In this guide, we’ll walk through how to pull cryptocurrency data from CoinAPI directly into Google Sheets, using the 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.

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: Pull CoinAPI Data into Sheets

For this example, we'll access Bitcoin (BTC) exchange rates. Here's how to configure the request. Replace your_api_key with your own CoinAPI API Key.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • Application: Custom
    • Method: GET
    • Request URL: https://rest.coinapi.io/v1/exchangerate/BTC
    • Headers:
      • X-CoinAPI-Key: your_api_key
      • Accept: application/json
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. 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 3: 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. An example call would look like this:
    https://rest.coinapi.io/v1/trades/KRAKEN_SPOT_BTC_USD/latest?limit=10

Part 4: API Documentation

Official API documentation: https://docs.coinapi.io/

Leave a Comment