onOpen function not launching in the duplicated Google Sheets

My onOpen() function adds 2 buttons in the taskbar of Google Sheets. It used to work perfectly and the buttons appeared even in duplicated sheets. But suddenly it stopped appearing in duplicated files.

What I am currently doing is adding a trigger every time I duplicate the sheet to open it. But I have to run the onOpen() function otherwise it doesn't work.

My function is very simple and basic

function onOpen() {
 
  var ui = SpreadsheetApp.getUi();

  ui.createMenu('Present Data')
    .addItem("Generate Report",'report')
    .addToUi();

  ui.createMenu('Reset')
    .addItem("Meta","resetmetaFunction")
    .addItem("Snapchat","resetsnapFunction")  
    .addItem("TikTok","resettiktokFunction")
    .addItem("Twitter","resettwitterFunction")
    .addItem("Youtube","resetyoutubeFunction")  
    .addItem("Google","resetgoogleFunction")
    .addItem("LinkedIn","resetlinkedinFunction")  
    .addItem("Programmatic","resetprogrammaticFunction")        
    .addItem("Clear All","resetAll")      
    .addToUi();
}

What could possibly cause the script to stop running on startup ?

To be honest the behavior when just duplicating the sheet, should still run the onOpen(), and allow you to see the menu and allow you to see it. However, when clicking on the menu it should request the permissions to access Google Drive and anything else required to run the script. You can report that issue by following the steps here

Note: This is taking into consideration that you have editing permissions in the Google Sheet, and you have access to the Drive file called by DriveApp.getFileById().

Since the script is not authorized yet, and is not triggering the authentication You can try these workarounds for the moment.

The normal flow when you run the script for the first time, you should get an OAuth screen to authorize all the scopes needed by the script. To force this, you have 3 options, first try to run the script manually to force the Authentication of the Script. Using Run.

The second option is to programmatically create an installable trigger. Something like:

function createSpreadsheetOpenTrigger() {
  const ss = SpreadsheetApp.getActive();
  ScriptApp.newTrigger('onOpen')
      .forSpreadsheet(ss)
      .onOpen()
      .create();
}

Before the:

function onOpen() {
 
  var ui = SpreadsheetApp.getUi();

  ui.createMenu('Present Data')
    .addItem("Generate Report",'report')
    .addToUi();

  ui.createMenu('Reset')
    .addItem("Meta","resetmetaFunction")
    .addItem("Snapchat","resetsnapFunction")  
    .addItem("TikTok","resettiktokFunction")
    .addItem("Twitter","resettwitterFunction")
    .addItem("Youtube","resetyoutubeFunction")  
    .addItem("Google","resetgoogleFunction")
    .addItem("LinkedIn","resetlinkedinFunction")  
    .addItem("Programmatic","resetprogrammaticFunction")        
    .addItem("Clear All","resetAll")      
    .addToUi();
}

Last option that you can do is to [manually add the scope](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes
s) on the Apps script Manifest by following the steps:

1. Open the script project.
2. At the left, click Project Settings (gear icon).
3. Select the Show "appsscript.json" manifest file in editor checkbox.
4. At the left, click Editor code.
5. At the left, click the appsscript.json file.
6. Locate the top-level field labeled oauthScopes. If it's not present, you can add it.
7. The oauthScopes field specifies an array of strings. To set the scopes your project uses, replace the contents of this array with the scopes you want it to use.

        "oauthScopes": [
          "https://www.googleapis.com/auth/drive.readonly",
          "https://www.googleapis.com/auth/drivel"
        ]

And it will look like this: