Search API Connector Documentation
Top Free Crypto APIs for Google Sheets
As of June 2022, there a huge number of crypto APIs, and virtually all of them offer data for free through their public endpoints. But they are not all equal; some offer more comprehensive data or provide unique endpoints.
This article lists the top crypto APIs accessed by users of the API Connector extension for Sheets in order of popularity (#1 is the most popular), along with some information:
- the type of authentication they require,
- the data points they provide,
- whether or not they share rate limits among users (shared rate limits make them less suitable for Google Sheets, since all requests run through Google’s servers).
Please note that the list below refers to each API’s free and public endpoints. Non-public endpoints may also be available with different offerings and requirements.
List of Crypto APIs
| # | API Name | Category | Available Data (Free Plan) | Auth Type | Shared Rate Limits? |
|---|---|---|---|---|---|
| 1 | CoinMarketCap | Market Data | -Categories -ID mapping -Cryptocurrency metadata -Listings latest -Quotes latest -Exchange metadata -Market price conversions | API key | |
| 2 | CoinGecko | Market Data | -Current crypto proices -Coin data -Contract data -Asset platforms -Categories -Exchanges -Market indexes -Derivatives -BTC Exchange rates -Trending coins -Global crypto data -Public companies | Open | Y |
| 3 | Binance | Market Data (private account endpoints also available) | -Exchange information -Order books -Recent trades -Old trade lookup -Aggregate trades -Kline/candlesticks -Current prices -24hr tickers -Symbol price ticker | Open, API key | Y |
| 4 | CoinBase | Market Data (private account endpoints also available) | -Currencies -Exchange rates -Prices | Open | |
| 5 | BscScan | Blockchain Explorer | -Accounts -Contracts -Transactions -Blocks -Logs -Geth proxy -Tokens -Gas tracker | API key | |
| 6 | KuCoin | Market Data | -Symbols & Ticker -Order book -Histories -Currencies | Open | |
| 7 | CryptoCompare | Market Data | -Prices -Historical -Blockchain data -Trading signals -Pair mapping -Toplists -Social data -News -Order book -Metadata | API key | |
| 8 | Kraken | Market Data (private account endpoints also available) | -Asset info -Tradable pairs -Tickers -OHLC data -Order book -Recent trades -Recent spreads | Open | |
| 9 | WazirX | Market Data (private account endpoints also available) | -24hr tickers -Orderbook -Recent trades -Old trade lookup | Open | |
| 10 | OpenSea | NFTs | -Assets -Events -Collections -Bundles -Offers -Contracts -Orders | Open, API key | |
| 11 | CoinAPI | Market Data | -Metadata -Exchange rates -OLHCV -Trades -Quotes -Order book -Orderbook L3 | API key |