0

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

Rubén
  • 34,714
  • 9
  • 70
  • 166
Midovic
  • 17
  • 5

1 Answers1

1

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

Rubén
  • 34,714
  • 9
  • 70
  • 166