function export1() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lr = ss.getLastRow();
  var cal = CalendarApp.getCalendarById("some ID");

  var data = ss.getRange("E2:H" + lr).getValues();

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

    cal.createAllDayEvent(data[i][0], data[i][1], {location: data[i][2],
guests: data[i][3], sendInvites: true});

    }
}

function exportMail() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lr = ss.getLastRow();
  var cal = CalendarApp.getCalendarById("some ID");

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

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

    cal.createAllDayEvent(data[i][0], data[i][1], {location: data[i][2],
guests: data[i][3], sendInvites: true});

    }
}

//