Nonprofit/Project Description

An Azure Functions (FaaS) Serverless WhatsApp/SMS chatbot that leverages the Twilio API and a MongoDB backend to guide users through educational modules created by Health and Development in Guatemala (HDG), an Emory-based organization.

Ticket Description

Recently, Siri and Manu met with HDG to talk about an issue they were having with their usage of Twilio, an API that this project uses to send mass messages on WhatsApp. The NP are supposed to upload spreadsheets to the application that encode information about how the WhatsApp chatbot should flow through different messages which Twilio is then suppose to parse.

Currently, when an excel spreadsheet is loaded, there are several errors that pop up that are documented in the google doc linked below (where it says "Refer to this for more information"). The errors have sample excel files linked in the google doc below as well. We would like these issues to be resolved, and for the chatbot to work properly. For setup information, please look for at the ReadMe in the associated project.

There is also another repo hdg-inputxlsx that may be of interest to you.

This is a ticket that will require both investigation and development work, which may make it lean towards the heavier side.

Refer to this for more information.

Acceptance Criteria

• Fix Excel Upload Errors on the application

Other Notes

• Ask Manu or Jay for any help!
• Make sure to communicate with other BoG members if needed