What if you want to make your App Script function accessible to yourself or your stakeholders? You can easily do that and we are going to see how.

Let’s create a simple App Script function

I will be using the accessInput function created in a different post.

function accessInput() {
  var ss = SpreadsheetApp.getActive();
  var s = ss.getSheetByName("Sheet1");
  var cellContent = s.getRange("A1").getValue();
  
  s.getRange("A2").setValue(cellContent);
}

Adding a function to the UI

On open, we will call the Google Sheets UI and add a new menu to it. We will call it “New Menu” - original I know. We will add our accessInput function and call it “Access Input”.

function onOpen() {
  ui = SpreadsheetApp.getUi();
  
  ui.createMenu("New Menu")
  .addItem("Access Input", "accessInput") 
  .addToUi();
};

function accessInput() {
  var ss = SpreadsheetApp.getActive();
  var s = ss.getSheetByName("Sheet1");
  var cellContent = s.getRange("A1").getValue();
  
  s.getRange("A2").setValue(cellContent);
}

Save, close the editor and refresh the Google Sheets. Wait a couple of seconds and you should see the newly created menu appearing now beside Help.

Et voila!