Create new menu item in a spreadsheet
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
Comments