Calling Apps Script URL from email

Hello, I tried with the solution suggested by @LeventK. I developed Apps Script as per his post which is working fine and also executes subsequent actions and workflows and sends mails.

The issue here is that on clicking the “Approve” link, it seems that it is not calling / reaching / executing Apps Script.

When I run Apps Script form the script editor, it works fine.

What could be the issue?