Learn how to set up a WhatsApp chatbot using Pabbly Connect and WhatsApp Cloud API. Step-by-step guide for integrating Google Sheets and WhatsApp. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for WhatsApp Chatbot Setup

To set up a WhatsApp chatbot, you first need to access Pabbly Connect. Simply type the URL Pabbly.com/connect into your browser. Once there, you will see options to sign in or sign up for free. If you are a new user, click on the ‘Sign Up for Free’ button to create an account, which comes with 100 free tasks each month.

After signing in, you will be directed to the dashboard of Pabbly Connect. Here, you can create new workflows or manage existing ones. To start your automation, click on the ‘Create Workflow’ button. You will then be prompted to name your workflow, such as ‘Send WhatsApp Message from Google Sheets,’ and select a folder for organization.

2. Integrating Google Sheets with Pabbly Connect

The next step involves integrating Google Sheets with Pabbly Connect. For this, select Google Sheets as your trigger application. Choose the trigger event as ‘New or Updated Spreadsheet Row.’ This means whenever a new row is added or updated, the automation will be triggered.

  • Select Google Sheets as the trigger application.
  • Choose the trigger event: New or Updated Spreadsheet Row.
  • Copy the provided webhook URL from Pabbly Connect.
  • In Google Sheets, install the Pabbly Connect Webhook add-on.

Once the add-on is installed, refresh your spreadsheet, and navigate to Extensions > Pabbly Connect Webhooks. Here, paste the copied webhook URL and specify the trigger column, which is the last column of your data (e.g., column B for WhatsApp numbers). After setting this up, test the configuration to ensure it works correctly.

3. Sending WhatsApp Messages Using Pabbly Connect

With the Google Sheets integration complete, the next step is to set up the action to send WhatsApp messages via the WhatsApp Cloud API using Pabbly Connect. For this, select WhatsApp Cloud API as your action application and choose the action event ‘Send Template Message.’ This allows you to send pre-defined messages to your customers.

To connect your WhatsApp account, you will need to enter the following details:

  • Temporary Access Token
  • Phone Number ID
  • WhatsApp Business Account ID

After entering these details, select the message template you want to use for your WhatsApp messages. Ensure that your template is approved in the WhatsApp Cloud API. Once everything is set up, map the recipient’s mobile number from the previous response, and send a test message to verify that the integration works correctly.

4. Creating Automated Replies for the WhatsApp Chatbot

After successfully sending WhatsApp messages, the next step is to set up automated replies when customers respond. This is done by creating a new workflow in Pabbly Connect for handling incoming messages. Select WhatsApp Cloud API as the trigger application and choose ‘Message Notification’ as the trigger event.

Once you have set up the trigger, you will need to configure the webhook URL again in the WhatsApp Cloud API settings. This time, ensure that you subscribe to message notifications to capture incoming messages. After verifying the webhook, test it by sending a message to your WhatsApp number and check if Pabbly Connect captures the response correctly.

Set up the trigger for incoming messages. Verify the webhook URL in WhatsApp Cloud API settings. Test the workflow by sending a message to your WhatsApp number.

After testing, proceed to set up conditions for sending different replies based on the message received. You can use a lookup table feature in Pabbly Connect to map specific responses to corresponding messages.

5. Conclusion: Setting Up Your WhatsApp Chatbot with Pabbly Connect

In this tutorial, we explored how to set up a WhatsApp chatbot using Pabbly Connect and the WhatsApp Cloud API. We began by integrating Google Sheets to send automated messages to customers. Then, we configured the system to handle incoming messages and send personalized replies based on customer responses.

Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.

By using Pabbly Connect, you can automate your messaging processes without any coding skills, making it easier to manage customer interactions. This setup not only enhances your marketing efforts but also improves customer engagement and satisfaction.

Setting up a WhatsApp chatbot using Pabbly Connect can significantly streamline your communication with customers, allowing for efficient and effective marketing campaigns.