Google spreadsheet custom menus are not displayed for anonymous users

Question

I've noticed that Google spreadsheet* custom menus (see code below) are not displayed for anonymous users i.e. users who access the spreadsheet directly from the URL (Link to share); you need to sign first.
*The spreadsheet is shared and the the permissions are "Anyone with the link can edit".

Is this the expected behaviour?
Is there any workaround to make custom menus available to users without having to sign-in first?

Code (from Google)**:

function myOnOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [ {name: "Say Hi", functionName: "sayHi"},
                      {name: "Say Hello", functionName: "sayHello"} ];
  ss.addMenu("Tutorial", menuEntries);
}

function sayHi() {
  Browser.msgBox("Hi");
}

function sayHello() {
  Browser.msgBox("Hello");
}

**The onOpen function has been renamed myOnOpen and is associated to an installable trigger. I've verified that it runs in the context of the spreadsheet owner.

TIA,

Olivier

Rubén Rubén · Accepted Answer · 2016-05-02T20:54:55

From an answer by +Samantha to a similar thread in the Google Docs Help Forum

In order for Scripts to run on a Google Sheet, the user must be logged in and have "can edit" rights. This means that anonymous users will not be able to run a Script.

If you would like to see this functionality added to Scripts, I recommend navigating to the Google Developers' Apps Script support page and pressing the "Send Feedback" button.

Note: I just posted the same quote in another answer to a similar question (Showing sidebar for viewers).

Google spreadsheet custom menus are not displayed for anonymous users

2 Answers