meetingRoomBooking-02.gs

function meetingRoomBooking() {

  //Set data from Spread Sheet
  var spreadSheetID = "xxxxxx";
  var ss = SpreadsheetApp.openById(spreadSheetID);
  var sheet = ss.getActiveSheet();
  var lastRow = sheet.getLastRow();
  var lastColumn = sheet.getLastColumn();
  
  //Logger.log(lastRow);
  //Logger.log(lastColumn);
  
  //Set data for Google Calendar
  var name = sheet.getRange(lastRow, 2).getValue();
  var phoneNumber = sheet.getRange(lastRow, 3).getValue();
  var roomNumber = sheet.getRange(lastRow, 4).getValue();
  var startDate = new Date(sheet.getRange(lastRow, 5).getValue());
  var endDate = new Date(sheet.getRange(lastRow, 6).getValue());
  Logger.log("name:" + name);
  Logger.log("Phone Number:" + phoneNumber);
  Logger.log("Room Number:" + roomNumber);
  Logger.log("Start Date:" + startDate);
  Logger.log("End Date:" + endDate);
}