Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for WhatsApp Integration

To begin sending bulk WhatsApp messages using Pabbly Connect, first, you need to access the platform. If you are a new user, open your browser and visit pabby.com/connect. This will take you to the Pabbly Connect landing page.

Once on the site, click on the ‘Sign Up for Free’ button in the top right corner. This will allow you to create an account and start a free trial of Pabbly Connect. After signing up, you can send up to 100 WhatsApp messages for free, which is a great way to test the service.

2. Setting Up Your Workflow in Pabbly Connect

After logging into Pabbly Connect, you will need to create a new workflow. Click on the ‘Create Workflow’ button to start. This workflow will be responsible for connecting Google Sheets to WhatsApp.

  • Select Google Sheets as the trigger application.
  • Choose the event as ‘New or Updated Spreadsheet Row’.
  • Click on ‘Connect’ to establish a connection.

Once connected, you will receive a webhook URL. Copy this URL, as it is essential for the integration. You will need to paste this URL in your Google Sheets add-ons to complete the setup.

3. Configuring Google Sheets with Pabbly Connect

To link Google Sheets with Pabbly Connect, open your Google Sheets document containing customer details. Navigate to the Extensions menu, then click on Add-ons, and select ‘Get Add-ons’. Search for “Pabbly Connect Webhooks” and install it.

After installation, refresh your Google Sheets. You should now see the “Pabbly Connect Webhooks” option in the Extensions menu. Click on it, and select “Initial Setup”. Paste the webhook URL you copied earlier and specify the trigger column where your data resides.

  • Enter the webhook URL in the setup.
  • Specify the trigger column (e.g., column D).

Click on the ‘Submit’ button to complete the configuration. This establishes a successful connection between Google Sheets and Pabbly Connect.

4. Sending WhatsApp Messages via Pabbly Connect

With your Google Sheets set up, it’s time to send WhatsApp messages through Pabbly Connect. Add a new action step in your workflow and select “Pabbly Chatflow” as the action application. Choose the event as “Send Message” and connect your account.

If you haven’t created a connection yet, click on “Add a New Connection”. You will need to provide your API token from your Pabbly Chatflow account. Once connected, you can specify the recipient’s WhatsApp number and the message content. Use mapping to ensure dynamic content is pulled from your Google Sheets.

  • Map the WhatsApp number from your spreadsheet.
  • Compose your message, personalizing it with customer names.

Click on “Save and Send Test Request” to verify that the message is sent successfully. You will see the message appear in your WhatsApp, confirming that the integration works correctly.

5. Sending Bulk WhatsApp Messages from Google Sheets

To send bulk WhatsApp messages, return to your Google Sheets and navigate to the “Pabbly Connect Webhooks” under Extensions. Click on “Send All Data” to trigger the automation. This action will send personalized WhatsApp messages to all contacts listed in your spreadsheet.

If you want to automate this process further, enable the “Send on Event” option in the Pabbly Connect Webhooks menu. This ensures that every time a new entry is added to your spreadsheet, a WhatsApp message is sent automatically.

Utilizing Pabbly Connect in this manner not only saves time but also enhances customer engagement through personalized communication. Go ahead and try it out today!

Conclusion

In this tutorial, we explored how to use Pabbly Connect to send bulk WhatsApp messages from Google Sheets. This automation streamlines communication and ensures personalized messages reach your customers efficiently.