I want to trigger URL opened in new tab every 10 minutes I tried with this function
function openTab() {
var url = 'https://script.google.com/macros/s/...................../exec';
var html = "<script>window.open('" + url + "');google.script.host.close();</script>";
var userInterface = HtmlService.createHtmlOutput(html);
SpreadsheetApp.getUi().showModalDialog(userInterface, 'Open Tab');
}
but it can't be triggered on simple trigger or installable trigger
I searched a lot but i'm not sure to execute this
Time-Driven triggers can't open dialogs and sidebars, the alternative is to first open a sidebar to put in it client-side code that will open the dialog.
Related