1

I am creating a visual folder tree of my google drive in a spreadsheet (google sheets). However due to the size of the drive and using a BFS algorithm, I have to stop the script at a certain runtime and then restart from where it left off using a timed trigger.

Using the timed trigger creates issues with the data on the sheet (too specific to get into) but more importantly, it reaches the quota for when running and I get the service error.

My question is that can anyone think of a way or knows a way to bypass this issue and have the script run via some other way.

One thing I have considered: -Activating remotely using a button on the sheet (but how to activate this button) since using manual triggering does not cause any problems.

Improve this question
2
  • Have you tried using time delays? Like setTimeout()? Commented Sep 14, 2017 at 5:13
  • In what way are you suggesting using the setTimeout()? Commented Sep 15, 2017 at 13:27
Related questions
3
Programmatic create timebased trigger for spreadsheet
0
How to implement a trigger or timer that runs after a few seconds using GAS
1
Handling time duration in Google Sheets Api
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.