Google Workspace Marketplace Does Not Review "Menu options not show after App is Installed"

Asked 2 years ago, Updated 2 years ago, 115 views

Hello,

I created an add-on to a Google spreadsheet and applied to Google Workspace Marketplace, but no matter how many times I communicate with them, the reviewer will reject me if I don't see the menu

Please refer to the following

Menu-Menu options not show after App is installed.Please configure
that the add-on correctly uses onInstall() and onOpen() to populate
its menu.The menu items populate when the add-on is first installed
and when a different file is opened.See Editor add-on authorization.

When I do the editor add-on deployment test in my environment, it works fine, so I don't know what the problem is

The code is as follows
必要I omit the contents of functions that I don't think are necessary

functionGlobalVar(userLocale){
  if(userLocale===null)userLocale='ja';
  US>return{
    TITLE: (userLocale=='ja') ?'Copype': 'Copype', // Add-on Title
    VERSION: '1.1.2', // Application Version
  }
}


function onInstall(e){
  onOpen(e);
}


 function onOpen(e){
  varmenu=SpreadsheetApp.getUi().createAddonMenu();
  varuserLocale=Session.getActiveUserLocale(); // Language determination used by the user
  if(userLocale!='ja')userLocale='en'; // English for non-Japanese

  variableInfo = {
    Item1: {func: 'display_sidebar', ja: 'Operation panel display', en: 'Show Sidebar'},
    Item2: { func: 'dispVersion', ja: 'Version Information', en: 'about version'}
  };
  menu.addItem(itemInfo.Item1[userLocale], itemInfo.Item1.func)
    .addSparator()
    .addItem(itemInfo.Item2[userLocale],itemInfo.Item2.func);  

  menu.addToUi(); // Add Menu
}



function askEnabled() {
  let userLocale=Session.getActiveUserLocale();
  let title=GlobalVar(userLocale).TITLE;
  let msg = userLocale === 'ja'? "Script is enabled\nPlease open the menu screen again and let me see the sidebar": "The script has been enabled.\nOpen the menu screen again to display the sidebar.";
  letui=SpreadsheetApp.getUi();
  ui.alert(title, msg, ui.ButtonSet.OK);
  onOpen();
};


function display_sidebar(){
  let userLocale=Session.getActiveUserLocale(); // Language determination used by the user

  let SidebarHTML = HtmlService.createTemplateFromFile('sidebar');
  SidebarHTML.LANGUAGE=userLocale;// Send language information to sidebar
  let Sidebar=SidebarHTML.evaluate().setTitle(GlobalVar(userLocale).TITLE);
  SpreadsheetApp.getUi().showSidebar(Sidebar);//View sidebar 
}


function dispVersion() {
  let userLocale=Session.getActiveUserLocale(); // Language determination used by the user

  Browser.msgBox (GlobalVar(userLocale).TITLE+"Version", 'Version:' + GlobalVar(userLocale).VERSION, Browser.Buttons.OK);
}


function toolTask(TASK_ORDER) {
  return toolTaskRun().start(TASK_ORDER);
}

function toolTaskRun() {
  US>return{
    SPRED: null,
    SHEET: null,
    JOB: null,
    INFO: null,
    TAG_NAME: '_copype_',
    
    init:function(){
      This.SPRED=SpreadsheetApp.getActiveSpreadsheet();
      this.SHEET = this.SPRED.getActiveSheet();
    },
    start:function(TASK_ORDER){
     
    },
    copy: function() {
      
    },
    paste:function(TAISHO){
      
    },
    moveRows:function(){
      
    },
    moveColumns: function() {
      
    },
    
    zettai:function(MODE){
      
    }
  };
}

The manifesto is as follows

{
  "timeZone": "Asia/Tokyo",
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "dependencies": {
    "libraries":[
      {
        "userSymbol": "SetNamedRange",
        "version": "0",
        "libraryId": "1M0tYhnFHYkxl0IXsDju8NWTvWHZWBY8H4-Z7eFOIKyi26p-Ymmtu7C7r",
        "developmentMode"—true
      }
    ]
  },
  "oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/script.container.ui",
    "https://www.googleapis.com/auth/userinfo.email"
  ]
}

I've tried many things and applied for it, but I get the same rejection every time

If anyone knows, please let me know

Thank you for your cooperation

*This content is also being asked in English version of the main house
https://stackoverflow.com/questions/73397896/i-cannot-publish-editor-addon-on-google-workspace-marketplace-menu-options-not

google-apps-script google-workspace

2022-09-30 19:11

1 Answers

I received a reply with the English version of stackoverflow
Resolved
https://stackoverflow.com/a/73406949/19766029

Japanese translation

The result seems to be that if you load your own library in development mode, the library will not be able to integrate well in a non-test environment.

Now it's settled


2022-09-30 19:11

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.