google script openById : You do not have permission to perform that action

by

Installable Triggers

There are two types of OnEdit trigger. Installable triggers are able to ‘alter another file’, see: https://developers.google.com/apps-script/guides/triggers/installable

@kusi supplied the answer as a comment, just adding it here.

More Related Contents:

  1. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  2. Google Sheets OnEdit() – You do not have permission to call a service
  3. Google app scripts: email a spreadsheet as excel
  4. Moving Files In Google Drive Using Google Script
  5. Copying a spreadsheet copies all linked files as well
  6. onEdit simple trigger never seems to be triggered
  7. “SpreadsheetApp.getUi() cannot be called from this context”
  8. How to convert a Google Sheets-File to an Excel-File (XLSX)
  9. How to allow onEdit function to affect protected cell in a Google Sheet?
  10. Script to convert .XLSX to Google Sheet and move converted file
  11. Converting .xls to google spreadsheet in google apps script
  12. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  13. e.range.getA1Notation() unable to track changes caused by formula update
  14. Merging or Combining two onEdit trigger functions
  15. Detect user inserting row or column in a google spreadsheet and reacting in a script
  16. How to get onFormSubmit to trigger automatically?
  17. Using built-in spreadsheet functions in a script
  18. Can no longer produce PDF from Google Sheets spreadsheet for some of the users
  19. Google script replaceAllShapesWithImage with image from drive doesn”t work any more
  20. Dynamically creating spreadsheet menu items
  21. Creating a zip file inside Google Drive with Apps Script
  22. Best Practices for Multiple OnEdit Functions
  23. How to ignore empty cell values for getRange().getValues()
  24. How to make onEdit() trigger function apply to multiple sheets
  25. Iterate over range, append string to each
  26. Can the google spreadsheet ‘query’ function be used in google apps script?
  27. How to pause App Scripts until spreadsheet finishes calculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. Convert a gdoc into image

Leave a Comment