Budget: 50,- €
I need a scenario for Integromat for a restaurant where the phone number and reservation date/time is extracted from the "reservation" email, then saved to a file (e.g. Google Sheet or something) and then an SMS is sent a few hours before the reservation as a reminder and a day later an SMS with the request to rate the restaurant stay online.
The text content of this SMS can also be pulled from a file somewhere, so that it can be changed at any time. Or even address the person by name in the SMS, if you also pull the name as a variable from the email.
The Twilio module can then be used to send the SMS.
For the test, however, would certainly be the help of the integromat app and the own phone first once useful. So you can see if the scenario works without external costs.
The Support from Integromat wrote me following as help, maybe someone of you it helps also:
You would need two scenarios, one that gets the phone numbers from the emails and saves them into a data store and one that pulls the numbers and sends the SMS I'd suggest you to read our article on How to connect Email, Text Parser and Google Sheets, as for the setup in general:
1. The first scenario would contain the part before the pause, and
2. the second scenario would contain the part after it.
The first scenario would end up storing all the necessary information in a Data store together with the current timestamp. The second scenario would periodically check the Data store for records with a timestamp older than the intended delay, retrieve the records, finalize the processing of the data, and remove the records from the Data store.
4 freelanceria on tarjonnut keskimäärin €105 tähän työhön
Hello Sir. Hopefully you are doing great. I am Twilio Expert and yes I can catch number and save it to mysql database and can send sms as well using Twilio. Can you please get back to me right now? Thanks