Learn how to send bulk SMS for free using Pabbly Connect with this detailed tutorial. Follow the step-by-step process to automate SMS sending from Google Sheets.
Watch Step By Step Video Tutorial Below
1. Setting Up Pabbly Connect for SMS Automation
To send bulk SMS using Pabbly Connect, you first need to access the platform. Open a browser and navigate to Pabbly Connect by searching for pabbl.com/connect. If you are a new user, click on the ‘Sign Up for Free’ button located in the top right corner. This allows you to explore Pabbly Connect with 100 free tasks each month.
Once you have signed up and logged in, you will be directed to the workflow builder. This is where you will create your automation by setting up triggers and actions. The trigger will initiate the workflow, while the action will execute the desired outcome. Click on the ‘Add Trigger’ button to start your setup.
2. Integrating Google Sheets with Pabbly Connect
For this automation, you will need to use Google Sheets to store your leads. In the trigger application, search for Google Sheets and select it. Choose the event as ‘New or Updated Spreadsheet Row’ and click on ‘Connect.’ This will generate a webhook URL that you will need to copy. using Pabbly Connect
- Open your Google Sheets and navigate to Extensions.
- Select Add-ons and then click on Get Add-ons.
- Search for Pabbly Connect Webhooks and install it.
After installing the extension, refresh your Google Sheets. You will now see the Pabbly Connect Webhooks option in the Extensions tab. Click on it and select Initial Setup. Paste the copied webhook URL into the designated field and enter the trigger column, which is typically the last column where data will be added.
3. Sending SMS via Twilio through Pabbly Connect
After setting up Google Sheets, the next step is to send SMS messages using Twilio. In Pabbly Connect, add a new action step and search for Twilio. Select the ‘Send SMS Message’ event and click on ‘Connect.’ If you have previously connected Twilio, you can select the existing connection; otherwise, create a new one. using Pabbly Connect
To establish the connection, you will need your Twilio Account SID and Auth Token. These can be found on your Twilio dashboard. Enter the Account SID twice and the Auth Token in between before clicking on ‘Save.’ Now that Twilio is connected, you can set up the message body for your SMS.
- Craft your SMS message, including dynamic fields like the lead’s name.
- Map the recipient’s phone number from your Google Sheets data.
- Use your Twilio phone number as the sender.
After setting up the SMS details, click on ‘Save and Send Test Request’ to send a test SMS. You should receive a confirmation that the SMS has been sent successfully. This confirms that Pabbly Connect has successfully integrated Google Sheets and Twilio for SMS automation.
4. Sending Bulk SMS to All Contacts
To send bulk SMS to all contacts stored in your Google Sheets, go back to the Pabbly Connect Webhooks option in Google Sheets and click on ‘Send All Data.’ This will trigger the automation to send SMS to all leads listed in your spreadsheet. Ensure that the data is correctly formatted in your sheet to avoid errors. using Pabbly Connect
Additionally, if you want to automate the SMS sending process for any new leads added to your Google Sheets, enable the ‘Send on Event’ option in Pabbly Connect Webhooks. This way, every time a new lead is added, an automated SMS will be sent without any manual intervention.
5. Conclusion: Automate Your SMS Sending with Pabbly Connect
In conclusion, using Pabbly Connect to send bulk SMS is a straightforward process that can significantly enhance your communication strategy. By integrating Google Sheets with Twilio, you can automate SMS sending to your leads effortlessly. This setup not only saves time but also ensures that your messages reach your audience promptly.
Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.
- Check out Pabbly Connect – Automate your business workflows effortlessly!
- Sign Up Free – Start your journey with ease!
- 10,000+ Video Tutorials – Learn step by step!
- Join Pabbly Facebook Group – Connect with 21,000+ like minded people!
Try out this automation for your business using Pabbly Connect and experience the benefits of streamlined communication. With the free trial available, you can explore various automation options that Pabbly Connect offers to improve your operational efficiency.



