HomeContact Us
Guide
Getting Started With Sheet Gurus SMS
Sheet Gurus Team
Sheet Gurus Team
January 25, 2024
2 min

Table Of Contents

01
Step 1: Installing the Addon
02
Step 2: Activating Your Subscription
03
Step 3: Sending Text Messages
Getting Started With Sheet Gurus SMS

Hey there! In this post you’ll find everything you need to get started using Sheet Gurus SMS.

Step 1: Installing the Addon

Let’s make sure you have the extension downloaded from Google Marketplace.

By clicking that link you’ll see the following: Marketplace Download

Click “Install”

A popup will then show asking for permission to install the Sheet Gurus SMS addon.

Marketplace Continue

Click “Continue”

Next, select the Google account that you’d like to use with Sheet Gurus SMS.

marketplace gmail account selector

This should be the same account that you’ve activated your subscription with on sheetgurus.com

After selecting your account you’ll be presented with this dialog Marketplace OAuth permissions

The permissions noted in the dialog allow us to:

  1. Read the data in your Google Sheet to send messages to your recipients.
  2. Create a connection between your Google Sheet and our product server. This is how we send SMS messages after we’ve read the data.
  3. Display our addon in your Google Sheet. This is what really powers up your Google Sheet to allow you to directly message recipients!

Click “Allow”

A dialog will pop up showing where you can access our addon in your Google Sheet menu

marketplace addon highlight

Click “Next”

You’ve now completed your setup and should see this dialog. marketplace installation confirmation

If you haven’t activated your subscription you can click “Complete additional setup now”. This will take you to the Sheet Gurus signup page. Details follow in Step 2.

If you have already activated your subscription. Skip Step 2 and head to Step 3.

Step 2: Activating Your Subscription

Subscription activation starts with payment. sheet gurus payment page

Once payment is completed you’ll land on the verification page. Verification is a critical process that helps protect consumers from spam and illegal SMS communication. The FCC requires verification to be completed for any application based texting. Without completing a verification you will not be allowed to text on Sheet Gurus SMS or any SMS texting application in the world.

Here at Sheet Gurus SMS, we’ve strived to make this process as easy as possible for you. If you run into any questions, please reach out to us at help@sheetgurus.com and we will personally work with you and our SMS providers to get your verification completed.

You’re now ready to start texting! Subscription Confirmation

If you’d like to start crafting your text right away, click the button that says “Go to Google Sheets” at the bottom of the page and head to Step 3.

Step 3: Sending Text Messages

Here’s an example of an empty spreadsheet empty spreadsheet template

Write your phone number with no spaces or dashes in cell A2, along with First Name in Cell B2, Last Name in cell C2, and something in Item A. one row example

Next Click “Extensions” > Sheet Gurus SMS > Gurus SMS to load the Sheet Gurus SMS addon. google sheets menu

Once loaded, you should see the below. addon sidebar

Next, compose your message. For William Shakespeare, I want to ask him if he’s completed Hamlet yet. So I write Hi {First Name} {Last Name} have you finished {Item A} yet? composed message

Before sending, I realize I want to ask Charles Dickens if he’s finished A Tale of Two Cities. Let’s add that to the list too and click “Sync Active Sheet (Sheet1)“. sync sheet example

If you’re satisfied with the messages, click “Send 2 Messages” and your messages will be sent to your recipients.

If you have any additional questions, please reach out to help@sheetgurus.com and we will work with you personally to make sure you have everything you need.


Share

Related Posts

Local Area Code
December 01, 2023
1 min

Quick Links

HomeContact Us