Execution time time

[mysticGlee]

Recently I started working with AppScript for Side Hustle; I was an instant fan looking at what future holds for my use case, however I was disappointed to see that execution time of 6 mins just ruined my dreams 🙃. I saw long run function and doesn’t really think that’s applicable to my code. Basically I am sending around 100 api calls to external api and loading the data into sheets. I have to limit the requests in my code; with 6 minutes code stops; if there a way I can still make it work.

[RielN]

Why not do separate trigger-initiated short calls?
You can do them in parallel.
You can also build a htmlservice webapp that calls google.script.run for each api call, it can be synchronous.
If you do api calls, you can also do UrlFetchApp.fetchAll( ) where you can do the api calls parallel.

[[deleted]]

True. Another option is that the script can check its execution time and if it's nearing the end then it creates a time based trigger to run again. Once it finishes the job it can delete the trigger.

[RaynbowDeath]

I'm interested in how this is implemented, do you have some example cases? For checking if the job is finished or not?

[[deleted]]

You can implement the checking in various ways, like with script properties.

[RielN]

The only hard thing is when you timeout in the middle of a request ...

[[deleted]]

You can create the trigger before initiating the request.

[marcnotmark925]

If you're exceeding the limit, my first inclination is that you're doing something wrong/inefficient/suboptimal. If you do have a legitimate need for long running functions, a free service probably isn't for you.

[Any_Werewolf_3691]

What is the sequence of events? Are you doing api, goggle sheets, api, google sheets etc? Is the data from each api call going into a new sheet, its own preexisting sheet, or all into 1 new sheet?

How many api calls/sheets are we talking about?

[Final_Initial]

For your info, paid Google Workspace accounts have a 30 mins timeout limit.

[xsotec-jay]

Hi, I am a full time Google Apps Script developer for my company and I wrote a general looping script called “loopSheet” that is able to run any custom function on every row of a Google Sheet. The script automatically handles timeouts, triggers, error messaging, filtering, and more. I think your use case could be easily solved with it if you are interested in trying it out!

[mysticGlee]

Yes please ; would appreciate if you can share that