title: Is it possible to set up a clock trigger in Google Apps to send spreadsheet hourly?
body: <p>I have a spreadsheet that logs incoming answered and missed calls in Google Drive.
  It is currently set to send an email every hour between 10am and 7pm.</p>
  
  <p>Ideally I would like it to not send the email during the weekend.
  Setting up each hour Monday to Friday uses too many triggers.</p>
  
  <p>Is there a way to construct a trigger that will send an email every hour (10am to 7pm) only Monday to Friday?</p>
  
  <p>I've read the documentation at Google and a few (unrelated as it turns out) examples on here and I am stumped!</p>
  
  <p>I tried putting a load of trigger conditions together:</p>
  
  <pre><code>function autoSendHourly() {
  ScriptApp.newTrigger("hourlyUpdate()")
     .timeBased()
     .onWeekDay(ScriptApp.WeekDay.MONDAY)
     .onWeekDay(ScriptApp.WeekDay.TUESDAY)
     .onWeekDay(ScriptApp.WeekDay.WEDNESDAY)
     .onWeekDay(ScriptApp.WeekDay.THURSDAY)
     .onWeekDay(ScriptApp.WeekDay.FRIDAY)
     .atHour(10)
     .atHour(11)
     .atHour(12)
     .atHour(13)
     .atHour(14)
     .atHour(15)
     .atHour(16)
     .atHour(17)
     .atHour(18)
     .atHour(19)
     .create();
  }
  </code></pre>
  
  <p>I wasn't entirely surprised that it didn't work, but I was mildly surprised that it threw up no errors.</p>
  
  <p>Any help (including "you're mad it can't be done") would be greatly appreciated.</p>