Import CoinGecko Data To Google Sheets

How to import CoinGecko data to Google Sheets
Reading Time: 5 minutes

Quick Guide
How to import Coingecko data to Google Sheets:
Step 1: Get the endpoint of the data to import
Step 2: Launch Amigo Data→Custom API
Step 3: Paste the endpoint in Amigo Data’s endpoint URL bar
Step 4: Preview and import

CoinGecko is a cryptocurrency ranking website that provides a 360-degree overview of the standing of digital currencies. It is one of the largest cryptocurrency data aggregators with thousands of different crypto assets tracked across hundreds of exchanges worldwide.

CoinGecko provides a data platform, digital currency prices, and fundamental analysis of the cryptocurrency market.

On the platform, you can find information about the following (and many others):

  • Current exchange rate and market capitalization of the asset
  • Historical data of all major coins
  • Place of the asset in the overall rating by capitalization
  • Exchanges on which an asset is traded the volume being traded
  • The total number of coins in circulation

CoinGecko makes most of these data available to the public and they can be easily accessed using its public API.

These data can be imported to Google Sheets for micro-analysis and granular tracking. Actionable insights can then be developed leading to better decisions. With the data imported, you can create visualisations using the SPARKLINE function such as the one shown below for better tracking and deeper analysis.

Coins by market capitalisation

So, let us learn how to import CoinGecko data to Google Sheets using a simple Google Sheets extension–Amigo Data.

Install the add-on

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

Alternatively, you can get it from Google Sheets itself.

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

Once the installation is complete, we can proceed to getting the endpoint of the data to import.

Get the endpoint of the data to import from Coingecko to Google Sheets

The CoinGecko’s free API allows up to 50 calls per minute and doesn’t require any authentication. So we can simply head over to the API documentation page and find the endpoint we need.

CoinGecko API documentation page: https://www.coingecko.com/en/api/documentation

All API calls to CoinGecko’s server start with the base endpoint mentioned below:

https://api.coingecko.com/api/v3/

On the API documentation page, navigate to the heading under which the desired endpoint is located and click on the endpoint.

For this tutorial, let us pull the data of the top 100 coins by market capitalization along with their current price, price fluctuations, price change, etc.

Navigate to coins heading and select /coins/{id}/tickers

List of endpoints in CoinGecko

Then click the Try it out button on the right side of the screen.

Testing the endpoint

Fill in all the required parameters according to the way you want the output to be shown.

  • In the vs_currency string, enter usd (or any other currency against which you want to quote the price)
  • Leave all the other parameters as they are and change the price_change_percentage string to 24h to return the price fluctuations in a day
Filling the parameters to import CoinGekco data to Google Sheets

After the parameters have been filled, click Execute to check the response. You’ll see something like the one shown below.

Response of the query

The Request URL is the endpoint URL for the desired data. Copy this: we’ll use it to import CoinGecko data to Google Sheets.

The endpoint for the top 100 coins by market capitalization:

https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&order=market_cap_desc&per_page=100&page=1&sparkline=false&price_change_percentage=24h

Import CoinGecko data to Google Sheets

Now that we’ve got all the things we need to import CoinGecko data to Google Sheets–Amigo data and the API endpoint–we can begin the importation.

Follow the steps mentioned below to import CoinGecko data to Google Sheets.

  • Launch Amigo Data in Google Sheets

    Extensions→Amigo Data→Connect
Launch Amigo Data from Google Sheets
  • Select Custom API from the list of sources
Select Custom API as the source
  • Paste the endpoint in the API URI bar
Paste the endpoint in the Connector's API URL bar
  • Preview and flatten the data. Then click IMPORT.

The spreadsheet will be populated with the data from CoinGecko in a few moments.

Shown below is a snippet of the data imported from CoinGecko to Google Sheets.

Snippet of data imported from CoinGecko to Google Sheets

With the data imported, we can use the data for analytical and tracking purposes so that we can stay on top of the changes and trends. And the fantastic thing is that the data are updated automatically; any change in price and whatnot will be reflected in the dataset.

Setting refresh schedule

To get the information updated periodically, click the report, toggle on the Refresh Schedule and select the schedule–hourly, daily, weekly or custom days.

Then click Save & Run

Alerts via email or Slack

You can get the report sent to your email or a Slack channel so that you do not even have to open the spreadsheet to keep track of what’s happening.

To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.

Below is a sample of an alert received on Slack.

Alert received on Slack

Conclusion

By using Amigo Data extention, you can easily import CoinGecko data to Google Sheets. And not just import them but get them updated automatically without having to repeat the process and get alerted periodically so that you can stay up to date with any changes. It greatly simplifies the task of monitoring coin information.

See also

There are also several sources from which you can import data into Google Sheets using Amigo Data, such as Yahoo Finance, Binance, Spotify, and Google Trends.

You can find the articles on them and several others as well as tutorials and tips on Google Sheets that can help you make the most from data on our blog.

Some similar articles you may be interested in:

https://blog.tryamigo.com/youtube-analytics-to-google-sheets/

https://blog.tryamigo.com/export-facebook-ads-data-to-google-sheets/

https://blog.tryamigo.com/import-accuweather-data-to-google-sheets/

https://blog.tryamigo.com/export-google-ads-data-to-google-sheets/