You do not have permission to call openById

by

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

More Related Contents:

  1. Custom Functions with add-ons?
  2. No permission to call msgBox in Google Apps Scripting
  3. Detect user inserting row or column in a google spreadsheet and reacting in a script
  4. Google apps script error: “You do not have permission to call protect” [duplicate]
  5. Use script in all spreadsheets
  6. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  7. Publish an add-on privately
  8. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  9. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  10. Google Sheets OnEdit() – You do not have permission to call a service
  11. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  12. Format a Google Sheets cell in plaintext via Apps Script
  13. UiApp has been deprecated. Please use HtmlService instead
  14. Google app scripts: email a spreadsheet as excel
  15. Is there a way to keep two sheets synchronized?
  16. Moving Files In Google Drive Using Google Script
  17. onEdit simple trigger never seems to be triggered
  18. How to get filtered values from Filter after using setColumnFilterCriteria?
  19. Protect ranges with google apps script
  20. How to access new ‘in-cell-image’ from google apps script?
  21. How to convert a Google Sheets-File to an Excel-File (XLSX)
  22. Difference between getValue() and getDisplayValue() on google app script
  23. How to allow onEdit function to affect protected cell in a Google Sheet?
  24. Creating and Sending sheets in the same function
  25. How do I know if spreadsheet cells are merged using google apps script
  26. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  27. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  28. .setFormula() and received error missing ) argument list
  29. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?
  30. Passing cell references to spreadsheet functions

Leave a Comment