Frenchcooc/!How to open URL via Google Apps Script.md

## !How to open URL via Google Apps Script.md

      
    Raw
  

              !How to open URL via Google Apps Script.md
            
          
    How to open URL via Google Apps Script

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

  
## Code.gs
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");
}

## index.html
<!DOCTYPE html>
<html>

<head>
  <base target="_top">
  <noscript>
    <meta http-equiv="refresh" content="0; url=<?= url ?>" >
  </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>
	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=<?= url ?>" >
	</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>