u/theguynekstdoor - Randome word

function onOpen(e){
  SpreadsheetApp.getUi().createMenu('Random')
    .addItem('Run','randomWord')
    .addToUi()
}

function randomWord(){
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const inputValuesRaw = ss.getSheetByName('inputSheet')
    .getRange('A2:A')
    .getValues()
    .flat();
  const inputValues = inputValuesRaw.filter(value => { return value != ''});
  const randomIndex = Math.round(Math.random() * inputValues.length);
  const outputSheet = ss.getSheetByName('outputSheet')
    .getRange('B2')
    .setValue(inputValues[randomIndex - 1]);
}