Integromat scenario for a restaurant (Catch Phone Number and send 2 sms)

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.

Taidot: PHP, Tietojärjestelmäarkkitehtuuri, JavaScript, Automation

Näytä lisää: script use number send sms, spitfire restaurant dhaka phone, send bulk sms phone open source, find user prepaid number send sms, phone application send sms, send free sms absolutely free desired sender number fake choice bulk, send receive sms cell phone java, windows application send bulk sms gsm phone, send free sms mobile phone, nokia phone interface send receive sms, restaurant order phone, picture phone automatically send via mms, phone automatically send mms, send bulk sms phone, send bulk sms blackberry phone, send receive sms connected phone, prime number of 2, number counter 2 - 12, number counter 2, national restaurant association phone number

Tietoa työnantajasta:
( 28 arvostelua ) Hannover, Germany

Projektin tunnus: #29875500

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

€50 EUR 1 päivässä
(56 arvostelua)

I am engineer with a lot of of experience in the manufacturing industry. I have been developing systems from the ground up in Google Sheets for the last 7 years. You can read about the complete Human Resource Manageme Lisää

€250 EUR 7 päivässä
(2 arvostelua)

Hello, how are you? I'm Gabriel, an expert in business automations. You have been very clear about what you want. Can the SMS content be made on Google sheets as well? Have you developed any part of this scenario yet Lisää

€50 EUR 2 päivässä
(0 arvostelua)

Hey, Disclaimer: Prime facia this whole project looks doable, but I want to be very clear upfront that we may hit some roadblock while designing the solution. In that case I might suggest some alternative. Hoepfully I Lisää

€70 EUR 5 päivässä
(1 arvostelu)