Manage Calendar through GoogleSheet

function addCalendarEvent() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getActiveCell();  // The cell you just edited
  var row = range.getRow();
 
  var task = sheet.getRange(row, 1).getValue(); // Column A: Task
  var date = sheet.getRange(row, 2).getValue(); // Column B: Date (Date object)
  var time = sheet.getRange(row, 3).getValue(); // Column C: Time (Date object or string)
  var statusCell = sheet.getRange(row, 4);      // Column D: Status
 
  if (!date || !time || !task) {
    Logger.log("Missing task/date/time");
    return;
  }
 
  // If time is stored as a Date object (e.g. 10:00 AM), extract hours/minutes
  var startTime = new Date(date); // copy date
  if (time instanceof Date) {
    startTime.setHours(time.getHours());
    startTime.setMinutes(time.getMinutes());
  } else {
    // If time is a string like "10:00", split manually
    var parts = time.split(":");
    startTime.setHours(parts[0]);
    startTime.setMinutes(parts[1] || 0);
  }
 
  var endTime = new Date(startTime.getTime() + 60 * 60 * 1000); // +1 hour
 
  var calendar = CalendarApp.getCalendarById("06fcc75be46e9661bad354847aa07a18a6a9201dde195acb682a3949ae59f695@group.calendar.google.com");
 
  calendar.createEvent(task, startTime, endTime, {
    description: "Created from Google Sheet"
  });
 
  statusCell.setValue("Added ✅");
}