Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start automating personalized WhatsApp messages, first access Pabbly Connect by visiting pabby.com/connect. This platform allows seamless integration between various applications without coding.

After reaching the landing page, you’ll see options to either sign in or sign up for free. New users can create an account in just a couple of minutes, gaining access to 100 free tasks monthly to explore the platform’s capabilities.

2. Creating a New Workflow in Pabbly Connect

Once signed in, navigate to the dashboard of Pabbly Connect. Click on the big blue button labeled “Create Workflow” to start building your automation. You can either create a workflow from scratch or use AI for a simpler setup.

For this tutorial, select the option to create using AI. Enter a prompt such as “Connect Google Sheets with Pabbly Chatflow”. This prompt helps Pabbly Connect understand your requirements and set up the integration effectively.

  • Select Google Sheets as the trigger app.
  • Choose the event “New or Updated Spreadsheet Row” to start the workflow.
  • Set Pabbly Chatflow as the action app to send WhatsApp messages.

Upon confirming your selections, the workflow is created, linking Google Sheets and Pabbly Chatflow for effective WhatsApp message automation.

3. Setting Up Google Sheets Integration with Pabbly Connect

Next, you need to build a connection between your Google Sheets and Pabbly Connect. Copy the webhook URL generated in Pabbly Connect and paste it into the Google Sheets add-on for Pabbly Connect Webhooks.

In your Google Sheets, go to Extensions > Add-ons > Get Add-ons and install the Pabbly Connect Webhooks add-on. After installing, refresh your spreadsheet to see the add-on option. Navigate to Initial Setup within the add-on, paste the webhook URL, and specify the trigger column.

  • Choose your trigger column, which will send data to Pabbly Connect.
  • Click on the “Send Test” button to verify the connection.
  • Submit the setup after successful testing.

Once the setup is complete, you can return to Pabbly Connect to see the test response containing the customer details from your Google Sheets.

4. Sending Personalized WhatsApp Messages Using Pabbly Chatflow

With the connection established, you can now set up Pabbly Chatflow to send personalized WhatsApp messages. In Pabbly Connect, select the action to send a template message through Pabbly Chatflow.

To do this, you need to connect your Pabbly Chatflow account by providing the API token found in your Pabbly Chatflow settings. This token allows Pabbly Connect to send messages on your behalf.

  • Map the recipient’s mobile number from the Google Sheets data.
  • Select the WhatsApp template you want to use for messaging.
  • Ensure the template includes variables for personalization.

After mapping all necessary fields, click on “Save and Send Test Request” to verify that the message is sent correctly to the specified WhatsApp number.

5. Automating Message Delivery to All Customers

To send messages to all customers at once, go back to your Google Sheets and use the Pabbly Connect Webhooks add-on. Click on the option to “Send All Data” to trigger the automation for every entry in your spreadsheet.

By doing this, all customers will receive their personalized WhatsApp messages simultaneously. This approach enhances customer engagement and improves sales conversion rates.

Remember, using Pabbly Connect not only automates your messaging process but also ensures that messages are tailored to each customer’s preferences, making them more effective.

Conclusion

This tutorial demonstrates how to automate personalized WhatsApp messages using Pabbly Connect and Pabbly Chatflow, leveraging Google Sheets for seamless integration. By following these steps, you can enhance customer engagement and drive sales effectively.