How can I increase the 6 minute execution limit in Google Apps script?
Solution 1
You can workaround by using library called GASRetry
.
See how to add GASRetry
library to your project.
A guide to code changes (you need to apply it to your own specific scenario):
- Change the line
var thingies =
to whatever you want to process. It should ideally be an array. - Add your own code after the
//do our work here
line - Set a Trigger on the function named
outerLoop()
to run every x hours/days. It's OK to rename it to something meaningful to you likedoProcessWidgets()
.
Code:
//automatically invoked from outerLoop()'s creation of a new trigger if required to get work done
function outerLoopRepeating() {
outerLoop();
}
// trigger this function
function outerLoop() {
try {
var processingMessage = 'Initialising', isOverMaxRuntime = false, startTime = new Date(), // calc elapsed time
functionName = arguments.callee.name, repeatingFunctionName = functionName + 'Repeating'; //for logging, triggering
// Deletes all occurrences of the Repeating trigger we don't end up with undeleted time based triggers all over the place
//add library GASRetry MGJu3PS2ZYnANtJ9kyn2vnlLDhaBgl_dE
GASRetry.call(function(){ScriptApp.getProjectTriggers().forEach(function(i) {
if (i.getHandlerFunction() === repeatingFunctionName) {ScriptApp.deleteTrigger(i);}
});});
Logger.log('========== Starting the "%s" function ==========', functionName);
// Handle max execution times in our outer loop
// Get start index if we hit max execution time last run
var start = parseInt(PropertiesService.getScriptProperties().getProperty(functionName + "-start")) || 0;
var thingies = ['stuff to process', 'in an Array',,,,]; //
for (var i = start ; i < thingies.length; i++) {
if (Math.round((new Date() - startTime)/1000) > 300) { //360 seconds is Google Apps Script max run time
//We've hit max runtime.
isOverMaxRuntime = true;
break;
}
//do our work here
Logger.log('Inside the for loop that does the xyz work. i is currently: %d', i);
var processingMessage = Utilities.formatString('%d of %d thingies: %s <%s>', i+1, thingies.length, thingyName, thingyId);
//do our work above here
}
if (isOverMaxRuntime) {
//save state in user/project prop if required
PropertiesService.getScriptProperties().setProperty(functionName + '-start', i);
//create another trigger
GASRetry.call(function(){ScriptApp.newTrigger(repeatingFunctionName).timeBased().everyMinutes(10).create();});
Logger.log('Hit max run time - last iteration completed was i=%s', i-1);
} else {
Logger.log('Done all the work and all iterations');
PropertiesService.getScriptProperties().deleteProperty(functionName + '-start');
Logger.log('Completed processing all %s things with the "%s" function', thingies.length, functionName);
}
} catch (e) {
Logger.log('%s. While processing %s', JSON.stringify(e, null, 2), processingMessage);
throw e;
}
}
Solution 2
For G Suite organizations, as I understand, it's possible to eliminate maximum execution time limit by signing in to Early Access Program. From Quotas for Google Services
Flexible Quotas Early Access
This feature is part of the Early Access feature set. As such only some developers currently have access to it.
Normally, if a script execution exceeds one of the above quotas or limitations, the script execution stops and an appropriate error message is returned. This can potentially leave the script's data in an indefinite state.
Under the flexible quota system, such hard quota limits are removed. Scripts do not stop when they reach a quota limit. Rather, they are delayed until quota becomes available, at which point the script execution resumes. Once quotas begin being used, they are refilled at a regular rate. For reasonable usage, script delays are rare.
If you can't access EAP, there are several workarounds shared on this site. Some workarounds let the script to run until the error occurs, then restart it on the next item to be processed, other scripts just split the work on small enough to avoid the error pieces.
Related Q&A
- Exceeded maximum execution time in Google Apps Script
- Google app script timeout ~ 5 minutes?
- What happens when I "sleep" in GAS ? (execution time limit workaround)
![Garry Jost](https://lh5.googleusercontent.com/-rLJ9J5k1Etw/AAAAAAAAAAI/AAAAAAAAABc/1sUgPWvkLOc/photo.jpg?sz=256)
Garry Jost
Updated on June 04, 2022Comments
-
Garry Jost about 2 years
Is there any way to increase the 6 minute execution time limit for Google Apps Scripts? I thought that the answer might be the Early Access program for G Business Suite. I might be willing to pay $10 a month for G Business Suite, if I could get into the Early Access program, in order to increase the execution limit from 6 minutes to 30 minutes. But an Advisor from the G Suite Help Forum said that Early Access is a limited program, which means that there is no guarantee that I could get that.
Is there any other way to increase the 6 minute execution limit?
Please note that in this question I am not asking for ideas of how to optimize my scripts to fit within the 6 minute limit. (I may ask that in the future, if the answer to this current question is "No, there is no other way.")
Therefore, appropriate answers to this current question are:
- "No, there are no other ways to increase the 6 minute execution limit for Google App Scripts."
- "Yes, there are other ways to increase the 6 minute execution limit, and these are the ways..."
-
Vytautas over 7 yearsTo clarify the answer: there is no way to increase the time limit. The idea is to store where you are in the loop and can we continue with the script. I do urge you to not take this code and just plant it in the script and instead write your own variant as this will not be a suitable format for everyone. I know mine is quite different, as I cannot say how long on average each iteration will take, which is why I calculate the average execution time and compare it to the time left before the 6 minute mark
-
Luk Aron almost 3 yearswhere is the link to apply to extending the time?