Crypto API Tutorials:
Binance API | Bitfinex API | Bitmex API | BscScan API | Cardano API | Coinbase API | Coingecko API | Coinmarketcap API | CoinAPI | Etherscan API | Glassnode API | Messari API | Nomics API | OpenSea API | PancakeSwap API | Rarible API
You might also like:
This tutorial will show you how to use the CoinMarketCap API to import bitcoin prices and cryptocurrency data into Google Sheets.
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.
Keep reading to learn how to pull data from Coinmarketcap into Google Sheets without writing any code.
Apipheny is an API connector for Google Sheets. You can use Apipheny to connect your Google Sheets to unlimited API data sources, make unlimited API requests, and more. There is a 30 day free trial included.
1.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace: https://apipheny.io/install
2.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top.
In the dropdown list you should see Apipheny. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet.
Tip: you can open a new Google Sheet by entering this URL in your browser: sheet.new
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:
In this section, we’ll show you how to browse the CoinMarketCap API documentation to find an API endpoint URL that retrieves the information you need. If you already know your URL, or you want to use the same example URL as us, just skip to Step 4.
First, open the CoinMarketCap API documentation page: https://coinmarketcap.com/api/documentation/v1/
The menu on the left contains general information about CoinMarketCap API and a list of categorized endpoints:
If we click the Cryptocurrency category, a list of its endpoints will be displayed:
An example endpoint is the Market Pairs Latest endpoint, which lists all active market pairs that CoinMarketCap tracks for a given cryptocurrency or fiat currency:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/market-pairs/latest
The endpoint’s documentation contains a descriptive title, a paragraph describing the endpoint’s purpose, the accepted query parameters, followed by a response format section. In a distinct section on the right, you will see the endpoint’s HTTP method (GET) and URL:
All endpoints can be accessed from the following base domain: https://pro-api.coinmarketcap.com/v1/
Make sure you have the Apipheny add-on open in your Google Sheet, on the Import tab.
Method: In Apipheny’s Import tab, select the HTTP method (GET or POST) required by your API endpoint. For this example we are using GET.
API URL: In Apipheny’s API URL field, paste your CoinMarketCap API URL and endpoint, followed by any GET parameters required for your query. We give an example API URL you can use below.
Headers: In the Headers section in Apipheny, you should add three rows with the following keys and values:
Header 1 Key: Accept Value: application/json Header 2 Key: Accept-Encoding Value: deflate, gzip Header 3 Key: X-CMC_PRO_API_KEY Value: your_API_key
your_API_key is the API key you previously obtained in Step 2. 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, let’s use the cryptocurrency listings endpoint, which will return a list of all active cryptocurrencies, with the latest market data. The URL for this endpoint is:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest
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
The three headers previously described are required, so make sure they are entered in Apipheny, like in this screenshot:
The last step is to 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:
Make a GET request
Make a POST request
PUT, PATCH, & DELETE Requests
Save requests for later
Schedule requests for automatic updates
Reference cell values in requests
=APIPHENY custom function
Stack multiple URLs in a single request
Run all saved requests at once
Modify your request settings
Import & export saved API settings
Ahrefs API
Airtable API
Alpha Vantage API
Asana API
Binance API
Clickup API
Coingecko API
Coinmarketcap API
Coinbase API
Constant Contact API
Discord API
Drift API
Etsy API
Eventbrite API
Facebook Graph API
Facebook Ads API
Figma API
Github API
Google SERP API
Hubspot API
Hunter API
What is an API?
What is an API URL?
What are parameters?
What is an endpoint?
What is an API key/token?
What is basic authentication?
What are headers?
What is a GET request?
What is a POST request?