This tutorial will show you how to use the Coinmarketcap API to import bitcoin prices and cryptocurrency data into Google Sheets, but the same method can be applied to many other cyrptocurrency APIs as well.
Many crypto investors and traders rely on Coinmarketcap’s API to get accurate, real time data for thousands of cryptocurrencies and cryptocurrency exchanges.
With Coinmarketcap’s API, you can pull information on price, total market cap, 24h volume, 24h circulating supply, and price trends (day, week, year) for every cryptocurrency that’s listed at coinmarketcap.com.
If you need to import Coinmarketcap’s API into Google Sheets, we’ve got good news for you. We built an application that can help you get Coinmarketcap’s API into Google Sheets in just a few clicks.
Our app is a Google Sheets add-on and cryptofinance alternative that you can install and it allows you to import APIs into Google Sheets in as little as a few minutes. You can use it to get crypto prices in Google Sheets easily.
Importing APIs into Google Sheets is usually something that would require some coding and maybe hours of work to accomplish, depending on your experience, but with our add-on there’s no coding required.
All you need to do is enter your API URL and key into our add-on and then click “Run”. The API data will then automatically populate into your Google Sheets. You can even use our API scheduling feature to keep the API data refreshed and updated on a recurring basis.
Keep reading to learn how to use our Google Sheets add-on to pull Coinmarketcap’s API in Google Sheets.
To integrate Coinmarketcap’s API with Google Sheets, you first need to get your CoinMarketCap API key. You can log in to your Coinmarketcap developer account here. Or if you haven’t signed up yet, you can sign up for a Coinmarketcap developer account here.
The Coinmarketcap basic plan is completely free to use but it does come with limitations. Learn about those limitations on their plan features page.
The free plan comes with:
After signing up for a Coinmarketcap Developer account, go to https://coinmarketcap.com/api/ and click the GET YOUR API KEY NOW button:
You’ll have to sign in or create an account first and then you’ll be able to access your Developer Portal account dashboard. Here, the key is prominently displayed, masked by asterisks.
When you hover over the COPY KEY button, the actual contents are revealed. Copy the key to your clipboard by clicking the COPY KEY button:
Apipheny is an add-on that makes it easy to import API data into Google Sheets.
Click here to install the add on in the G-Suite marketplace so that you can import Coinmarketcap’s API data into Google Sheets.
Then open the add-on by opening any Google Sheet and clicking Add-ons > Apipheny > Import API.
After clicking Import API you’ll see the Apipheny add-on open up as a sidebar in your Google Sheet.
First, select the HTTP method (GET or POST) required by your API endpoint. For this example we are using GET.
Then copy your API URL for the Coinmarketcap API endpoint into the API URL Path (JSON / CSV) field in the Apipheny add-on, followed by any GET parameters required for your query. We give an example API URL you can use below.
Into the Headers section in Apipheny, you should add three rows with the following keys and values:
Value: deflate, gzip
Value: <your API key>
Your API key is the value you previously obtained in Step 2. Do not include the carrots “<>”. While the Coinmarketcap API also allows passing the API key as a query parameter, this makes it visible and vulnerable to being accessed by unwanted third parties. As such, the recommended method is to use the X-CMC_PRO_API_KEY header.
As an example API URL, let’s use the cryptocurrency listings URL, which will return a list of all active cryptocurrencies, with the latest market data.
This URL uses the GET HTTP method and while it does accept a number of parameters that allow you to customize the output, they are all optional and will come with sensible defaults. As such, the request can simply be made to the endpoint URL, without any parameters.
Example API URL: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest
The three headers previously described are required, so you should add them in the dedicated table, below the API URL Path (JSON / CSV) field, as you can see in this screenshot:
Click the Run button at the bottom of the Apipheny add-on and wait for the cryptocurrency data to be fetched and added to your spreadsheet: