Some methods/functions simply do not work in onEdit trigger

Question

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.

Are you trying to get the script executed from an "onEdit" function ? — Serge insas, Jun 29 '15 at 10:03
Yes. (apparently I need 10 more characters to post so here they are) — belteshazzar, Jun 29 '15 at 10:05

score 25 · Accepted Answer · edited Jun 01 '23 at 08:44

25

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...)

edited Jun 01 '23 at 08:44

Dan Dascalescu

143,271
52
317
404

answered Jun 29 '15 at 10:12

Serge insas

45,904
7
105
131

I tried to use this approach but faild in the SpecialOnEdit function I used GmailApp.getThreadById but it showed error ( authorization required ) – sdx11 Feb 23 '18 at 13:05

score 1 · Answer 2 · answered Jul 24 '18 at 09:15

1

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.

answered Jul 24 '18 at 09:15

FDG

720
8
12

Some methods/functions simply do not work in onEdit trigger

2 Answers2

Linked

Related