Import Coin Metrics Data to Google Sheets

Reading Time: 4 minutes

In this article, we will learn to import Coin metrics data to Google Sheets using the Amigo Data Add-on. Coin metrics is a company that aims to empower the public to make better financial decisions when trading in cryptocurrencies. 

You can use the data available via Coin metrics to make informed decisions regarding your crypto investments and possibly end up making lucrative investments. You can import Coin metrics data to Google Sheets using the Amigo Data Add-on and facilitate calculations based on the data imported.

To import Coin metrics Data to Google Sheets, we will follow the steps mentioned below:

  1. Choose the API endpoint URL
  2. Install the Amigo Data Add-on
  3. Import Coin metrics Data

How to import Coin metrics data to Google Sheets

Follow the steps given below to learn how to import Coin metrics data to Google Sheets.

Step 1: Choose the API endpoint 

Go to this website to find the API documentation. You will find a variety of API endpoints that can be used to import Coin metrics data to Google Sheets.

List of API endpoints that can be used

For the purpose of this tutorial, we will be using the API endpoint titled Available Asset Metrics.

To access the endpoint, click Catalog→ Available Asset Metrics. This endpoint will provide you with a list of metrics along with their description, categories and assets for which the metric will be available. 

Using the endpoint to obtain the available asset metrics

The query parameters list the queries that can be used to filter the data imported and its description. 

Query parameters

Click on the arrow beside /catalog/asset-metrics in the top right corner.

Accessing the API endpoint URL

You will see two links listed in the drop-down that appears. Click and copy the second link

Coin metrics provides its users with two endpoint URLs: a paid URL that requires a key, and a community URL which is free and doesn’t require a key. The tradeoff with using the community URL is that this version comes with a limit of 1000 requests per IP address.

API endpoint URL

Step 2: Get Amigo Data Google Sheets extension

The Amigo Data Add-on is an extension in Google Sheets that allows you to import data from various sources without coding. 

You can either install the extension directly from the Google Workspace Marketplace or follow the steps below:

  1. Open a new google sheet
  2. Click on Extension→ Add-ons→ Get Add-on
  3. Search for “Amigo Data” and install it.

Step 3: Import the data to Google Sheets

Go to the Google Sheet in which you want the data to be pasted. Click on Extennsions→Amigo Data→Connect

Accessing the Amigo Data Add-on

Select Custom API from the list of sources

List of sources to connect

Paste the API endpoint URL copied in step 1 and click on Preview. 

Pasting the API endpoint URL in the Amigo Data add-on

In a few seconds, a cluttered dataset will appear on the screen. Flatten the dataset until it is separated into columns and then click on Import.

Cluttered form of data imported from Coin metrics

Upon cleaning the data and clicking on import, the data will appear on your sheets as shown below.

Import coin metrics data to Google Sheets

Other endpoint URLs

  • Catalog→ Available market funding rates

This endpoint URL will allow you to access all data pertaining to markets and their funding rates along with the time ranges of available data.

https://community-api.coinmetrics.io/v4/catalog/market-funding-rates

  • Timeseries→ Market metrics

This endpoint URL will allow you to fetch metrics for specified markets and order them by tuples. It takes two compulsory queries, which need to be added to the details section of the Amigo Data Add-on. The two compulsory queries are markets (list of markets whose metrics need to be imported), and metrics (Comma separated metrics to request time series data for).

https://community-api.coinmetrics.io/v4/timeseries/market-metrics

  • Full catalog→ Supported institutions

This API endpoint URL returns a list of all support institutions along with information for them like metrics and time ranges of available data.

https://community-api.coinmetrics.io/v4/catalog-all/institutions

Amigo Data allows users to set a refresh schedule that automatically updates the data imported to ensure that the user is provided with the latest data without any manual input. To learn how to automatically update your data at regular intervals and receive alerts for the same on your email or Slack channel, click here

In this article, we have successfully learned how to import Coin metrics data to Google Sheets. To learn more about related articles, check out our blog

See Also

Below you will find some related articles on how to import data from a variety of sources.

Import Polygon.io data to Google Sheets

Import live metal prices to Google Sheets

Import Coinbase data to Google Sheets