get eth wallet in google sheets

gistfile1.txt

function fetchJSON(url) {
  var response = UrlFetchApp.fetch(url);
  return JSON.parse(response.getContentText());
}

function ETHWALLET(address, token) {
  if (address && token) {
    var token = token + '';
    var url = 'https://api.ethplorer.io/getAddressInfo/' + address + '?apiKey=freekey';
    var val = fetchJSON(url);

    // ETH is special case in API response
    if (token === 'ETH') {
      return val['ETH']['balance'];
    }
    else {
      // look for our token
      var ts = val['tokens'];
      for (var i = 0; i < ts.length; i++) {
        if (ts[i]['tokenInfo']['symbol'] === token) {
         return ts[i].balance * Math.pow(10, -ts[i]['tokenInfo']['decimals']);
        }
      }
     // token not found
     return 0;
    }
  }
  return 0;
}