Deploying Google Apps Script

Question

I have found this fantastic script to convert a document to a PDF and automatically save it to a users Drive account, however I'd now like to deploy a button on the toolbar for all of our users that will allow them to run this script at the click of a button.

Is this possible? If so, how is it done?

score 1 · Accepted Answer · answered Aug 16 '15 at 16:46

You can create new Menu on the toolbar with following code. When user clicks the menu item, your script (convertPDF function) will be executed. You can refer this documentation for more details.

function onOpen() {
  var menuEntries = [
    {name: 'Export PDF', functionName: 'convertPDF'},
  ];
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  ss.addMenu('PDF', menuEntries);
}

score 0 · Answer 2 · answered Aug 11 '15 at 17:12

With Spreadsheet.getUi object you can add new options in the menu. Check this documentation that explains this process and how to associate your functions to the items in the menu.

In the example is also used the Trigger "OnOpen". Which will run the functionality that adds the new menu items every time the file is opened.

Deploying Google Apps Script

2 Answers2