meal-plan.gs

// Google sheets to calendar.

function myFunction() {
  var sheets = SpreadsheetApp.getActive().getSheets();
  
  var cal = CalendarApp.getCalendarsByName('Meal Plan')[0];
  if (cal) {
    cal.deleteCalendar();
  }
  cal = CalendarApp.createCalendar('Meal Plan', {
    color: CalendarApp.Color.YELLOW
  });
  
  var weeklyRecurrence = CalendarApp.newRecurrence().addWeeklyRule().interval(sheets.length - 1);
  
  var initialDate = new Date(Date.UTC(2017, 4, 22)); // 22nd May 2017
  
  for (var i = 1; i<sheets.length; i++) {
    var sheet = sheets[i];
    var data = sheet.getDataRange().getValues();
    
    for (var j = 0; j<data.length; j++) {
      var nameOfMeal = data[j][1];
      
      var startDate = new Date(initialDate.valueOf());
      startDate.setDate(startDate.getDate() + ((i-1) * 7 +j));
      
      cal.createAllDayEventSeries(nameOfMeal, startDate, weeklyRecurrence)
    }
  }
}