Hello, I have this code that isn't working for me. The idea is that when I open the Google Sheet, this code should execute using the onOpen function to create 3 triggers for my 3 scripts. The problem lies in some permissions when the createTriggers function is called, which throws the following error: 'You do not have permission to call ScriptApp.newTrigger. Required permissions:
http://www.googleapis.com' (a link that doesn't go anywhere).
Here's the code:
function onOpen() {
var properties = PropertiesService.getUserProperties();
var triggersCreated = properties.getProperty('triggersCreated');
if (triggersCreated === 'true') {
// Show message if triggers already exist
SpreadsheetApp.getUi().alert('Production has already been initiated previously.');
} else {
// Create triggers if they don't exist
createTriggers();
// Mark triggers as created
properties.setProperty('triggersCreated', 'true');
}
}
function createTriggers() {
var spreadsheetId = SpreadsheetApp.getActiveSpreadsheet().getId();
ScriptApp.newTrigger('onEdit2')
.forSpreadsheet(spreadsheetId)
.onEdit()
.create();
ScriptApp.newTrigger('onEdit3')
.forSpreadsheet(spreadsheetId)
.onEdit()
.create();
ScriptApp.newTrigger('onEdit4')
.forSpreadsheet(spreadsheetId)
.onEdit()
.create();
}
If anyone knows how to solve this permission issue, it would be greatly appreciated. Thank you very much!