// 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