You must be a US citizen to work on this project. We have created a prototype AppSheet app for the Department of Defense and are looking for someone that can integrate the Twilio API to support 2-way text messaging between the user and the app.
Currently, the app includes the following functionality:
- An action allowing the user to create a “recall” event. This action opens a form. In the form, the user selects a unit (group of people) that will receive a message, and writes what the message should say. When the user submits the form, an AppSheet bot sends a text message to all members of the selected unit with the verbiage written by the user, and a link to a public form.
- The text message recipient clicks the link in the text message to the public form. The form asks three questions:
1. Are you safe?
2. What is your location (City/State)?
3. Are you able to go to the muster location?
- The recipient answers the questions in the form, their answers are stored in a Google Sheet, and this data feeds a dashboard with several visualizations in AppSheet.
The following functionality needs to be created:
- Use a custom Twilio account and the Twilio API to facilitate responsive, 2-way texting, as an alternative to the form. For example, in this option, when the user creates a “recall” event, the AppSheet bot should text the recall verbiage to the recipient and ask the first question: “Are you safe? Y/N”. The recipient will text back “Y” or “N”. That response should be logged in a database (Google Sheets), along with the user’s ID, the timestamp of the response, and the recall event ID. The bot should then reply to the recipient with the second question: “What is your location? City, State”. The user will reply with their city/state location. That response should be stored in a database (Google Sheets). The bot should then ask the third and final question: “Are you able to go to the muster location? Y/N”. The recipient will respond with a “Y” or “N”. That response should be stored in a database (Google Sheets).
- Create a bot that sends an email to each of the unit members that contains the same verbiage and link as the text message, when a user creates a “recall” event.
- Modify the “recall” automation so that when a user creates a “recall” event, a text message with a link to the public form AND the email with a link to the public form are both sent to all members of the selected unit. Then, one hour later, the app should identify all the selected unit members who did not complete the public form for this “recall” event, and send a second text message only to those that did not complete the public form for this recall event. This second text message should be the responsive, 2-way text message that uses the custom Twilio API to ask the recipient the three recall questions directly in the text message and logs their responses.
This solution should be scalable to thousands of users.
Please respond with a brief description of how you would create this functionality and examples of similar projects you have completed that demonstrate your competency in a project like this.
Thanks for viewing this posting. We look forward to working with you!