In this section, we will create a Parent bot that will read the employee spreadsheet and invoke the Child bot so that it sends a text message to each employee on the list.
In the Parent bot, we will initialize the variables required to invoke Twilio. Then, we will open the employee Excel sheet, loop through each detail regarding the employee, and invoke the Child bot with the necessary parameters.
The Child bot will take these parameters and invoke the Twilio REST web service in order to send the text message. The Child bot will return a success or failure response to the Parent bot.
In the Parent bot, we will check this response and log it to a file if the message was sent successfully to each employee. A high-level sequence flow showing this process can be seen here:
Now, we will start configuring the project. We will do this by covering some project groundwork.