Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for WhatsApp Integration

To send bulk WhatsApp messages directly from Google Sheets, you need to start by accessing Pabbly Connect. Begin by logging into your Pabbly Connect account or create a new one if you haven’t already.

Once logged in, navigate to the workflow builder. This is where you will set up the automation to facilitate sending messages. Make sure to utilize the free trial offered by Pabbly Connect to send up to 100 WhatsApp messages without any cost.

2. Setting Up Google Sheets Trigger in Pabbly Connect

In this step, you will configure Google Sheets as your trigger application within Pabbly Connect. Click on the “Add Trigger” button and select “Google Sheets” from the application list. Choose the event as “New Row or Updated Row in Spreadsheet” and click on “Connect”.

  • Select your specific Google Sheet containing lead information.
  • Make sure to copy the webhook URL provided by Pabbly Connect.
  • Open Google Sheets, go to Extensions, then Add-ons, and select Get Add-ons.

Search for “Pabbly Connect Webhooks” and install it. After installation, refresh your Google Sheets to see the Pabbly Connect Webhooks option. Click on it, go to Initial Setup, paste the copied webhook URL, and specify the activation column where data will be entered.

3. Configuring Pabbly Chatflow for WhatsApp Messages

Next, you will set up Pabbly Chatflow to send automated WhatsApp messages. In Pabbly Connect, add a new action step and select Pabbly Chatflow as the application. Choose the event as “Send Text Message” and click on “Connect”.

To connect Pabbly Chatflow with Pabbly Connect, you will need the token from your Pabbly Chatflow account. Access your Pabbly Chatflow account, navigate to API and Webhooks settings, and copy the token. Paste this token back in Pabbly Connect to establish the connection.

4. Mapping Data for WhatsApp Messages

Once you have connected Pabbly Chatflow, it’s time to map the data for sending WhatsApp messages. You will need to input the WhatsApp number of the recipient dynamically. Instead of entering it manually, use the mapping feature provided by Pabbly Connect.

  • Insert a slash and search for the WhatsApp number field from the previous step.
  • You can also customize your message by including the lead’s name dynamically.
  • Ensure your message format is correct and test it using the “Save and Send Test Request” option.

After mapping all necessary fields, save your workflow. This setup will allow you to send personalized WhatsApp messages to each lead listed in your Google Sheets.

5. Sending Bulk WhatsApp Messages to Leads

Finally, to send bulk WhatsApp messages, go back to your Google Sheets and click on the Pabbly Connect Webhooks option. Choose “Send All Data” to trigger the automation you have just set up in Pabbly Connect. This will send messages to all leads in your sheet.

If you want to ensure that every new lead added to the sheet receives a WhatsApp message automatically, activate the “Send on Event” option in Pabbly Connect Webhooks. This will keep your workflow running seamlessly.

Each time you update or add new leads, the messages will be sent automatically, making your communication process efficient and effective.

Conclusion

In this tutorial, you learned how to send bulk WhatsApp messages directly from Google Sheets using Pabbly Connect and Pabbly Chatflow. This integration not only streamlines your messaging process but also enhances communication with your leads efficiently.