Coins

function getCoins(){
  const ss = SpreadsheetApp.getActiveSpreadsheet()
  const sheet = ss.getSheetByName('Coins')

  const response = UrlFetchApp.fetch('https://wallet-api.staging.celsius.network/util/interest/rates')
  const data = JSON.parse(response.getContentText()).interestRates
  const output = [["Coin","Rate","Id","Name","Short"]]
  const images = []

  data.forEach(coin => {
    output.push([coin.coin,coin.rate,coin.currency.id,coin.currency.name,coin.currency.short])
    images.push([`=IMAGE("${coin.currency.image_url}")`])
  })

  sheet.getDataRange().clearContent()

  sheet.getRange(1,1,output.length,5).setValues(output)
  sheet.getRange(1,6).setValue("Image")
  sheet.getRange(2,6,images.length).setFormulas(images)
  sheet.getRange("1:1").setFontWeight('bold')

}