Importing Coinbase Data
This guide will walk through how to pull public cryptocurrency market data from the Coinbase Digital Currency API directly into Google Sheets.
To start pulling data all you need to do is make a request to pull data using Phlorin in Google Sheets.
Getting Started
Install the API solution add-on from Google Marketplace.
Pull Coinbase data into Sheets
To get the most out of the Coinbase API, use Phlorin to pull 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 Coinbase
3. Select the desired endpoint. No API key necessary.
In this example we will use /prices/{currency_pair}/buy this will provide the current buy price for different cryptocurrencies.
4. Next you will need to enter a currency pair.
This examples uses BTC to USD, formatted as “BTC-USD”
5. Make sure your desired sheet is selected and click Run.
Creating Custom Request
With Phlorin and Coinbase API documentation you can find URLs to run custom requests. Search their documentation for the desired request and adapt the URL to suit your needs.
This example shows how to use Phlorin to fetch the current rate BTC sells for in USD.
- Application: Custom
- Method: GET
- Request URL: https://api.coinbase.com/v2/prices/BTC-USD/sell
Adapting the URL to your needs:
This particular request URL can be formatted to fit your demands.
In the example above, the fetched currencies: BTC-USD, are written in the URL. If you want to fetch the sell data for different currencies, switch out the currency pair.
Documentation
Coinbase official API documentation: https://developers.coinbase.com/api/v2