Google Apps Script trigger quota and limitations -
i use form submit trigger form processing on spreadsheets. form submit process may take while complete(approximately 30secs). responses submitted in form trigger's processing time may exceed quota of triggers run time 6 hours google apps work/edu/gov. number of triggers per script limit 20.
are there workarounds these problem.
it may depend on type of quota is. provided in document - best practices, list improve performance of scripts.
- minimize calls other services
- use batch operations
- avoid libraries in ui-heavy scripts
- use cache service
also, blog google apps script talks workarounds quotas increase code complexity adding delays, increasing intervals of each functions , splitting of script smaller parts.
hope helps.
Comments
Post a Comment