gsheets_video_onair

function onEditTrig(e) {
  const ss = e.source,
    sheet = ss.getActiveSheet(),
    range = e.range,
    row = range.getRow(),
    column = range.getColumn(),
    value = range.getValue(),
    dataRow = sheet.getRange(row, 1, 1, sheet.getMaxColumns()).getValues()[0];

  if (column === 2 && value !== '') {
    openUrl(dataRow[0])
    range.setValue('')
  }
}

function openUrl (url) {
  let tmp = HtmlService.createTemplateFromFile("index")
  tmp.url = url
  const htmlOutput = tmp.evaluate()
  htmlOutput.setWidth(750)
  htmlOutput.setHeight(500)
  SpreadsheetApp.getUi().showModelessDialog(htmlOutput, "⏬ Download video...")
}


<!DOCTYPE html>
<html>

<head>
  <base target="_top">
</head>

<body>
  <iframe width="725" height="480" src=<?= url ?> frameborder="0" allowfullscreen></iframe>
</body>
</html>