aknik

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Custom functions')
      .addItem('Look up fragrance notes', 'getFragranceNotes')
      .addToUi();
}

function getFragranceNotes() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var allSheets = ss.getSheets();