1

I am having trouble creating a Trigger in sheets. The error I am getting is "Action Not Allowed" when the code gets to .create(). What I do not understand it I can run this code on a doc in myDrive but if I use this code in a Team Drive sheet it does not allow it. How can I create a Trigger in a team drive sheet/doc?

ScriptApp.newTrigger('myFunction')
     .forSpreadsheet('id')
     .onEdit()
     .create();

I have also tired

.forSpreadsheet(SpreadsheetApp.getActive())
.forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
  • Duplicate of https://stackoverflow.com/questions/46323477/gas-doesnt-allow-pragrammably-create-installable-trigger-in-team-drive – Brian Mar 05 '18 at 18:17
  • Possible duplicate of [GAS doesn't allow pragrammably create installable trigger in Team Drive](https://stackoverflow.com/questions/46323477/gas-doesnt-allow-pragrammably-create-installable-trigger-in-team-drive) – Rubén Jun 01 '18 at 21:16

0 Answers0