Create new menu item in a spreadsheet

PHOTO EMBED

Tue Feb 22 2022 10:52:10 GMT+0000 (Coordinated Universal Time)

Saved by @massa

// Create new menu item in a spreadsheet:
function onOpen(e) {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('PPC DATA MANAGEMENT')
    .addItem('Update projects data', 'collectSrcTable')
    //.addItem('Sort projects by budget', '')
    .addToUi();
  ui.createMenu('GA API HARVESTER')
    .addItem('1 | Collect ViewIDs in "Config" sheet', 'collectViewID')
    .addItem('2 | Create new UA report', 'runReport')
    .addToUi();
}
content_copyCOPY