Here is my code below. I also have a trigger from spreadsheet on open but that doesn’t seem to work since the menu never shows up. I think something is missing but I can’t point out what.
Can someone please help?
function onOpen(){
doc = DocumentApp.getActiveDocument();
var menudrop = SpreadsheetApp.getUi();
menudrop.createMenu('Refresh Reports');
menudrop.createMenu.addItem('Refresh CO', 'copyClearPasteAUDashboard','combinedLive');
menudrop.createAddonMenu.addItem('Refresh SW', 'copyClearPasteSWDashboard','combinedLive')
menudrop.addToUi();
}