How to

How to stop ‘Failures for Google Apps Script’ Emails

Google Scripts is a really useful tool that allows you to run scripted actions on files in Google Docs, Drive, Sheets, Slides, etc. If you are willing to invest a little time in it, then you can probably write your own Google Script. But you will find there are plenty of them available online that you can simply import. In this article, we are going to talk about How to stop ‘Failures for Google Apps Script’ Emails. Let’s begin!

A Google Script, like most other scripts, relies on triggers or certain parameters to run and when those triggers fail to run. The script itself cannot run and ultimately fails. When a script fails to run, you get an email with the subject “failures for Google Apps Script” that tells you which triggers failed. Here is how you can stop getting these emails.

Fix “failures for Google Apps Script”

The first thing you should do is check out which script has a failing trigger. You can find out from the email itself. Decide if the script is still useful for you and if it is not, then it is a good idea to just delete it. If you still need to use the script. You need to figure out why those triggers are failing.

Error Messages

A script can fail for any number of reasons but you generally get one of these error messages in the email. An error message will be accompanied by triggers that are failing.

  • Authorization is required to perform that action
  • Exceeded maximum execution time
  • Service using too much computer time for one day

Analyzing triggers

The “failures for Google Apps Script” email will help here again. Look through it and it will show you two things; filters and triggers that are being used by a script, and that are failing. The subject will tell you which script is having problems e.g., in the screenshot below, I have a script called ‘Google Drive Expiration’ that is failing to run. The trigger that is failing is a time-based trigger that is supposed to expire a file at a certain time. The error message says it needs “authorization to perform the action” which it is unable to get.

First, examine the scripts that are running by visiting this link. If you find the script, you can troubleshoot it. Troubleshooting steps generally depend on the type of script so we cannot go into detail on how to fix a script.

Next, you want to look at the filters and triggers. Visit this link, and select the Filters and the Triggers tab in the column on the left. You will see the triggers that have configured. You can edit them, or delete them. It depends on what you need to do to fix the script. In many cases, you will be able to reapply the trigger and fix the problem.

Delete Triggers | failures for Google Apps Script

It is possible that you once used a script and deleted it later. Its triggers may still exist and they are trying to run but failing which is why you get the email for a failed script run. In that case, you can just delete the trigger and the emails will stop.

If all else fails, you can block the email but we do not advise that you do so if you use a lot of Google Script.

Conclusion

Alright, That was all Folks! I hope you guys like these failures for Google Apps Script article and find it helpful to you.  Give us your feedback on it. Also if you guys have further queries related to this article. Then let us know in the comments section below. We will get back to you shortly.

Have a Great Day!

Also See: User Guide On How To Secure Zoom Bombing

About the author

Windy Moore

Leave a Reply