Send Automated SMS Directly from Google Sheets

Send Automated SMS Directly from Google Sheets

10 April 2022

Why SMS?

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/ ICApp (intelligent connected app) and very simple to use. No coding skills are required. You can send SMSs to any number of recipients and totally avoid manual work associated with the process.

We use “Google Sheets” as the Trigger app and our “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.

01

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.

    02

  • Choose “Google sheets” as your Trigger app 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 Action App. 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

03

  • First, Select our “Scheduler” as your Trigger app. 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 “Action app” and select the relevant spreadsheet and the range of cells where you have your recipient data.

  • Connect “Rapidomize mobile app’ as your second “Action app” 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 ICApp.

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 ICApps are super easy and takes only a few minutes.

Further, please note that Rapidomize is always available to guide you when you use our integrations.

If you are ready to reach your team of workers, customers, audiences etc. with automated real time or scheduled SMS, which is much faster, easier and reliable, get started with these awesome Rapidomize integrations today itself.


You May Also Like

The Best Free Asana Integration Workflow Platform!

The Best Free Asana Integration Workflow Platform!

Asana is one of the best mobile and web, project management tool available today and has the capacity to help plan, organize, and monitor projects in any industry. It is simple to use, easy to automate and covers your projects from start to end. Why do you need to integrate Asana with other apps? By integrating Asana with the other software applications that you use for your work or business, you can definitely increase the efficiency of your projects further, as it saves a lot of your valuable time (no switching between various apps and reduced repetitive and manual data entering).

Read More
How to Share WordPress Posts on Facebook, Twitter, Instagram, LinkedIn?

How to Share WordPress Posts on Facebook, Twitter, Instagram, LinkedIn?

WordPress? WordPress is an open-source content management system, which is widely used to create websites or blogs free of charge. It is the number one website platform used by majority of websites (43%) WordPress market share statistics 2011-2022 on the internet. RSS? RSS (Really Simple Syndication) is a web feed, which allows users and applications to access updates to websites in a computer-readable format. RSS contains all major details about the contents (author, date of publication, link, full text or summary etc.

Read More
How Software Integration Benefits Small Businesses

How Software Integration Benefits Small Businesses

What are SMEs? SMEs (or SMBs) are small or medium size enterprises/businesses that has their staff head count, and the turnover below a certain defined threshold. SMEs play a very important role in any economy through employment of people, innovation and their contribution to the growth and development of the economy. Why businesses should go digital? The world today is transforming their business models rapidly by using digital technologies to generate new revenue and to add new value.

Read More