google app script add custom menu functions to sheet

Question

How do I consolidate this code so that all the functions are listed under the same heading (dropdown)? Thanks.

function onOpen ()
{ var sheet = SpreadsheetApp.getActiveSpreadsheet ();  

  var menu = [ {name: "extract e-mail",functionName: "GetAddresses"} ];  
  sheet.addMenu ("Extract E-mail", menu);    

  var menu = [ {name: "remove self",functionName: "readRows"} ];   
  sheet.addMenu ("AOA", menu); 

  var menu = [ {name: "remove duplicates",functionName: "removeDuplicates"} ];  
  sheet.addMenu ("Duplicates", menu); 

  var menu = [ {name: "send e-mail",functionName: "sendEmails"} ];  
  sheet.addMenu ("Mail Merge", menu); 

 }

terrywb · Accepted Answer · 2017-08-09 01:25:59Z

2

You can pass the menu items in as an array of objects.

function onOpen ()
{ 
  var sheet = SpreadsheetApp.getActiveSpreadsheet ();  
  var menu = [ 
    {name: "extract e-mail",functionName: "GetAddresses"},
    {name: "remove self",functionName: "readRows"},
    {name: "remove duplicates",functionName: "removeDuplicates"},
    {name: "send e-mail",functionName: "sendEmails"} 
  ];  
  sheet.addMenu ("Mail Merge", menu); 
 }

answered Aug 9, 2017 at 1:25

terrywb

4,0164 gold badges29 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

testing123 Over a year ago

Excellent. Thanks. Thought it was simple ... I just kept getting syntax errors. Works now.

Collectives™ on Stack Overflow

google app script add custom menu functions to sheet

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related