Google Form passes data to sheet correctly but sheet2cal script creates a calendar event with "0.0" time and fails to bring over details of events
18:57 01 Feb 2026

Unlinked and created new form and debug shows all variable data when run. Events are created in Calendar with "0.0", no Start and Stop times or event text. Odd as it's worked without fail for years :

function createCalendarEvent() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var calendar = CalendarApp.getCalendarById('plazamarinamgr@gmail.com');
 
  var startRow = 2;  // First row of data to process-2 exempts header row
  var numRows = sheet.getLastRow(); // Number of rows to process
  var numColumns = sheet.getLastColumn();
 
  var dataRange = sheet.getRange(startRow, 1, numRows-1, numColumns);
  var data = dataRange.getValues();
 
  var complete = "Done";
 
  for (var i = 0; i < data.length; ++i){
    var row = data[i];
    var timestamp = row[0]; //Timestamp
    var Duration = row[1]; //Duration
    var Contact = row[2]; //Contact
    var Phone = row[3]; //Phone
    var Email = row[4]; //Email
    var Address = row[5]; //Address
    var City = row[6]; //City
    var State = row[7]; //State
    var Zip = row[8]; //Zip
    var Start = row[9]; new Date //Start
    var End = row[10]; new Date //End
    var Type = row[11]; //Type
    var Make = row[12]; //Make
    var Length = row[13]; //Length
    var Beam = row[14]; //Beam
    var Draft = row[15]; //Draft
    var Electrical = row[16]; //Electrical
    var Notes = row[17]; //Notes
    var eventID = row[18]; //event marked Done
      if (eventID != complete){
      var currentCell = sheet.getRange (startRow + i, numColumns);  calendar.createEvent(Duration +' - '+Contact +' [P]',Start, End,{description:+Phone +' | '+Email+' | '+Type-'+Type+'|'+Make +' | Length-'+Length+'|+Beam-'+Beam +'| Draft-'+Draft+'|Electrical-'+Electrical+' |Notes-'+Notes +[P]ending [+]Confirmed [X]NoAvail [0]NoShow [1]Bill NOTE:24HR CANCELLATION REQUIRED'});
      currentCell.setValue(complete); 
arrays events google-calendar-api event-id