function isHollyday(date) {
  date=new Date(date.setHours(0,0,0,0));
  var spreadsheet = SpreadsheetApp.openByUrl(
     '[paste your google workbook URL here !!!]');
  var regular = spreadsheet.getSheets()[0].getRange("A:A").getValues();
  var iregular = spreadsheet.getSheets()[1].getRange("A:A").getValues();
   for (var i = 0; i < regular.length; i++) {
     if(regular[i][0]!=''){
      
       var year = new Date(date).getYear();
       
      if (new Date(new Date(regular[i][0]).setYear(year )).toString()== date.toString())
      {
        return true;
      }
       
     }
   }
  
  for (var i = 0; i < iregular.length; i++) {
     if(iregular[i][0]!=''){
      
      if (new Date(iregular[i][0]).toString() == date.toString())
      {
        return true;
      }
       
     }
   }
  return false;
}
           
function setHolidaySensor()
{
  var sensorUrl= '[paste your Zipato Virutal switch URL ... it should end by ...state=]';
  if (isHollyday(new Date())==true)                 
  {
    UrlFetchApp.fetch(sensorUrl + '1');
  }
  else
  {
    UrlFetchApp.fetch(sensorUrl + '0');
  } 
  
}