You have to get an access to UI. For an example SpreadsheetApp.getUi().showModelessDialog ... After this call window.open then google.script.host.close(); if you need.
The example https://docs.google.com/spreadsheets/d/1Q9VFiCrbwLwqm5i2y8OJU4RsSuj8qUhocqd1YUzR1p0/copy
⚠️ The end user must also allow the popup for the given URL.
| function onOpen() { | |
| SpreadsheetApp.getUi().createMenu("User Menu").addItem("Open url", "openUrl").addToUi(); | |
| } | |
| function openUrl(){ | |
| var url = SpreadsheetApp.getCurrentCell().getValue(); | |
| var tmp = HtmlService.createTemplateFromFile("index"); | |
| tmp.url = url; | |
| tmp.isUrl = /^(http|www)/.test(url); | |
| var htmlOutput = tmp.evaluate(); | |
| SpreadsheetApp.getUi().showModelessDialog(htmlOutput, "title"); | |
| } |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <base target="_top"> | |
| <noscript> | |
| <meta http-equiv="refresh" content="0; url=https://google.com" > | |
| </noscript> | |
| </head> | |
| <body> | |
| <div id="message"></div> | |
| <script> | |
| var isUrl = <?!= isUrl ?> ; | |
| var url = <?= url ?>; | |
| if (isUrl) { | |
| var newWin = window.open(url, "_blank"); | |
| if(!newWin || newWin.closed || typeof newWin.closed=='undefined'){ | |
| document.getElementById("message").innerHTML = | |
| 'Pop-ups blocked! <a href="https://support.google.com/chrome/answer/95472" target="_blank">Enable</a>.'; | |
| } else { | |
| google.script.host.close(); | |
| } | |
| } else { | |
| document.getElementById("message").innerHTML = `${url} is not an url!`; | |
| } | |
| </script> | |
| </body> | |
| </html> |
Thanks a ton. Its working.