get_crypto_price.js

// names / ids: https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit#gid=0

function ccprice(name, currencyOpt) {
    var currency = currencyOpt || "usd";

    var url = 'https://api.coingecko.com/api/v3/simple/price?ids=' + name + '&vs_currencies=' + currency.toLowerCase();
    var response = UrlFetchApp.fetch(url);
    var json = response.getContentText();
    var jsonobject = JSON.parse(json);

    var datatoreturn = jsonobject[name][currency.toLowerCase()]
    return datatoreturn;
}