Getting started
The first step is to sign up for a free API key from CoinMarketCap.
Getting crypto prices
Once you have your API key, you can paste it in below to get live prices for any crypto currency you want, eg bitcoin, ethereum, dogecoin, polkadot, etc.
Crypto price [CoinMarketCap]
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
name | symbol | quote.GBP.price | quote.GBP.volume_24h | quote.GBP.percent_change_1h | quote.GBP.percent_change_24h | quote.GBP.percent_change_7d | quote.GBP.percent_change_30d | quote.GBP.percent_change_60d | quote.GBP.percent_change_90d | quote.GBP.market_cap |
|---|---|---|---|---|---|---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the Crypto Coin Tracker Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets
Automation
If you have many crypto coins you want to track, then I recommend you install the SyncWith Google Sheets addon, and you can use our Cell References feature to get prices for a list of coins you maintain in your sheet.