Do you ever think about if there is any way through which you can send text messages to your contacts from Google Sheets directly without even using a mobile phone?

Well, you don’t have to be surprised to know that there is a way through which you can send bulk SMS to Google Sheet contacts directly, without investing a lot of time. We have a magic tool for all your projects called Pabbly Connect. This software allows you to integrate two or more than two applications to automate the entire workflow without any coding skills.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect

Apart from the integrations, Pabbly Connect also comes with so many great and helpful features:

  • Create unlimited workflows without any restrictions
  • Unlimited premium apps
  • Set unlimited triggers, unlimited actions to those triggers
  • Path Routers

and the best part is that you can access all the features even with the free plan.

After this integration with Google Sheet, you can easily send bulk text messages to your Google Sheet contacts with just a few clicks. Hence, let’s not waste anymore of your time and get into the blog about how to send text messages directly from Google Sheets.

Step 1 : Sign up to Pabbly Connect

Sign Up

Let’s begin the integration process by signing up for Pabbly Connect. Quickly fill in the details manually or sign-up via your Google account.

Try Pabbly Connect for FREE

Step 2 : Access Pabbly Connect

Select Connect

Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect.

Step 3 : WorkFlow for SMS Text Messages to Google Sheet Contacts

(a) Create New Workflow

Create New Workflow

Start with creating a workflow for your project by clicking on the ‘Create New Workflow’ button.

(b) Name the Workflow

How to Send Text Messages Directly from Google Sheets

Now, you need to name the workflow just like in the above-shown image. I named the workflow as “Send SMS to Google Sheet Contacts”, you can obviously name the workflow as per your requirements and needs.

Step 4 : Setting Triggers for SMS Text Messages to Google Sheet Contacts

As soon as you are done with creating a workflow, you will have to select the application you want to integrate. Using Pabbly Connect, you can integrate any two or more than two applications, create your free account now.

(a) Select Application you want to Integrate

How to Send Text Messages Directly from Google Sheets

Now, you have to select the application that you want to integrate. In this case, we are choosing “Google Sheets” for integration. After selecting Google Sheets, choose “New Spreadsheet Row” in the method section.

(b) Copy the Webhook URL

How to Send Text Messages Directly from Google Sheets

After selecting the application, now you have to copy the webhook URL just like in the above-shown image to take further the integration process.

Step 5 : Connecting Google Sheets to Pabbly Connect

To connect with Google Sheets, you have to paste the copied Webhook URL in your Google Sheet Add-ons section.

(a) Click on Add-ons

How to Send Text Messages Directly from Google Sheets

Go to your Google Sheet that you want to integrate and click on the “Add-ons” option above and then select the add-ons. We have selected “Pabbly Connect Webhooks” and if you don’t have them, then you can also install the add-ons from “Get add-ons” section. After this, select the “Initial Setup” option to paste the webhook URL.

(b) Paste the Webhook URL

Paste the Url

After selecting the “Initial Set-up” paste the copied webhook URL. Once you have pasted the URL, now you have to mention the trigger column and then click on the “Send Test” button.

Step 6 : Test the Submission in Pabbly Connect Dashboard 

Capture Webhook Response

To test the Google Sheet data you have to click on “Capture Webhook Response” in Pabbly Connect. As soon as you click on the “Send Test” in Google Sheet and “Capture Webhook Response” in Pabbly Connect the entry will appear on the Pabbly Connect dashboard. Then, click on the “Save” option.

Step 7 : Setting Action for SMS Text Messages to Google Sheet Contacts

In this step, we will be adding an action for your trigger.

(a) Select Application you want to Integrate

Select Twilio

Now in this step, click on the + button below and choose any of the SMS sending application that you want to integrate. Here we have chosen “Twilio” to integrate.

(b) Click on Connect Button

Click on Connect Button

After choosing the application click on the “Connected with Twilio” button to move forward.

Step 8 : Connecting Twilio to Pabbly Connect

To connect Twilio to Pabbly Connect, you have to enter the account SID and authorization token of your Twilio account in the Pabbly Connect dashboard. For this, you have to login to your Twilio account.

(a) Copy Authorization Token

Copy Account SID

Now, you have to click on “Setting” in your Twilio dashboard to copy the account SID and authorization token. After clicking on “Settings” click on “General”, here you will find the required details. Simply copy these details to move further.

(a) Add Account SID and Authorization Token

Paste the API Key

Simply paste the account SID and authorization token in the Pabbly Connect dashboard and then click on the “Save” button.

(b) Map the Feilds

Map the Feilds

After saving your workflow map up all the required fields.

(c) Send a Test Request

Test Request

Once you are done mapping up all feilds click on the “Send Test Request” button.

How to Send Text Messages Directly from Google Sheets

You can see as you send a test request, the SMS is delivered to the recipient picked from the Google Sheet. Now, whenever you want to send SMS automatically to bulk recipients you can choose in add-ons “Send All Data” while doing the integration.

Step 9 : Check Response

How to Send Text Messages Directly from Google Sheets

Here, you can see the integration was successful and the SMS has been delivered to the contact picked from Google Sheet automatically. Now in a similar way, you can send SMS to bulk contacts picked from Google Sheets.

Conclusion –

Good job my friend! Now that you have learned how you can send text messages directly from Google Sheets, you can integrate any applications via Pabbly Connect to automate your entire workflow without any coding skills. Pabbly Connect is the magic wand that you can use to automate your projects and save a lot of time and effort. Therefore, signup for a free account now for the best integration experience. In case of any doubts or suggestions, please leave your comments below.

You May Also Like to Read –