You can create or delete triggers programmatically as shown in the following sample code:
/** * Deletes all the triggers. * */ function deleteTriggers(){ var triggers = ScriptApp.getProjectTriggers(); triggers.forEach(function(trigger){ try{ ScriptApp.deleteTrigger(trigger); } catch(e) { throw e.message; }; Utilities.sleep(1000); }); }; function createTrigger(){ var ss = SpreadsheetApp.getActiveSpreadsheet(); // Create new trigger ScriptApp.newTrigger("sendEmail") .forSpreadsheet(ss).onFormSubmit().create(); };