SMS from Calendar

Hey, I don’t know how to create a script that

  1. finds events from the calendar (Mac) between 8am-10pm
  2. retrieves a phone number saved in notes
  3. sends an SMS with the message “reminder of the appointment” to the person at 8:00am, then 9:00am, etc.
  4. displays a notification message about whether everything was successfully sent.

Has anyone created such a script before?