2 way sms workflow

Ami · 09-11-2019 09:07 PM

Hello
I need to send 3000 sms to employees every hour to make sure they are ok by them replying back to the sms and if possible, get their location.
I will use a twillio acount as i’m outside the USA.
Can appsheet be used to receive the return sms or do i need something else?

Aleksi

I’m afraid you would need to use 3-party service for that purpose. The SMS should write a record into your database and that you can connect to your app. Do you need to save all replies as a new record or could you update an existing one?

Ami

Hi
Idealy would be to save records rather than updating. So what i thought was to:

Use twillio to send SMS
Use twillio and Zapier to collect replies
View replies in the App.

Any easier way?

Aleksi

You could probably use Appsheet API as well. Are you going to receive 3000 replies every hour as well? 8 hours per day and 5 per week?

Ami

For this project my company used already another App, but the idea is instead of installing an App for all employees in a massive project to be able to send them a SMS every hour for 24 hours a day for the duration of a project for several days.

Grant_Stead

Following

Aleksi

3000employee * 24hours * 7days * 4weeks=2.000.000 records. You would need a SQL database connection for that amount of data.

Ami

I will probably do that, if i can find the right way to accomplish my plan, how can the appsheet API help me?

Aleksi

I would try to find a good receipt for example from IFTTT or Zapier that could save SMS messages to spreadsheet. Then you could use that as a data source for your app.