CODEWITHSUNDEEP
javascriptgoogle-apps-scriptgoogle-sheets
Midovic
Midovic

Reputation: 17

Trigger URL WebApp every specific Time

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

Upvotes: 0

Views: 58

Answers (1)

Wicket
Wicket

Reputation: 38346

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

Upvotes: 1

Related Questions