Where is the error in the script? Why does the script "swear"?

Question

Google Sheets

Good day!

I automate the creation of events in the calendar from the table. Here is the code:

spoiler

function SynsToCalendar() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("CALENDAR");
  var lr = sheet.getLastRow();
  
  


  var spreadsheet = SpreadsheetApp.getActiveSheet();
  var calendarId = spreadsheet.getRange('E4').getValue();
    if(sheet.geRange(10, 10).isChecked()===true){  
    
  var eventCal = CalendarApp.getCalendarById(calendarId);
  var lr = spreadsheet.getLastRow();var count = spreadsheet.getRange("A8:F"+lr+"").getValues();
    
 
    for (x=0; x<count.length; x++) {
          var shift = count[x];
      
      var summary = shift[0];
      var startTime = shift[1];
      var endTime = shift[2];
      var guests = shift[3];
      var description = shift[4];
      var location = shift[5]; 
  
      var event = {
          'location': location,
          'description': description,
          'guests':guests +',',
          'sendInvites': 'True',
  
      }
eventCal.createEvent(summary, startTime, endTime, event);
 
sheet.getRange(10, 10).uncheck(); 
    }
  }
};

A trigger to change the table has been created... The idea is that a checkbox is set from the phone that launches the script (example: https://www.youtube.com/watch?v=BeBOtMuEGlA ), but the script does not start the checkbox, the trigger works with an error , and the script itself works, but also swears at the signature mismatch.

The table is built like this ( https://www.machinelearningmastery.ru/creating-cal... )





Please help me correct the errors. You can't do it without professionals. (((

Thanks in advance!

Answer 1

Judging by the log, it is obvious: sheet.ge t Range