In this tutorial, we’ll learn how to import CoinGecko data to Google Sheets. But before that, a few things about CoinGecko.
Here are the steps to import CoinGecko data to Google Sheets:
Step 1: Install the Amigo extension in Google Sheets
Step 2: Get the CoinGecko API URL
Step 3: Import the data to Google Sheets
Before we proceed, here’s a sample of the data imported to Google Sheets from CoinGecko.
With these raw data, we can create charts and visualisations that can enable us to draw insights and make informed decisions, such as the one below.
How to import CoinGecko data to Google Sheets
Step 1: Install the add-on
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.
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 CoinGecko API endpoint URL.
Step 2: Get the CoinGecko API endpoint URL
CoinGecko API is mostly free to use. The free CoinGecko API allows users to make up to 50 calls per minute–which should be enough for most people–and doesn’t require an API key.
Head over to the CoinGecko API documentation.
From the CoinGecko API documentation page, scroll down to one of the endpoint categories and expand it.
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. So we navigate to coins and select the /coins/markets endpoint.
Then click the Try it out button on the right side of the screen.
Enter the currency in which you want the price to be quoted in the vs_currency parameter, which is the only required parameter. Then (optionally) fill in the other parameters to filter the data.
After the parameters have been filled, click Execute to check the response. You’ll see something like the one shown below.
The CoinGecko API endpoint URL is mentioned under “Request URL“. This is the URL we’ll use to import CoinGecko data to Google Sheets.
Since (as mentioned) the CoinGecko API is free to use and doesn’t require an API key, you can copy the endpoint URL given below to import the data to Google Sheets.
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=24hAnd now to the last step: Import CoinGecko data to Google Sheets.
Step 3: Import CoinGecko data to Google Sheets
Follow the steps mentioned below to import CoinGecko data to Google Sheets.
- Launch Amigo Data in Google Sheets by clicking Extensions→Amigo Data→Connect.
- Select Custom API from the list of sources.
- Paste the CoinGecko API endpoint URL in the API URI bar to retrieve data from CoinGecko API to Google Sheets.
- Expand the Details tab and enter the following as a header (this is optional).
Name: accept, Value: application/json
- Click PREVIEW to retrieve the data and see the preview of the data.
- Flatten the nested datasets. Then click the import button to import the coin markets data from CoinGecko to Google Sheets.
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.
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.
Automate data CoinGecko data imports to Google Sheets
To get the CoinGecko data you have imported to Google Sheets updated automatically and sync the Google Sheets data with CoinGecko, set a refresh schedule.
To set a refresh schedule, set the refresh timing and click “Yes, set the refresh timing”. The data will then be updated periodically automatically.
You can also set the refresh schedule later. Open Amigo, click “View reports”, select the report, and set the refresh schedule. 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+. Enter the email addresses and/ Slack channels to which you want the alerts to be sent. Then click Set Alert.
Below is a sample of an alert received on Slack.
Conclusion
By using the Amigo Data extension, 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 coins and staying ahead.
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:
Import YouTube Analytics data to Google Sheets