I have scripts in one of spreadsheet document and cannot locate the script

Here's I got this email everyday since I created way before a timer based notification of events. I want to delete the script but I cannot found inside the spreadsheet. What I did, I deleted the file itself and empty the trash. Still I got the google failure notification even the host file was not exist. Anyone knows how to remove/report this problem.

Summary of failures for Google Apps Script: spreadsheet_sms_notifier

Your script, spreadsheet_sms_notifier, has recently failed to finish successfully. A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here.


Error Message Count Authorization is required to perform that action. 275 Start Function Error Message Trigger End 2/4/18 8:19 AM sendsms Authorization is required to perform that action. time-based 2/4/18 8:19 AM 2/4/18 8:20 AM sendsms Authorization is required to perform that action. time-based 2/4/18 8:20 AM 2/4/18 8:21 AM sendsms Authorization is required to perform that action. time-based 2/4/18 8:21 AM ... ..



As you get a "forbidden" error message (mentioned in a comment) perhaps the email notification refers to an add-on. Try to uninstall it.

Another thing to try is to remove the associated trigger. From https://developers.google.com/apps-script/guides/triggers/installable

To review all of the triggers that are associated with your Google account and disable the triggers you no longer need, follow these steps:

  1. Open the script editor by opening any script or visiting https://script.google.com.
  2. Click Edit > All your triggers. If you just created a new script, the script editor will prompt you to give the script a name first.
  3. A dialog will list every simple or installable trigger that is associated with your account. From this dialog, it is not possible to determine which script uses a given trigger, but if you recognize the function name for an installable trigger and know that you don't need the trigger anymore, you can delete the trigger by clicking the X icon to the left of the function name. Simple triggers like onOpen() cannot be disabled from this dialog; instead, you must edit the appropriate script and remove or rename the onOpen() function.


Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.