App script just 'Fails' with no log information to troubleshoot!

I've created a an app script that works with Appsheets. From appsheet I'm calling a webhook and passing the the URL of the app script.  The app script is designed to create a new Task in Workspace 'My Tasks'.  Based on the appsheet monitor everything runs fine.  But the app script executions Status only says, "Failed".  I have no idea where to start.  Why don't we get better log data?  Can someone help me?

Solved Solved
0 14 3,070
1 ACCEPTED SOLUTION

I think the general workflow would be to create the task in your account and then use the Tasks service to Share that task with the supplied useremail.  I do this all the time when generating Google documents via script.  The final stage of the generation shares the document, gives the user ownership and then removes myself as an editor of the document.  It's convoluted, but is really the only way (currently) to use all Workspace functionality with Appsheet as it doesn't support service accounts.

View solution in original post

14 REPLIES 14