Google Sheets Cryptocurrency Converter Script

cryptocurrency-converter.js

function performLookups() {
  convertCrypto('BTC', 'USD', 2, 3);
  convertCrypto('LTC', 'USD', 3, 3);
  convertCrypto('ETH', 'USD', 4, 3);
}

function convertCrypto(symbol, currency, row, column) {
  var url = 'https://min-api.cryptocompare.com/data/price?fsym=' + symbol + '&tsyms=' + currency;
  var response = UrlFetchApp.fetch(url);
  var json = response.getContentText();
  var data = JSON.parse(json);
  Logger.log(data.USD);
  
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.getRange(row, column).setValue(data.USD);
}