Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for SMS Integration

To start sending bulk SMS using Pabbly Connect, first visit the Pabbly Connect website. If you’re a new user, go to pabbl.com/connect and click on “Sign up for free”. This allows you to explore the platform with 100 free tasks every month, which is perfect for sending up to 100 SMS.

Once signed up, you can easily create workflows. Existing users can directly access their dashboard. In this section, you’ll set up a workflow that integrates Google Sheets with Twilio using Pabbly Connect.


2. Creating a Workflow in Pabbly Connect

After logging into Pabbly Connect, you will be directed to the workflow builder. This is where you will set up your trigger and action. Click on the “Add Trigger” button and select Google Sheets as your trigger application.

  • Select “New or Updated Spreadsheet Row” as the trigger event.
  • Click on “Connect” to receive a webhook URL.
  • Copy the webhook URL for later use in Google Sheets.

Now, go to your Google Sheets, navigate to Extensions, and select “Add-ons”. Search for the “Pabbly Connect Webhooks” extension, install it, and refresh your spreadsheet. This integration allows you to send data from your spreadsheet directly to Pabbly Connect.


3. Setting Up Google Sheets with Pabbly Connect

In Google Sheets, after installing the extension, access “Pabbly Connect Webhooks” and go to the initial setup. Paste the copied webhook URL and specify your trigger column. This column will contain the data that triggers SMS sending.

  • Enter the trigger column (e.g., column D for your data).
  • Click “Submit” to save your settings.
  • Send a test response to ensure the connection is successful.

Once you receive a confirmation that the setup is successful, your Google Sheets is now connected to Pabbly Connect. This allows you to automate SMS sending based on data in your spreadsheet.


4. Integrating Twilio for SMS Sending

Next, you will set up Twilio as the action application in your workflow. Click on “Add New Action Step” and select Twilio. Choose the action event as “Send SMS Message” and click on “Connect”.

To connect Twilio with Pabbly Connect, enter your Twilio Account SID and Authorization Token. You can find these details on your Twilio dashboard. Make sure you paste the Account SID twice as required by the interface.


5. Sending Bulk SMS Using Pabbly Connect

With your Twilio account connected, you can now compose your SMS. In the SMS body field, you can map dynamic data from your Google Sheets by using the mapping feature. This allows you to personalize each message sent.

  • Map the recipient’s phone number and the message body.
  • Click “Save and Send Test Request” to verify that the SMS is sent correctly.
  • To send SMS to all contacts, use the “Send All Data” option in the Pabbly Connect Webhooks extension.

Finally, enable the “Send on Event” option in the Pabbly Connect Webhooks settings to automate SMS sending for future entries in your Google Sheets.


Conclusion

Using Pabbly Connect, you can efficiently send bulk SMS in just five minutes by integrating Google Sheets and Twilio. This automation saves time and enhances communication.