Google script - Delay in the function

Question

I am running this code in sequence editor o google sheet. I need the script to run seconds after the spreadsheet is modified. It works but it the delay function is not taking it. what is my error? thanks!!!

 function myFunction(e) {
  var url = 'https://exaple.com/?iwp=run&hash=abc123';
  Utilities.sleep(10000);
  var options = {
 'method': 'get'
 };

  var response = UrlFetchApp.fetch(url, options);
  Logger.log(response);
   }

The url imports the data from google sheet to wordpress. It works perfect if I copy it in the browser. The problem is that it runs before the Google sheet reads the data of the new row (it brings them form) — Jennifer
– Jennifer, Commented Apr 26, 2019 at 3:31
You could use a client side Javascript timer to do this. I have one described here . It would be easy to set up a 10 second timer as long as you don't mind having a sidebar running at the same time. — Cooper
– Cooper, Commented Apr 26, 2019 at 19:16
thanks for your answer. I see it interesting but it can not be done without the bar? — Jennifer
– Jennifer, Commented Apr 29, 2019 at 1:05

Adrian Peh · Accepted Answer · 2019-04-26 07:49:39Z

1

Im not sure about delays but you could try using triggers.It can be set to do an action after the spreadsheet has been updated.

Link:https://developers.google.com/apps-script/guides/triggers/

Link:https://courses.benlcollins.com/courses/apps-script-blastoff/lectures/8427243 (There is a example here)

answered Apr 26, 2019 at 7:49

Adrian Peh

701 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Jennifer Over a year ago

Hi Adrian! I have a configured trigger when I update as the video this import but not the last row. It seems that the problem of time...

Adrian Peh Over a year ago

So there is already a working trigger that will run the program when data is updated in google sheets but the delay is not working?

Jennifer Over a year ago

yes exactly only it works when the trigger is configured by times, like five minutes, etc. when I set the trigger when editing or opening the table it does not work ... although a complete row is created from mysql.

Adrian Peh Over a year ago

Have u tried to take out the delay portion in the script,and set the trigger to happen on data change?

Jennifer Over a year ago

do you mean delete Utilities.sleep(10000);? yes. I ran this code for the first time that i tried.. and with the function configurated on edit . Do you want a screenshot?

|

Collectives™ on Stack Overflow

Google script - Delay in the function

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related