metabase-google-sheets-add-on
metabase-google-sheets-add-on copied to clipboard
Can't see functions after publishing the add-on
If I run the script as a Google App-script, it works as great
but if I publish the add-on, the functions disappear, and I can only see the "help" option
For reference, I solved it by tweaking the onOpen() function as below
function onOpen() {
var ui = SpreadsheetApp.getUi().createAddonMenu();
ui.addItem('Import Question', 'importQuestion');
ui.addItem('Import All Questions', 'importAllQuestions');
ui.addToUi();
}