Tweaks on Google Calendar API

Hi. I have a spreadsheet ([login to view URL]) that I want to integrate with Google Calendar and I already have a code that does that for me. However, I need the code to be tweaked so that: 1. one of the columns allows me to set the events to ALL DAY on Google Calendar; 2. one of the columns allows me to set the frequency of the events (daily, annualy etc.); 3. the code updates the calendar, instead of creating new events each time I run the script. BELOW IS THE CODE: function create_Events(){ var ss = [login to view URL](); var sheet = [login to view URL]("Teste"); var last_row = [login to view URL](); var data = [login to view URL]("A1:E" + last_row).getValues(); var cal = [login to view URL]("calendarname"); //[login to view URL](data); for(var i = 0;i< [login to view URL];i++){ // index 0 = Nome do Evento // index 1 = Data e hora iniciais // index 2 = Data e hora finais // index 3 = Descricao // index 4 = Cor var Events = [login to view URL](data[i][0], new Date(data[i][1]), new Date(data[i][2]), {description: data[i][3], colorID: data[i][4]}); //[login to view URL]('Event ID: ' + [login to view URL]()); } [login to view URL]("Eventos criados com sucesso"); }