Random roulette app for GoogleSpreadsheet(GAS). Deploy and HTTP GET!

GAS_roulette

function doGet(e) {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName("フォームの回答 1");
  var range = sheet.getRange("B2:B");
  var values = range.getValues();
  values = values.filter(String).map(v=>v[0]);
//  console.info(values);
  var value = values.length > 0 ? values[Math.floor(Math.random()*values.length)] : "まだ投稿されていない";
//  console.info(value);

  var output = ContentService.createTextOutput(value);
  output.setMimeType(ContentService.MimeType.TEXT);
  return output;
}