title: Load sidebar onOpen google Sheets
body: <p>I am trying to load the sidebar when the page opens.  I have important information that i was readily available for them to see.  How can i load the sidebar when page is opened?  I also could do onEdit if need be.  </p>
  
  <pre><code>function onOpen(){
  
    var ui = SpreadsheetApp.getUi()
    .createAddonMenu()
    .addItem('Show sidebar', 'showSidebar')
    .addItem('Show dialog', 'showDialog')
    .addSeparator()
    .addToUi();
  
  // Display sidebar if auto-sidebar is enabled
  showSidebar();
  
  
  SpreadsheetApp.getUi().createMenu('Information')
  .addItem('Help', 'showPicker')
  .addToUi();
  
  SpreadsheetApp.getUi().createMenu('Changelog')
  .addItem('Changelog', 'changeLog')
  .addItem('Show sidebar', 'showSidebar')
  .addToUi();
  
  
  ////Get user name and 
  
  
  var name = SpreadsheetApp.getActive().getSheetByName('Discovery Sheet');
  var email = Session.getActiveUser().getEmail();
  Logger.log(email);
  name.getRange('a38').setValue(email);
  
   }
  </code></pre>
  
  <p>Or like this one?</p>
  
  <pre><code>function OnEdit() {
  
   var html = HtmlService.createHtmlOutputFromFile('Changelog')
    .setTitle('Changelog')
    .setWidth(300);
     SpreadsheetApp.getUi() 
    .showSidebar(html);
  
  }
  </code></pre>