< All Topics
Print

Importing Kraken Data

PostedFebruary 1, 2025
UpdatedFebruary 1, 2025
ByAnas Kakuwala

Importing Kraken Data into Google Sheets

This guide will walk through how to pull public currency and market data with Kraken directly in Google Sheets.

To start pulling data all you need to do is make a request using Phlorin in Google Sheets.

Getting Started

Install the API solution add-on from Google Marketplace.

Pull Kraken data into Sheets

To get the most out of Kraken, use Phlorin to pull up-to-date data seamlessly into Google Sheets.

1. In your desired Sheets document, open Phlorin and create a new request:
Extensions > Phlorin > Open > Create a request

2. In the Application dropdown select or search for Kraken

3. Select the desired endpoint. No API key necessary.
In this example we will use /public/assetPairs this will provide the many exchange rates and relevant information for the many currency pair’s Kraken offers.

4. Make sure your desired sheet is selected and then click Run.

Other endpoints may be beneficial to look through such as /public/Trade. With this endpoint you can use a specific currency pair and fetch that information without fetching dozens at a time.
For this information or understanding the output, check out Kraken’s official documentation.

Creating Custom Request

With Phlorin and Kraken’s documentation you can find URLs to run custom requests. Here’s an example request:
  • Application: Custom
  • Method: GET
  • Request URL: https://api.kraken.com/0/public/Ticker?pair=btcusd

Documentation
Kraken’s official documentation: https://docs.kraken.com/api/

Phlorin