Learn how to automate sending WhatsApp messages with quick reply buttons and call to action using Pabbly Connect and Google Sheets. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for WhatsApp Automation

To start sending WhatsApp messages with quick reply buttons, you first need to access Pabbly Connect. Begin by visiting the Pabbly Connect homepage and either sign in if you are an existing user or click on the ‘Sign up for free’ button to create a new account. Once registered, you can explore the platform with 100 free tasks every month.

After signing in, you will arrive at the dashboard where all your workflows are displayed. To initiate the automation process, click on the ‘Create Workflow’ button. In the dialog box that appears, provide a name for your workflow, such as ‘Send Automated WhatsApp Messages from Google Sheets with Buttons.’ Then select the appropriate folder to save your workflow and click on ‘Create’.

Setting Up Google Sheets as the Trigger

In this step, you will set Google Sheets as the trigger application in Pabbly Connect. Click on the trigger application option and select Google Sheets. Next, choose the trigger event as ‘New or Updated Spreadsheet Row’. This event will activate the workflow whenever new data is added to your Google Sheets.

  • Select Google Sheets as the trigger application.
  • Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
  • Copy the provided webhook URL for integration.

After selecting the trigger event, you will see a webhook URL. Copy this URL as it will be used to connect your Google Sheets with Pabbly Connect. Proceed to your Google Sheets and install the Pabbly Connect Webhook add-on by navigating to Extensions > Add-ons > Get Add-ons and searching for ‘Pabbly Connect Webhook’. Once installed, refresh your spreadsheet to see the new options.

Configuring Google Sheets for Integration

Now that you have installed the Pabbly Connect Webhook add-on, you need to configure it. Go to Extensions > Pabbly Connect Webhook > Initial Setup. Here, paste the copied webhook URL and specify the trigger column, which is the column that will initiate the workflow when data is added.

  • Paste the copied webhook URL in the setup field.
  • Set the trigger column to the relevant column (e.g., Column B for WhatsApp numbers).
  • Click on the ‘Send Test’ button to verify the connection.

After entering the details, click on the ‘Send Test’ button to send a test response to Pabbly Connect. If successful, you will see the test data reflected in your dashboard, confirming that the integration between Google Sheets and Pabbly Connect is established.

Sending WhatsApp Messages via WhatsApp Cloud API

With Google Sheets successfully integrated, the next step is to configure the action to send WhatsApp messages using the WhatsApp Cloud API. In Pabbly Connect, select WhatsApp Cloud API as the action application and choose the action event as ‘Send Template Message’. Click on ‘Connect Now’ and create a new connection to your WhatsApp Cloud API account.

To set up the connection, you will need to provide your WhatsApp Cloud API token, phone number ID, and WhatsApp Business Account ID. You can find these details in your Meta for Developers dashboard under API setup. After entering these credentials, click on ‘Save’ to establish the connection.

Finalizing the WhatsApp Message Template

Once the connection is established, you need to finalize the WhatsApp message template. In the WhatsApp Cloud API setup, enter the template name and message details. You can create a new template by selecting the marketing category and providing a name like ‘Divine Glamour Makeup Studio’. Specify the message body and include variables for personalization.

Additionally, you can add buttons to your message, such as a ‘Visit Website’ button and a ‘Call Us Now’ button. Configure the button actions and URLs as needed. After setting up the template, submit it for approval, which typically takes around five minutes.

Once approved, return to Pabbly Connect and select your template from the dropdown. Map the recipient’s mobile number and any variables from the Google Sheets data to personalize the message. Click on ‘Save and Send Test Request’ to verify the message is sent successfully.

Conclusion

In this tutorial, we learned how to automate sending WhatsApp messages with quick reply buttons using Pabbly Connect. By integrating Google Sheets and WhatsApp Cloud API, you can efficiently reach your customers with personalized messages and call-to-action buttons. This automation saves time and enhances customer engagement.

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