get file size from url

app script

# google sheets app script to get file size in bytes from a url

function getSizes(theurl) {
  const response = UrlFetchApp.fetch(theurl);
  const blob = response.getBlob()
  const size = blob.getBytes().length
  return size
}