Send WhatsApp Messages from Google Sheets Using Pabbly Connect and Pabbly Chatflow

Learn how to send WhatsApp messages automatically from Google Sheets using Pabbly Connect and Pabbly Connect with this step-by-step tutorial. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To send WhatsApp messages from Google Sheets, you first need to access Pabbly Connect. Start by typing the URL Pabbly.com/connect in your browser. This will take you to the Pabbly Connect homepage, where you can either sign in or sign up for a free account.

If you are a new user, click on the Sign Up for Free button to create your account. You will receive 100 free tasks every month to explore the features of Pabbly Connect and test multiple automations. Existing users can simply click Sign In to access their accounts.

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, navigate to the dashboard and click on the Create Workflow option. You will be prompted to name your workflow. For this tutorial, name it Send WhatsApp Message from Google Sheets Using Pabbly Chatflow Automatically.

• Select a folder to save your workflow.
• Click on Create to proceed.

Your workflow will consist of a trigger and an action. The trigger will be Google Sheets, and the action will be Pabbly Chatflow. This setup ensures that whenever a new row is added to your Google Sheets, a WhatsApp message will be sent automatically through Pabbly Chatflow.

3. Setting Up Google Sheets as the Trigger

In this step, you will configure Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets and choose the event that starts the workflow, which is when a new row is added or updated.

• Copy the webhook URL provided by Pabbly Connect.
• Open Google Sheets, navigate to Extensions, and select Add-ons.
• Search for Pabbly Connect Webhooks and install it.

After installation, go back to Pabbly Connect to paste the copied webhook URL into the Google Sheets add-on. Specify the trigger column, which is the last column containing customer details, typically the phone number column.

4. Configuring Pabbly Chatflow for WhatsApp Messaging

After setting up Google Sheets, the next step is to configure Pabbly Chatflow to send WhatsApp messages. In your Pabbly Connect workflow, select Pabbly Chatflow as the action application and choose the action event as Send Request.

To connect Pabbly Chatflow, you will need to enter your WhatsApp Business Account details. This includes your access token, WhatsApp Business Account ID, and phone number ID, which you can obtain from your WhatsApp Cloud API account. After entering these details, click on Add to establish the connection.

5. Sending WhatsApp Messages Automatically

Now that you have configured both Google Sheets and Pabbly Chatflow, it’s time to set up the message template. Create a new template in Pabbly Chatflow, specifying the category and message body. Use variables to personalize the messages for each customer. using Pabbly Connect

After your template is set up, link it with a broadcast campaign in Pabbly Chatflow. This will allow you to send messages directly from the data received from Google Sheets. Ensure that you map the customer’s phone number and name dynamically to personalize each message.

Once everything is configured, test the workflow by adding a new row in your Google Sheets. The system should automatically send a WhatsApp message to the new customer using the details provided. This integration not only saves time but also enhances customer interaction through personalized messaging.

Conclusion

In this tutorial, we explored how to send WhatsApp messages from Google Sheets using Pabbly Connect and Pabbly Chatflow. This automation streamlines communication with customers, ensuring that each message is personalized and timely. By following the steps outlined, you can enhance your business’s customer engagement effortlessly.