Post data to Custom URL on Edit Google Script

Question

I want to run a trigger to post data to a URL when a value is added in a Google Sheet.

But as the UrlFetchApp.fetch() does not work on onEdit trigger, is there a turnaround we can do , so I get the value whenever a new value is added in the sheet

You might check this issue tracker 1 that you may use customFunction and connect it to onEdit() to make it work. Note that issue tracker 2, UrlFetchApp is no longer supported in a simple onEdit trigger. You can try the work around that can be found in the issue tracker 1 but as a Googler said that they "disabled Urlfetch in onEdit triggers because to enable this feature may introduce a security concern." Hope this info helps. — Mr.Rebot
– Mr.Rebot, Commented Feb 5, 2017 at 8:16
An "installed" "On Edit" trigger has different permissions than a "simple" "On Edit" trigger. Change the function name from the reserved function name of "onEdit()" to something else, and then click the Resources menu, and "Current project's triggers." — Alan Wells
– Alan Wells, Commented Feb 5, 2017 at 22:58
@StacyThompson Do you mean that you'll accept my comment if posted as answer? — Mr.Rebot
– Mr.Rebot, Commented Feb 6, 2017 at 0:13

Mr.Rebot · Accepted Answer · 2017-02-06 23:29:34Z

1

You might want to check this issue tracker 1 that you may use customFunction and connect it to onEdit() to make it work. Note that issue tracker 2, UrlFetchApp is no longer supported in a simple onEdit trigger. You can try the work around that can be found in the issue tracker 1 but mentioned that they "disabled Urlfetch in onEdit triggers because to enable this feature may introduce a security concern."

Hope this info helps.

answered Feb 6, 2017 at 23:29

Mr.Rebot

6,8092 gold badges19 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Post data to Custom URL on Edit Google Script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related