Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To begin the integration process, access Pabbly Connect by visiting pabby.com/connect in your browser. This platform is essential for creating automated workflows that connect your applications seamlessly.

If you are a new user, click on the ‘Sign up for free’ button to create an account. Existing users can directly log in. Upon signing up, you will receive 100 free tasks each month to explore the features of Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

Once logged in, navigate to the dashboard of Pabbly Connect and click on the ‘Create Workflow’ option. This is where you will set up the integration between Google Sheets and Pabbly Chatflow.

  • Select ‘Quick Workflow Builder’ for an easy setup.
  • Enter your requirement, such as connecting Google Sheets with Pabbly Chatflow.
  • Choose the trigger as ‘New or Updated Spreadsheet Row.’

After setting up the trigger, approve the workflow. This allows Pabbly Connect to automatically send WhatsApp messages based on new data entries in Google Sheets.

3. Setting Up Google Sheets with Pabbly Connect

Next, you need to establish a connection between Google Sheets and Pabbly Connect. To do this, copy the webhook URL provided by Pabbly Connect and paste it into your Google Sheets add-on.

  • Go to ‘Extensions’ and select ‘Add-ons’ to install the Pabbly Connect Webhooks add-on.
  • In the initial setup, paste the webhook URL and define the trigger column.
  • Send a test response to confirm the connection.

Once the connection is confirmed, every new row added to Google Sheets will trigger a WhatsApp message via Pabbly Connect.

4. Sending WhatsApp Messages Using Pabbly Chatflow

Now that the connection is established, you can set up the WhatsApp messaging feature using Pabbly Chatflow. This application allows you to send personalized messages efficiently.

To connect Pabbly Chatflow with Pabbly Connect, provide your API token from the Chatflow account settings. This integration ensures that messages are sent without the risk of getting banned.

  • Map the customer’s mobile number from the previous response.
  • Select the WhatsApp template you want to use for messaging.
  • Customize header types and parameters as needed.

After setting up the message details, click ‘Save and Send Test Request’ to verify that the message is delivered correctly to the customer’s WhatsApp.

5. Finalizing the Integration for Bulk Messaging

With everything set up, you can now finalize your integration. Use Pabbly Connect to send messages to all customers listed in your Google Sheets.

To send messages to all customers at once, simply click on ‘Send All Data’ in the Pabbly Connect Webhooks add-on. This action ensures that each customer receives their personalized message without any manual effort.

  • Ensure that the ‘Send on Event’ option is enabled for ongoing automation.
  • Monitor the responses to confirm successful message delivery.
  • Adjust templates as needed for future campaigns.

This setup allows you to efficiently manage customer outreach via WhatsApp, leveraging the power of Pabbly Connect and Pabbly Chatflow.

Conclusion

In this tutorial, we explored how to integrate WhatsApp with Google Sheets using Pabbly Connect and Pabbly Chatflow. This method allows you to automate messaging to inactive customers effectively, ensuring better engagement and retention.