In this guide, we’ll walk through how to pull public 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 (most other crypto APIs are better in that respect), but it is easy to use and can be a useful alternative to some of the more popular crypto APIs.
Before You Begin
Part 1: Pull Data from Coinbase into Sheets
Part 2: Create a Custom Request
Part 3: API Documentation
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.
In Sheets, open API Connector and create a new request (Extensions > API Connector > Open > Create request)
Select Coinbase from the drop-down list of applications
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}/buyendpoint, which provides the current buy price for a cryptocurrency.
This endpoint requires that we enter a currency pair. We'll use BTC-USD
Choose a destination sheet, name your request, and hit Run. A moment later you'll see the response data in your sheet.
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. Here's an example:
Import live Bitcoin prices into Google Sheets using the GOOGLEFINANCE function or API connectors like CoinGecko through add-ons. The simplest method involves typing '=GOOGLEFINANCE("BTC-USD")' in a cell. For more detailed data, install an API Connector add-on and configure requests for live cryptocurrency prices.
Import live Bitcoin prices into Google Sheets using the GOOGLEFINANCE function or API connectors like CoinGecko through add-ons. The simplest method involves typing '=GOOGLEFINANCE("BTC-USD")' in a cell. For more detailed data, install an API Connector add-on and configure requests for live cryptocurrency prices.
How do I export my Coinbase transaction history to a CSV file? Log into your Coinbase account, go to your profile and select 'reports'.Then, select 'generate report' next to 'CSV report', and download the CSV file once it's available.
Market data is available to users via the API and includes price quotes, volume, market capitalization as well as other important metrics. Numerous cryptocurrencies can avail these. The users need to sign up for an API key, although the use of the API is free. Accessing its features requires this key.
Sign up for an API key: To use the CoinMarketCap API, developers need to sign up for an API key, which they can obtain by creating an account on the CoinMarketCap developer portal. Once developers have obtained their API key, they can get data from CoinMarketCap API endpoints using their programming language of choice.
Navigate to OAuth 2.0 Playground and click the OAuth 2.0 Configuration button in the top right corner of your screen. Select Use your own OAuth credentials, and provide the obtained Client ID and Client Secret values. Click on Close.
In Excel, use the "DATA" tab and select 'From Web' to import data from the API. Follow the prompts to connect to the API and retrieve live price data for your chosen cryptocurrencies.
The quickest way to fetch trending crypto price data into Excel is using CoinGecko API's /search/trending endpoint, through Excel's Data from Web feature. This will import price data on the top 7 trending coins on CoinGecko, as searched by users in the last 24 hours.
The Google Sheets API is a RESTful interface that lets you read and modify a spreadsheet's data. The most common uses of this API include the following tasks: Create spreadsheets. Read and write spreadsheet cell values.
Introduction: My name is Fr. Dewey Fisher, I am a powerful, open, faithful, combative, spotless, faithful, fair person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.