Automate Coinranking Data Imports To Google Sheets

Reading Time: 5 minutes

Coinranking API is a platform that provides high-quality data about cryptocurrencies such as price history, circulating supplies, trading pairs and so much more.  

All of this data can be imported into Google Sheets in a swift manner using Amigo Data, a Google Sheets extension that automates data imports. Amigo data saves you from manually retrieving data, set it up once and let Amigo Data do the job for you. 

In this tutorial, we will learn how to import data about all cryptocurrencies. Below are the steps to import cryptocurrency data from CoinrankingAPI into Google Sheets:

Automate Coinranking data imports to Google Sheets

Here’s the step-by-step guide to import Coinranking data to Google Sheets

Install the Amigo Data add-on

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

Sign up for  RapidAPI

RapidAPI page to sign up

Once you’re logged in, go to the Coinranking API documentation in RapidAPI

Learn how to automate coinraking data imports to Google Sheets

Choose a subscription plan from the Pricing menu. In this tutorial, we will choose the Basic option

Click on the endpoints and scroll down a bit. You will find your API key under the Header Parameters.

Choose an endpoint

We wish to import a list of coins ordered by their rank (market cap). The response not only returns a list of coins but also statistics regarding the requested list, such as the volume in the last 24 hours, current market price, 24 hours price change, and many more. So, select the Get coins option.

The header parameter consists of the API key and API host. In the optional parameters we can fine tune our data imports by specifying the reference currency, timeperiod and many more.

Click the Test Endpoint option to run the query

The success message indicates that the endpoints are functioning correctly. 

On the right side under code snippets, select shell-> cURL from the dropdown menu

Select the cURL from Shell

Copy the URL excluding the apostrophes and also note down the headers. This is the endpoint URL for the data to import to Google Sheets.

Import data to Google Sheets

Go back to Google Sheets and launch the Amigo Data extension.

Launching Amigo Data in Google Sheets

Select Custom API from the list of sources

Selecting the source in Amigo Data

Paste the endpoint in the API URI bar

Pasting the endpoint

Then expand the Details tab and enter the following as headers:

Name: X-RapidAPI-Host, Value: coinranking1.p.rapidapi.com

Name: X-RapidAPI-Key, Value: your_key

Replace your_key with your RapidAPI key.

Then click the PREVIEW button

Flatten the data points and then click IMPORT.

A snippet of the imported data.

A snippet of imported data

You can likewise import other types of data from the Coinranking API. Following are some other examples.

Coin price data

The coin price endpoint gets you the latest price of a particular cryptocurrency. In the required parameter section, you are expected to enter the valid UUID of a cryptocurrency. You can go through the list of cryptocurrencies with their respective UUID.

Coin price history

Coin price history endpoint helps you keep track of prices on all listed assets. It lists prices and their timestamp for the requested time period which is useful for making a chart. By simply specifying the UUID of the cryptocurrency you can access the historical price data. You can also mention the timeperiod of your choice, 24h is the default time period

Similarly, you can also explore other endpoints. Coinranking API has so much to offer. You can import any kind of currency market data using this interface. To explore more endpoints go through the documentation of Coinranking API. 

After importing the data, you can also set a refresh schedule so that the data are updated automatically at regular intervals. By this, you can automate importing financial market data to Google Sheets. To learn how to set a refresh schedule, follow this link.

There are several other types of data that you can import into Google Sheets using Amigo Data such as Marketstack data,  Coinmarketcap data, Nasdaq data, and many more. 

Some related articles you may be interested in:

Get Real-time Stock Data In Google Sheets Using MarketStack API

Import CoinMarketCap Data To Google Sheets

Import Data From Nasdaq To Google Sheets