Adding autocomplete email address list in google script-CodePudding

I am try to add autocomplete list email in my function. Right now, i key in the email address manually, so i have to write or copy all. it should be more efficient if the there autocomplete feature. Here is my code sample:

function getemail(){

  var ui_user = SpreadsheetApp.getUi();

  var result = ui_user.prompt("Enter Receiver Email:");
  return result.getResponseText();

}

is GAS can search our contacts email address then query it all?

CodePudding user response：

Yes, Google Apps Script could be used to search for contacts by using the Contacts Service but it's not possible to add autocomplete feature the Spreadsheet.Ui.prompt. In order to have that feature you will have to create a dialog by using HTML Service, client side code (HTML/CSS/JavaScript) and communicate this code with server code.