Send a group SMS message to contacts in your Google Sheets spreadsheet

Software used in this automated workflow example

Google Sheets

Integromat

Make

SMS

Summary

Make (formerly Integromat) can automatically send a group SMS message to contacts in your Google Sheets spreadsheet. Just add an SMS text to a new row in your spreadsheet and specify a target group, and Make (formerly Integromat) will search the spreadsheet for all group members’ phone numbers and send them the message.

Detailed explanations

Step by step instructions

Set up a Google Sheet with the following columns:

'Contact Name'

'Contact Phone Number'

'Target Group'

Create your target groups in the ‘Target Group’ column.
Connect your Google account and select your spreadsheet in the next step.
Select the 'New row' trigger.
Add a 'Find rows' action.
Select the 'Target Group' and 'Phone Number' columns.
Add a 'Send SMS' action.
Enter the phone numbers of your group members in the 'Phone Number' field.
Enter the message you want to send in the 'Message' field.

Business use case example

You could use this template to send out reminders to a group of people. For example, you could add a new row to your Google Sheet with the following information:

'Contact Name': John

'Contact Phone Number': +1 2345 6789

'Target Group': Group 1

The message you enter in the 'Message' field will be sent to John's phone number.

Try ready to use workflow template

Send a group SMS message to contacts in your Google Sheets spreadsheet with Make.com (formerly Integromat)