Integrating real-time cryptocurrency data into your workflows has never been easier. With the CoinMarketCap API, you can pull up-to-date pricing, market cap, trading volume, and more directly into Google Sheets—all without writing a single line of code. Whether you're tracking portfolio performance, analyzing market trends, or building financial models, this guide walks you through every step of connecting CoinMarketCap to Google Sheets using a powerful add-on.
By the end of this tutorial, you'll be able to automate cryptocurrency data imports, customize queries for specific coins or metrics, and set up scheduled refreshes for live dashboards.
Why Use CoinMarketCap API with Google Sheets?
CoinMarketCap is one of the most trusted sources for cryptocurrency market data, offering accurate, real-time information on thousands of digital assets across global exchanges. When combined with Google Sheets, it becomes a dynamic tool for traders, analysts, and developers who want to visualize and manipulate crypto data in real time.
Key benefits include:
- Access to live prices, 24-hour volume, market caps, and price changes.
- Support for over 9,000 cryptocurrencies.
- Easy integration via API without coding.
- Ability to build custom trackers, alerts, and reports.
👉 Discover how to supercharge your crypto analytics with real-time data tools.
Step 1: Install the Apipheny Add-on for Google Sheets
To connect external APIs like CoinMarketCap to Google Sheets, you’ll need an API connector. Apipheny is a free and user-friendly Google Sheets add-on that allows you to import data from any REST API with just a few clicks.
How to Install Apipheny:
- Open Google Sheets in your browser.
- Click on Extensions > Add-ons > Get add-ons.
- Search for Apipheny and click Install.
- Once installed, go back to Extensions > Apipheny > Import API to open the sidebar.
You’re now ready to start pulling data.
Step 2: Sign Up for a CoinMarketCap Developer Account and Get Your API Key
Before making requests, you need an API key from CoinMarketCap. This key authenticates your access to their data.
Steps:
- Visit the CoinMarketCap API portal and sign up (or log in).
The free plan includes:
- 333 daily credits
- 10,000 monthly credits
- 30 API calls per minute
- Access to 9 core endpoints
- 1 currency conversion per request
While sufficient for basic use, heavy users may consider upgrading later.
- After logging in, navigate to the Dashboard.
- Find your API Key displayed under your account settings.
- Click Copy Key to save it securely.
🔐 Never share your API key publicly. Use headers (not URL parameters) to pass it securely.
Step 3: Choose a CoinMarketCap API Endpoint
An API endpoint is a URL that returns specific data. CoinMarketCap offers multiple endpoints under categories like Cryptocurrency, Exchange, Airdrops, and Trending.
Popular Endpoints:
GET /v1/cryptocurrency/listings/latest– Lists top cryptocurrencies by market cap.GET /v2/cryptocurrency/quotes/latest– Returns detailed price quotes.GET /v1/cryptocurrency/trending/most-visited– Shows trending coins based on traffic.GET /v1/exchange/market-pairs/latest– Provides active trading pairs for exchanges.
📘 All endpoints are accessible via the base domain: https://pro-api.coinmarketcap.com/v1/
Let’s use the Listings Latest endpoint as our example:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latestThis returns top coins sorted by market cap with real-time stats like price, change %, volume, and supply.
Step 4: Configure the API Request in Apipheny
Now that you have your endpoint and API key, it’s time to configure the request inside Apipheny.
In the Apipheny Sidebar:
- Method: Select
GET API URL Path: Paste your full endpoint URL:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest- Headers: Add these three required headers:
| Key | Value |
|---|---|
Accept | application/json |
Accept-Encoding | deflate, gzip |
X-CMC_PRO_API_KEY | your_actual_api_key |
Replace your_actual_api_key with the key copied earlier.
⚠️ Avoid passing the API key as a URL parameter—it exposes your credentials.
Optional parameters like limit=100, convert=USD, or start=1 can be appended to refine results.
Step 5: Run the Request and Import Data
Click the Run button in Apipheny.
Within seconds, your Google Sheet will populate with live cryptocurrency data—including names, symbols, prices, market caps, 24h volume, circulating supply, and price changes across different timeframes.
You can now:
- Sort and filter columns
- Create charts and dashboards
- Apply conditional formatting for alerts
- Combine with other data sources
👉 Automate your next crypto tracking sheet with advanced data tools.
Handling Pagination in CoinMarketCap API
Some endpoints return large datasets split across multiple pages. To navigate them, use pagination parameters:
start: Starting index (1-based). Default: 1limit: Number of records per page (1–5000). Default: 100
For example:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?start=1&limit=500This fetches the first 500 listed cryptocurrencies. For datasets larger than 5000 items, you’ll need to run multiple requests incrementally.
Apipheny supports pagination automation, so you can stack multiple paginated calls seamlessly.
Frequently Asked Questions (FAQ)
Q: Is the CoinMarketCap API free to use?
Yes, CoinMarketCap offers a free tier with limited monthly credits (10,000), suitable for small projects or personal use. Higher usage requires a paid plan.
Q: Do I need coding experience to connect CoinMarketCap to Google Sheets?
No. Tools like Apipheny let you import API data visually—no coding required.
Q: Can I schedule automatic updates for my crypto data?
Yes. Apipheny allows you to schedule requests at intervals (e.g., every hour), keeping your sheet updated automatically.
Q: What happens if I exceed my API credit limit?
Once your credits are exhausted, requests will fail until they reset at the start of the next month—or if you upgrade your plan.
Q: Which cryptocurrencies are supported?
Over 9,000 cryptocurrencies are available via the API, including Bitcoin (BTC), Ethereum (ETH), Solana (SOL), and emerging altcoins.
Q: Can I convert prices into other currencies?
Yes. Use the convert parameter (e.g., convert=EUR) or specify multiple currencies with convert=USD,EUR,BTC.
Core Keywords for SEO
This guide naturally integrates key terms that align with search intent:
- CoinMarketCap API
- Google Sheets crypto
- Cryptocurrency data
- Real-time crypto prices
- API integration
- Import crypto data
- Free crypto API
- Track Bitcoin in Google Sheets
These keywords help users find reliable solutions for automating cryptocurrency tracking and analysis.
Final Tips for Success
- Always store your API key securely—never in public spreadsheets.
- Monitor your credit usage in the CoinMarketCap dashboard.
- Use filters and named ranges in Sheets for better data management.
- Combine crypto data with formulas (like
GOOGLEFINANCE) for richer insights.
With real-time data flowing into your spreadsheets, you’re equipped to make smarter investment decisions and build powerful analytical tools.
👉 Unlock deeper insights with professional-grade trading platforms.
By following this guide, you’ve successfully connected the CoinMarketCap API to Google Sheets—enabling seamless access to live cryptocurrency data for analysis, reporting, or personal tracking. No technical background needed. Just actionable intelligence at your fingertips.