Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Automation

To start automating bulk WhatsApp messaging, you need to access Pabbly Connect. Open your browser and go to pabbl.com/connect. If you are a new user, click on ‘Sign up for free’ in the top right corner to create an account.

Once signed up, you will receive 100 tasks free every month. This allows you to explore the features of Pabbly Connect and test your bulk messaging automation without any cost.


2. Setting Up Google Sheets with Pabbly Connect

Next, you will set up Google Sheets as the trigger application in Pabbly Connect. Click on the ‘Add Trigger’ button and select Google Sheets. Choose the event as ‘New or Updated Spreadsheet Row’ and click ‘Connect’.

Copy the webhook URL provided and open your Google Sheets. Go to Extensions > Add-ons > Get Add-ons, and search for ‘Pabbly Connect Webhooks’. Install this extension to enable the connection.

  • Install the Pabbly Connect Webhooks extension.
  • Refresh your spreadsheet to see the new options.
  • Paste the copied webhook URL in the initial setup of the extension.

After pasting the URL, set the trigger column (e.g., column D) where the data will be added. Click ‘Submit’ to configure the setup successfully.


3. Sending WhatsApp Messages via Pabbly Connect

Now, add a new action step in your Pabbly Connect workflow. Select the application for sending WhatsApp messages, such as Pabbly Chatflow. Choose the event as ‘Send Text Message’.

If you have previously connected Pabbly Chatflow, select the existing connection. If not, you will need to create a new connection by entering the API token from your Pabbly Chatflow dashboard.

  • Access your Pabbly Chatflow account to get the API token.
  • Enter the recipient WhatsApp number and map it from your Google Sheets data.
  • Compose your WhatsApp message, using dynamic fields for personalization.

After setting up the message, click ‘Save and Send Test Request’ to verify if the message is sent successfully through WhatsApp.


4. Automating Bulk Messaging with Pabbly Connect

Once the test message is sent successfully, you can automate bulk messaging. Go back to your Google Sheets, click on Extensions > Pabbly Connect Webhooks, and select ‘Send All Data’. This will send messages to all entries in your spreadsheet.

As messages are sent, you will see the automation in action. This process utilizes the capabilities of Pabbly Connect to ensure that each customer receives their personalized message efficiently.

It’s crucial to ensure that the list you are using for messaging is valid and consists of interested leads. This helps prevent your number from being blocked by WhatsApp.


5. Conclusion

In this tutorial, we demonstrated how to automate bulk WhatsApp messaging using Pabbly Connect. By integrating Google Sheets and WhatsApp API, you can efficiently send personalized messages to your leads.

This automation not only saves time but also enhances communication with your customers. Start using Pabbly Connect today to streamline your messaging processes!