Sheet Gurus SMS empowers you to send personalized, bulk SMS messages directly from Google Sheets™, streamlining your communication workflow. Whether you’re managing marketing campaigns, appointment reminders, or internal notifications, this guide will walk you through the process. Click here and install the application by clicking the “Install” button near the top and the extension will automatically be added to your Extensions toolbar inside of Google Sheets.
To start sending text messages from a spreadsheet simply create a new sheet and in the first row put your data headers for the information you have relating to your recipients. You can put anything you want up here, as long as 1 column of your data contains only the phone number of each recipient, 1 per row. Make sure the phone number does not include any hyphens, dashes, parentheses, or spaces. See below for an example.
This is how your data should look when using Sheet Gurus SMS, with the first row being headers, and all subsequent rows containing recipient data. Once you’ve got your data setup in your sheet, you are only a couple button clicks away from sending out dynamic text messages directly from inside your Google Sheet!
First open the extension by clicking Extensions -> Sheet Gurus SMS -> Gurus SMS. Then in the sidebar, enter the column which lists your phone numbers for your recipients. In the above image, that would be Column A.
Below that you can write the message you’d like to send to everyone. Sheet Gurus SMS allows you to create custom variables in your message that will be automatically substituted per-recipient to their specific data.
Note the special {curly brace} syntax found in the message. This is how you insert custom variables, which are described below in more detail. So by surrounding a certain word or phrase with { } you are able to then substitute it with a row-specific value.
Note that the {variable} names you declared should be highlighted in blue. If they aren’t make sure you are using the { }, and not [ ] or ( ). Below your message you are now able to dynamically change the content of each message by selecting which column you’d like to replace your placeholder variables with in your message.
Make sure to take one more look at your message preview below the message box before clicking send. What you see up there is exactly what your recipient will receive, so all of your variables should be automatically substituted in for you.