CREATE GOOGLE APP SCRIPT TO AUTO SYNC & CREATE CALENDAR EVENT WITH NO DUPLICATES

I have written a script however it will not work

I will create template google sheets for each staff member
the sheet will sync to a new google calendar created by myself
I will link this calendar to each new sheet via the script code

I need to sheets to auto sync to the new calendars with

TITLE
START TIME & DATE
END TIME & DATE
LOCATION
DESCRIPTION

EMAIL CREATION TO SEND TO THE CLIENT BODY TAKEN FROM A CELL WITH SUBJECT ALSO FROM CELL

CIODE BELOW


function createcalendarjobs() {

var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lr = ss.getLastRow();
var ryanshannon = CalendarApp.getCalendarById("@group.calendar.google.com");




var data = ss.getRange("A2:G" + lr).getValues();

for(var i = 0;i<data.length;i++){

ryanshannon.createEvent(data[i][2],data[i][1], data[i][2], {location: data[i][4], decsription: data[i][3] });



//Logger.log('Event ID: ' + event.getId());
//ryanshannon.createEvent(data[i]['2'],data[i][0], data[i][1], {location: data[i][4], decsription: data[i][3] });

//Logger.log(data[i][2]);
// data[i][2], data[i][0], data[i][1], {location: data[i][4], decsription: data[i][3] }
}


// var eventCal = CalendarApp.getCalendarById("@group.calendar.google.com");



}