openSheet_sendReminder.gs

function sendReminder() {
  console.log(checkDay());
  if (checkDay() == false) { // weekend
    return;
  }

  var lastRow = remindSheet.getLastRow();
  if (lastRow > 0) {
    var ids = remindSheet.getSheetValues(1,1,lastRow,1);
    for(var i = 0; i < lastRow; i++){
      pushMsg("嗨嗨打卡了嗎~",ids[i][0]);   // "Hi, please remember to punch~"
    }
  }
}

 function checkDay() {
  var day = new Date().toLocaleString("en-US", {
    timeZone: "Asia/Taipei",
  });
  var dayOfWeek = new Date(day).getDay();

  if (dayOfWeek == 0 || dayOfWeek == 6) {
    return false;
  } else {
    return true;
  } 
}