Reputation: 2213
I'm looking to call UrlFetchApp.fetch()
based on user input on a sheet but nothing happens. No errors, just silently ignores the call. Same goes for MailApp.sendEmail()
and GmailApp.sendEmail()
This is on a Google Apps domain, and only domain users are using the Google Sheet.
Upvotes: 17
Views: 8463
Reputation: 46822
Simple triggers like onOpen
or onEdit
are not able to do anything that requires authorization like sending mails because they run silently and anonymously.
This is explained in the documentation and discussed in this Google Apps Script community thread.
You should simply rename your onEdit
function to something else - SpecialOnEdit
for example ? - and create an installable trigger (documentation) from the script editor menu (ressources/triggers/create a new trigger...)
Upvotes: 26
Reputation: 810
You can see an execution flow in view -> execution transcript in the script editor. Just change a cell value in spreadsheet then come back the script editor and check "execution transcript". It will show you an error if it happens.
Upvotes: 1