We will be sending employee notifications by looking up a list of employees in a spreadsheet. The bot will loop through the employee list, read their names and phone numbers, and send Short Message Service (SMS) notifications using the Twilio API. This API will log whether the message was sent successfully or not before moving on to the next employee. The bot continues with this process until all the employees on the list have been processed. The following diagram shows the flowchart for this process:
Now that we've provided a quick overview of what we will do in this project, let's take a closer look at the components we'll be using.