Crypto coin prices on Google Sheets

coinMarketCap.gs

/*
* use =coinMarketCap('ETH') in your sheet
*/
function coinMarketCap(symbol) {
  const url = `https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=${symbol}&convert=EUR`

  const headers = {
    "X-CMC_PRO_API_KEY": 'API_KEY from https://pro.coinmarketcap.com/account'

  };

  const options = {
    "method" : "get",
    "headers" : headers 
  };

  const response = UrlFetchApp.fetch(url, options);
  return JSON.parse(response.getContentText()).data[symbol].quote.EUR.price;
}