Google Spreadsheet 팝업 — onOpen 은 파일을 열 때 도는 예약 이름(단순 트리거)이라 메뉴를 거기서 붙인다.1

function showAlert() {
  const ui = SpreadsheetApp.getUi()
  ui.alert('팝업 창', '표시할 텍스트', ui.ButtonSet.OK)
}

// 메뉴에 추가
function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu('팝업 메뉴')
    .addItem('팝업 띄우기', 'showAlert')
    .addToUi()
}

Footnotes

  1. Simple Triggers - Apps Script: “onOpen(e) runs when a user opens a spreadsheet, document, presentation, or form that the user has permission to edit.” / Class Ui: “Opens a dialog box in the user’s editor with the given title, message, and set of buttons.” ↩

#apps-script
`#337`