A script to get cryptocurrency price data from CoinMarketCap.

coinmarketcap.gs

// Be sure to add your CoinMarketCap API key below.
function COINMARKETCAP(token) {
  var requestOptions = {
    method: 'GET',
    qs: {
      start: 1,
      limit: 5000,
      convert: 'USD'
    },
    headers: {
      'X-CMC_PRO_API_KEY': 'YOUR_API_KEY_HERE'
    },
    json: true,
    gzip: true
  };
  var url = 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=' + token;
  var result = UrlFetchApp.fetch(url, requestOptions);
  var txt = result.getContentText();
  var d = JSON.parse(txt);
  return d.data[token].quote.USD.price;
}

// Usage
// =COINMARKETCAP("BTC")
// =COINMARKETCAP("ZIL")
// =COINMARKETCAP("ADA")