Get Real-Time Crypto Prices In Google Sheets With Live Coin Watch API

Get Real-Time Crypto Prices In Google Sheets With Live Coin Watch API
Reading Time: 5 minutes

Crypto traders and watchers have quite literally no time to even blink–for the prices of crypto could rise or plummet precipitously in a matter of seconds. Fortunately, for crypto aficionados, there are several ways to track the movement of cryptocurrencies.

Live Coin Watch is one platform dedicated to tracking crypto. It has real-time data of almost all major coins. And using its API, we can get into greater depth and track the movements minutely so that we don’t tumble along with crypto prices if–or rather when–it does.

So here in this tutorial, we’re going to learn how to pull crypto data from Live Coin Watch into Google Sheets using Amigo Data, a Google Sheets extension.

Below are the steps to fetch real-time crypto prices in Google Sheets with Live Coin Watch API:

  1. Install the Amigo Data extension
  2. Generate the Live Coin Watch API key
  3. Select an endpoint
  4. Import the data

How to import data from Live Coin Watch into Google Sheets

Install the Amigo Data extension in Google Sheets

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.

Amigo Data in Google Workspace Marketplace

Click here to install.

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo Data and install

Generate the API key

Go to the Live Coin Watch website (livecoinwatch.com) and create an account.

Registering an account

Upon registration, a verification email will be sent to your email address. Confirm it.

After activating your account log in to your account and navigate to the API section.

Navigating to the API page

Scroll to the API Playground and click the Get API Key button.

Generating the API key

On clicking the button, the API key will be generated.

The Live Coin Watch API key

Note the key and keep it secret. If you lose it or suspect someone has access to yor key, you can regenerate it. We’ll use it to authenticate API calls to Live Coin Watch.

Select an endpoint

Navigate to the API Documentation by clicking the READ THE DOCS link on the API page. You can also click this link to go to the documentation page.

Link to go to the API documentation

On the documentation page, expand the Resources heading from the table of contents.

Resources heading in the API documentation

Select any one from the list of available endpoints, for example, coins/single to fetch the latest information about a single coin.

Endpoints list

On the right side of the screen is the code snippet where we can find the endpoint URL and other information we’ll need to import the data.

The API URL and headers and body parameters

In the example above, the information for Ethereum will be returned with price quoted in US dollar. We can modify the data (-d) value to fetch the information for any coin in any currency–fiat or crypto.

For example, to retrieve data for Doge in euro, the data value will be as follow:

{“currency”: “EUR”, “code”: “DOGE”, “meta”:true}

The meta parameter is for whether to include all coin information or not. True includes it while false excludes it.

Now that we have got all the things we need, we can begin to import Live Coin Watch data to Google Sheets.

Import the data to Google Sheets from Live Coin Watch

Open Google Sheets and launch Amigo Data from the sheet into which you want to fill the data. To connect to Amigo Data, click Extensions→Amigo Data→Connect.

Launch Amigo Data

You’ll be presented with a list of sources to connect to. Choose Custom API.

Select Custom API as the source to connect

Change the method to POST and paste the endpoint URL in the API URL field.

Change the request method to POST

Expand the Body(JSON) tab and paste the data command (-d values)–which for our example is: {“currency”:”EUR”,”code”:”DOGE”,”meta”:true}

Pasting the data values

Then expand the Details tab and enter the headers.

content-type: application/json

x-api-key: YOUR_API_KEY

Use your own API key instead of YOUR_API_KEY.

Entering the headers

Then click the PREVIEW button. Flatten and expand the nested datasets. And then click the IMPORT button.

After a short while, the requested data will be imported into Google Sheets.

Snippet of the imported data

Once the data have been successfully imported, you can set it to update automatically at regular intervals so that you always have the latest data without starting the whole process over—and not just up-to-date information in Google Sheets but in inbox so that you don’t even need to open Google Sheets to stay updated. Visit this link to learn more about setting a refresh schedule in Amigo Data.

Some other endpoints

Below are some other endpoints that you can try.

Historical data a coin

This will retrieve the historical value of Bitcoin between November 1, 2015 and December 31, 2015. The “start” and the “end” parameters are the date range, in Unix timestamp in milliseconds. To get the data for any other coin, replace BTC with the coin of your choice.

Bitcoin historical price data

Top 100 coins by price

Visit our blog for to find out about the kinds of data that you can import to Google Sheets and how you can track stock and other financial data from Google Sheets.

Some related articles you may be interested in:

Import Crunchbase Data To Google Sheets

Import data from CoinGecko to Google Sheets

Import Data From Binance To Google Sheets