Fonction OnEdit(e) pour faire fonctionner un script sur téléphone

Bonjour j'essaie d'utiliser le code suivant pour le faire fonctionner sur téléphone.

Mais j'ai cette erreur et je ne trouve pas les autorisations pour régler cette erreur "Exception: Vous n'êtes pas autorisé à appeler SpreadsheetApp.openByUrl. Autorisations requises"

function onEdit(e) {
  try {
    var ss = e.source;
    var sheet = e.range.getSheet();
    if (sheet.getName() !== "Formulaire") return;

    var classSelect = sheet.getRange("C7:D7").getValue();
    var semestreSelect = sheet.getRange("C8:D8").getValue();
    var sheetName = sheet.getRange("C9:D9").getValue();

    // URL CLASSE 1APG / CE1 (URL1 FR, URL2 ANG, URL3 MATHS, URL4 ARAB, URL5 EDISLAM)
    if (classSelect === "1APG1" && semestreSelect === "Semestre 1") {
      var source1 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1CP-FR-URL");
      var source2 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1CP-EN-URL");
      var source3 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1CP-MATHS-URL");
      var source4 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1CP-ARAB-URL");
      var source5 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1CP-EDISLAM-URL");
    } else if (classSelect === "1APG1" && semestreSelect === "Semestre 2") {
      var source1 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1QeUEAONkTq099SJsWO0e19Mf7zapgK4OsZrWzwARevM/edit?usp=drive_web&ouid=106557939579314870644");
      var source2 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1b0_osO-l2Ax8VgvKf3xnF8m1KsdwLQTkjkwFBKJmVEk/edit#gid=553498634");
      var source3 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1LN2UvM4F7vXv609CmgZpRjKu44j_Vi79nhECoDVoNN8/edit");
      var source4 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1zvNweoqt4sGSNZMYHSeEazU_mAghyqkmhoE-HVrbPbg/edit?usp=drive_web&ouid=106557939579314870644");
      var source5 = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1Ut0S9aZEYD91qNmRE3vTeI1tqBjeOICyng7MX5PnlHE/edit?usp=drive_web&ouid=106557939579314870644");
    }
    else {
      return;
    }

    // Validation and error handling for Français sheet
    if (!source1.getSheetByName(sheetName)) {
      throw new Error("Sheet named '" + sheetName + "' not found in external sheet");
    }
    var sourceSheet1 = source1.getSheetByName(sheetName);
    var sourceRange1 = sourceSheet1.getRange("B2:D53");
    var data1 = sourceRange1.getValues();
    var targetSheet1 = ss.getSheetByName("Français");
    var targetRange1 = targetSheet1.getRange("A2:C53");
    targetRange1.setValues(data1); 

    // Validation and error handling for Anglais sheet
    if (!source2.getSheetByName(sheetName)) {
      throw new Error("Sheet named '" + sheetName + "' not found in external sheet");
    }
    var sourceSheet2 = source2.getSheetByName(sheetName);
    var sourceRange2 = sourceSheet2.getRange("B2:D53");
    var data2 = sourceRange2.getValues();
    var targetSheet2 = ss.getSheetByName("Anglais");
    var targetRange2 = targetSheet2.getRange("A2:C53");
    targetRange2.setValues(data2);

    //Validation and error handling for Maths sheet
if (!source3.getSheetByName(sheetName)) {
  throw new Error("Sheet named '" + sheetName + "' not found in external sheet");
}
var sourceSheet3 = source3.getSheetByName(sheetName);
var sourceRange3 = sourceSheet3.getRange("B2:D53");
var data3 = sourceRange3.getValues();
var targetSheet3 = ss.getSheetByName("Maths");
var targetRange3 = targetSheet3.getRange("A2:C53");
targetRange3.setValues(data3);

// Validation and error handling for Arabe sheet
if (!source4.getSheetByName(sheetName)) {
  throw new Error("Sheet named '" + sheetName + "' not found in external sheet");
}
var sourceSheet4 = source4.getSheetByName(sheetName);
var sourceRange4 = sourceSheet4.getRange("B2:D53");
var data4 = sourceRange4.getValues();
var targetSheet4 = ss.getSheetByName("Arabe");
var targetRange4 = targetSheet4.getRange("A2:C53");
targetRange4.setValues(data4);

// Validation and error handling for Ed.Islamique sheet
if (!source5.getSheetByName(sheetName)) {
  throw new Error("Sheet named '" + sheetName + "' not found in external sheet");
}
var sourceSheet5 = source5.getSheetByName(sheetName);
var sourceRange5 = sourceSheet5.getRange("B2:D53");
var data5 = sourceRange5.getValues();
var targetSheet5 = ss.getSheetByName("Ed.Islamique");
var targetRange5 = targetSheet5.getRange("A2:C53");
targetRange5.setValues(data5);
} catch(error) {
SpreadsheetApp.getUi().alert(error);
}
}
Rechercher des sujets similaires à "fonction onedit fonctionner script telephone"