Import Kraken Data to Google Sheets

Kraken is an trading exchange for Bitcoin and other cryptocurrency. In this guide, we’ll walk through how to pull public market and cryptocurrency data from the Kraken API directly into Google Sheets, using the API Connector add-on for Sheets.

PART 1: CREATE YOUR KRAKEN API REQUEST URL

We’ll follow the Kraken API documentation to access the latest Bitcoin-USD crypto quotes.

  • API root: https://api.kraken.com/
  • Endpoint: /0/public/Ticker
  • Query Strings: ?pair=xbtusd

Putting it together, we get the full API Request URL:

https://api.kraken.com/0/public/Ticker?pair=xbtusd

Note that these market data endpoints are publicly available (a Kraken account is not required),

PART 2: PULL KRAKEN API DATA INTO SHEETS

We can now enter our values into API Connector and import Kraken API 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
    kraken-img1

     

  3. This is a free, public API so we don’t need to enter any headers. Just leave this section blank.
  4. Create a new tab. You can call it whatever you like, but here we’ll call it ‘Kraken’. While still in that tab, click ‘Set’ to use that tab as your data destination.
  5. Under ‘Output Options’, select Compact mode. This isn’t strictly necessary, but makes this report easier to read. More on Report Styles here: Report Styles
    kraken-img2
  6. Name your request. Again we’ll call it ‘Kraken’
  7. Click Run and a moment later you’ll see the latest ticker data for XBT (Bitcoin) and USD in your Google Sheet:
    kraken-img3

 

PART 3: SHEETS + KRAKEN API NOTES AND EXPANSIONS

 

Check the documentation for a full list of endpoints, but if you just want to jump in you can try the following URLs, one at a time:

  • Depth (Order Book)
    https://api.kraken.com/0/public/Depth?pair=xbteur&count=4
  • Trades (Time and Sales)
    https://api.kraken.com/0/public/Trades?pair=ltcusd
  • Assets
    https://api.kraken.com/0/public/Assets

1 thought on “Import Kraken Data to Google Sheets”

Leave a Comment