Task API in a Google Sheets custom formula in GoogleAppScript

[Jake Green]

And again, I have a question for the Google developer community.

Please answer, how to implement authentication \ authorization for the Task API in a Google Sheets custom formula in my Google script (for each current user of this sheet-document)? That is, I need the custom formula to process an event from Google Tasks, but an access error occurs.

(my apologies for the Google translator from Russian)

[Andrew Roberts]

If you are getting this error:

"You do not have permission to call X service."

Your custom function is not able to access the Task API - see here for more details.

Although I see "UrlFetch" is there in the list of allowable services.

P.S. I've got to say that Russian translator is working pretty well!

[Jake Green]

Thank you, your answer helped me move forward. But, unfortunately, I learned that: “Unlike most other types of application scripts, user functions never ask users to allow access to personal data. Therefore, they can only call services that do not have access to personal data. ”

My verdict: Google TasksAPI  to use in custom functions is not possible

[Clark Lind]

Theoretically, if you created a script that accessed the TaskAPI and the script provided the output you needed, you could publish that script as a webApp, then use UrlFetch to access the published script url. You should be able to send parameters with the urlFetch request, giving some dynamic interaction. (theoretically).