Search API Connector Documentation

Print

Import Coinbase Data to Google Sheets

In this guide, we’ll walk through how to pull cryptocurrency market data from the Coinbase Digital Currency API directly into Google Sheets, using the API Connector add-on for Sheets.

Coinbase doesn't provide that much market data (other crypto APIs are generally better in that respect), but it is easy to use and can be a useful alternative to some of the more popular crypto APIs.

This article also includes a template to access private account data.

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Pull Data from Coinbase into Sheets

The easiest way to get started with the Coinbase API is through API Connector’s built-in integration.

  1. Select Coinbase from the drop-down list of applications
    coinbase-application
  2. Select an endpoint.  These endpoints are all open so you don’t need an API key. For this example we’ll choose the /prices/{currency_pair}/buy endpoint, which provides the current buy price for a cryptocurrency.
    coinbase-endpoints
  3. This endpoint requires that we enter a currency pair. We'll use BTC-USD
    coinbase-parameters
  4. Choose a destination sheet, name your request, and hit Run. A moment later you'll see the response data in your sheet.
    coinbase-response

Part 2: Create a Custom Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the URLs shown in the API documentation. To create a custom request, add the complete URL into the request URL field.

To easily convert from a preset request to a custom API URL, tick the Add request URL box before running your preset request (under Output options). This will print out your complete API URL, which you can then copy/paste into the request URL field.

Part 3: Get Private Coinbase Account Data

The above endpoints deal with public market data from the Coinbase API.

If you are instead a Coinbase customer looking to get API data from your own account, they require a more complex authentication process that includes generating a “signature”.

To access your private account data, please copy this sheet and follow the instructions within.

Part 4: API Documentation

Official API documentation: https://developers.coinbase.com/v2

16 thoughts on “Import Coinbase Data to Google Sheets”

  1. I’m not able to generate a spot price between two cryptocurrencies, like the current price from BTC to DOT for example.

    Is this possible?

    Reply
    • Yeah, their documentation isn't that clear on this point, but it seems the spot price endpoint only supports conversions to USD. But you could get this data by running https://api.coinbase.com/v2/exchange-rates?currency=BTC and finding the price of DOT within the response.

      Reply
  2. Hello! I was wondering if it's possible to get 2 different currencies (let's say BTC and ETH) in one API GET request.

    I've tried setting 2 API URLs on the same connector but it doesn't work. I've tried setting 2 different connectors but the first one deletes de second one when it gets refreshed =/

    Reply
  3. Thank you so much for this very useful tool. I've been following some crypto. Is there a way to display in a box the evolution of a crypto in percent for the last month? Always the evolution from a month from now to now.

    Thank you!!
    Max in Indonesia.

    Reply
    • Sure, but Coinbase doesn't provide a lot of info so I'd use a different API for this. For example this API call would give you 24h, 7d, 30d, 60d, and 90d percent changes for whatever coins you want:
      https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=BTC

      Reply
  4. Hi, thanks for the info.
    Do you know how connect to coinbase without addons. I mean, do you know how connect to coinbase from google sheet and get my wallet ?

    I try to figure out....

    Reply
    • If you Google "Coinbase apps script" or similar, you can find people who have written scripts to connect Sheets to Coinbase without add-ons. Or if you just want to get your private data, you can use this sheet.

      Reply
  5. Hello, really nice sheet it worked for me and I was able to get e. g. my user_id intro google sheets.

    But is there an endpoint from coinbase with which I could import the total account balance, shown to me when I open the app, into google sheets?

    Thanks a lot.

    Reply

Leave a Reply to Max Cancel reply

Jump To...