// 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(); }
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter