I thought that I would throw in a similar issue that I had which brought me to this question, where I received the error You don't have permission to call by openById
.
In my case I was trying to call functions from translate.gs
which I copied from this example:
https://developers.google.com/apps-script/quickstart/docs
Note that at the top of translate.gs
/**
* @OnlyCurrentDoc
*
* The above comment directs Apps Script to limit the scope of file
* access for this add-on. It specifies that this add-on will only
* attempt to read or modify the files in which the add-on is used,
* and not all of the user's files. The authorization request message
* presented to users will reflect this limited scope.
*/
The culprit here is the @OnlyCurrentDoc
comment. See here for reference:
https://developers.google.com/apps-script/guides/services/authorization
Removing @OnlyCurrentDoc
fixed this issue for me