SMS is one of the most direct channels available for real time communication. It is fast, cheap, efficient and delivered in a matter of seconds. The chance of an SMS notification being read within five minutes of its receipt, is more than 90%. Not only that, they are user friendly, secure and reliable. You don’t need internet facilities for SMS and if the phone is powered off or out of range, messages are stored in the network and delivered at the next opportunity. Therefore, SMS is the quickest and easiest way to reach your audience in today’s world.
You can use SMS to send an alert or a reminder to your team or update them instantly on any issue related to your business. SMS can be used to contact your audience or to market (SMS campaigns) your products or services. SMS can be send directly in real time or as per a pre-defined schedule (on a predefined date and time) as per your needs.
What if you automate the sending of SMS?
It will save you a whole lot of your precious time! We have done this for you and now SMS can be send to any number of recipients within a minute or two, using a very simple workflow we have developed for you. We invite you to follow the workflow described here and send thousands of SMSs anywhere in the world in no time.
How do you send SMS directly from Google Sheets in real time?
Rapidomize’s Google sheet and mobile app integration enables you to send SMS automatically from Google sheets to any recipient phone number in real time. This is a readymade integration/
We use “Google Sheets” as the
Trigger app and Rapidomize “mobile app” as the
Action app for this integration. Just connect these two apps and you can send SMS automatically in real time whenever a
Trigger occurs (a new row is added) in your Google Spreadsheet.
How to set up this automation?
It’s super easy! Create a new Google spreadsheet and add the names and phone numbers of your contacts in two separate columns. If needed, you can add the first and last names in two different columns as well.
Remember that the phone number needs to be written in international format. Ex: (412) 503–2345 as 4125032345 – 11 digits/no spaces or parenthesis /no leading zeros.
Choose “Google sheets” as your
Triggerapp and select “When new spreadsheet row” as your
Trigger. Select your Google spreadsheet (where you have the names and phone numbers of recipients) and then select the relevant cell numbers from the drop down menu.
Select “Rapidomize Mobile App” as your
ActionApp. Select “Send a SMS” as the
Action. Finally, select the Google sheet column, which contains the contact number of the recipient. A macro will be created based on your selection.
You can also select the recipient name, if you need to address the recipient by “Name”.
Type the message that needs to be sent to the list of recipients.
Click on “Test” and the automation will be ready. Whenever you add a new recipient to this Google Sheet, the above message will be sent to the new recipient in real time.
How to schedule sending of SMS messages from Google Sheets
First, Select our “Scheduler” as your
Triggerapp. Select timing model as “run once” and provide the “date and time” that you need the SMS to be sent on.
Then select the “Google Sheet” as your first “
Actionapp” and select the relevant spreadsheet and the range of cells where you have your recipient data.
Connect “Rapidomize mobile app’ as your second “
Actionapp” and select the column which contains the phone numbers of recipients from the drop down menu.
Type your message that needs to be sent to recipients in the relevant cage.
Click “Test” and the automation will be ready. The message will be sent to the list of recipients at the specified date and time. You can schedule any number of SMSs to be sent to any number of recipients using this
These two very simple integrations allows you to send SMS in real time or through schedules to local as well as global phone numbers anywhere in the world. Setting these
Further, please note that Rapidomize is always available to guide you when you use our integrations.