Google Apps Script to open a URL

Question

Is there a way to write a google apps script so when ran  a second browser window opens to www google com  or another site of my choice    I am trying to come up with a work-around to my previous question here  Can I add a hyperlink inside a message box of a Google Apps spreadsheet

User · Answer

This function opens a URL without requiring additional user interaction          Open a URL in a new tab      function openUrl  url      var html   HtmlService createHtmlOutput   lt html gt  lt script gt       window close   function   window setTimeout function   google script host close    9         var a   document createElement  a    a href    url     a target   blank        if document createEvent          var event document createEvent  MouseEvents           if navigator userAgent toLowerCase   indexOf  firefox   gt -1  window document body append a                                    event initEvent  click  true true   a dispatchEvent event         else  a click          close          lt  script gt        Offer URL as clickable link in case above code fails       lt body style  word-break break-word font-family sans-serif   gt Failed to open automatically   lt a href    url    target   blank  onclick  window close    gt Click here to proceed lt  a gt   lt  body gt        lt script gt google script host setHeight 40  google script host setWidth 410  lt  script gt        lt  html gt       setWidth  90   setHeight  1      SpreadsheetApp getUi   showModalDialog  html   Opening             This method works by creating a temporary dialog box  so it will not work in contexts where the UI service is not accessible  such as the script editor or a custom G Sheets formula

User · Answer

You can build a small UI that does the job like this    function test    showURL  http   www google com        function showURL href     var app   UiApp createApplication   setHeight 50  setWidth 200     app setTitle  Show URL      var link   app createAnchor  open    href  setId  link      app add link       var doc   SpreadsheetApp getActive      doc show app         If you want to  show  the URL  just change this line like this      var link   app createAnchor href  href  setId  link      EDIT   link to a demo spreadsheet in read only because too many people keep writing unwanted things on it  just make a copy to use instead    EDIT   UiApp was deprecated by Google on 11th Dec 2014  this method could break at any time and needs updating to use HTML service instead   EDIT    below is an implementation using html service   function testNew      showAnchor  Stackoverflow   http   stackoverflow com questions tagged google-apps-script       function showAnchor name url      var html     lt html gt  lt body gt  lt a href    url    target  blank  onclick  google script host close    gt   name   lt  a gt  lt  body gt  lt  html gt      var ui   HtmlService createHtmlOutput html    SpreadsheetApp getUi   showModelessDialog ui  demo

User · Answer

There really isn t a need to create a custom click event as suggested in the bountied answer or  to show the url as suggested in the accepted answer  window open url 1 does open web pages automatically without user interaction  provided pop- up blockers are disabled as is the case with Stephen s answer  openUrl html  lt  DOCTYPE html gt   lt html gt     lt head gt      lt base target  quot  blank quot  gt       lt script gt       var url1   https   stackoverflow com a 54675103        var winRef   window open url1        winRef   google script host close     window alert  Allow popup to redirect you to   url1         window onload function   document getElementById  url   href   url1        lt  script gt     lt  head gt     lt body gt      Kindly allow pop ups lt  br gt      Or  lt a id  url  gt Click here  lt  a gt to continue       lt  body gt   lt  html gt    code gs  function modalUrl      SpreadsheetApp getUi       showModalDialog       HtmlService createHtmlOutputFromFile  openUrl   setHeight 50         Opening StackOverflow

User · Answer

Building of off an earlier example  I think there is a cleaner way of doing this  Create an index html file in your project and using Stephen s code from above  just convert it into an HTML doc    lt  DOCTYPE html gt   lt html gt     lt base target   top  gt     lt script gt      function onSuccess url          var a   document createElement  a           a href   url        a target     blank         window close   function              window setTimeout function               google script host close               9                  if  document createEvent            var event   document createEvent  MouseEvents            if  navigator userAgent toLowerCase   indexOf  firefox    gt  -1              window document body append a                                             event initEvent  click   true  true            a dispatchEvent event           else           a click                  close               function onFailure url          var div   document getElementById  failureContent          var link     lt a href      url      target   blank  gt Process lt  a gt          div innerHtml    Failure to open automatically      link             google script run withSuccessHandler onSuccess  withFailureHandler onFailure  getUrl       lt  script gt     lt body gt       lt div id  failureContent  gt  lt  div gt     lt  body gt     lt script gt      google script host setHeight 40       google script host setWidth 410      lt  script gt   lt  html gt    Then  in your Code gs script  you can have something like the following   function getUrl       return  http   whatever com      function openUrl       var html   HtmlService createHtmlOutputFromFile  index      html setWidth 90  setHeight 1     var ui   SpreadsheetApp getUi   showModalDialog html   Opening

User · Answer

Google Apps Script will not open automatically web pages  but it could be used to display a message with links  buttons that the user could click on them to open the desired web pages or even to use the Window object and methods like addEventListener   to open URLs   It s worth to note that UiApp is now deprecated  From Class UiApp - Google Apps Script - Google Developers     Deprecated  The UI service was deprecated on December 11  2014  To   create user interfaces  use the HTML service instead    The example in the HTML Service linked page is pretty simple    Code gs     Use this code for Google Docs  Forms  or new Sheets  function onOpen       SpreadsheetApp getUi      Or DocumentApp or FormApp         createMenu  Dialog          addItem  Open    openDialog          addToUi       function openDialog       var html   HtmlService createHtmlOutputFromFile  index          setSandboxMode HtmlService SandboxMode IFRAME     SpreadsheetApp getUi      Or DocumentApp or FormApp         showModalDialog html   Dialog title        A customized version of index html to show two hyperlinks   lt a href  http   stackoverflow com  target   blank  gt Stack Overflow lt  a gt   lt br  gt   lt a href  http   meta stackoverflow com   target   blank  gt Meta Stack Overflow lt  a gt

[html] Google Apps Script to open a URL

Examples related to html

Examples related to redirect

Examples related to google-apps-script

Examples related to hyperlink