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
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
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
Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect. Start with creating a workflow for your project by clicking on the ‘Create New Workflow’ button. 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. 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. 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. 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. To connect with Google Sheets, you have to paste the copied Webhook URL in your Google Sheet Add-ons section. 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. 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. 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. In this step, we will be adding an action for your trigger. 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. After choosing the application click on the “Connected with Twilio” button to move forward. 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 log in to your Twilio account. 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. Simply paste the account SID and authorization token in the Pabbly Connect dashboard and then click on the “Save” button. After saving your workflow map up all the required fields. Once you are done mapping up all fields click on the “Send Test Request” button. 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. 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. 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.Step 2 : Access Pabbly Connect
Step 3 : WorkFlow for SMS Text Messages to Google Sheet Contacts
(a) Create New Workflow
(b) Name the Workflow
Step 4 : Setting Triggers for SMS Text Messages to Google Sheet Contacts
(a) Select Application you want to Integrate
(b) Copy the Webhook URL
Step 5 : Connecting Google Sheets to Pabbly Connect
(a) Click on Add-ons
(b) Paste the Webhook URL
Step 6 : Test the Submission in Pabbly Connect Dashboard
Step 7 : Setting Action for SMS Text Messages to Google Sheet Contacts
(a) Select Application you want to Integrate
(b) Click on Connect Button
Step 8 : Connecting Twilio to Pabbly Connect
(a) Copy Authorization Token
(b) Add Account SID and Authorization Token
(c) Map the Fields
(d) Send a Test Request
Step 9 : Check Response
Conclusion –
You May Also Like to Read –
