Get user input

PHOTO EMBED

Thu Feb 03 2022 17:20:16 GMT+0000 (Coordinated Universal Time)

Saved by @MakiProductions 

function promptUserForInput(promptText) {
  var ui = SpreadsheetApp.getUi();
  var prompt = ui.prompt(promptText);
  var response = prompt.getResponseText();
  return response;
}
content_copyCOPY