Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for WhatsApp Integration
To automate sending product catalogs to customers on WhatsApp, begin by accessing Pabbly Connect. Open a new tab and navigate to pabbly.com/connect to reach the Pabbly Connect landing page.
If you are a new user, sign up for free to receive 100 free tasks every month. This allows you to explore the features of Pabbly Connect and test the workflow described in this tutorial.
2. Setting Up Google Sheets as a Trigger in Pabbly Connect
In Pabbly Connect, you will set up a trigger to capture new customer data from Google Sheets. Select Google Sheets as the trigger application and choose the event as “New or Updated Spreadsheet Row”. This ensures that every time new data is added, it will trigger the workflow.
- Select Google Sheets as the trigger application.
- Choose “New or Updated Spreadsheet Row” as the event.
- Click the connect button to generate a webhook URL.
Copy this URL and head over to your Google Sheets. This connection will allow Pabbly Connect to receive data from your spreadsheet automatically.
3. Installing Pabbly Webhooks Add-on in Google Sheets
To finalize the connection between Google Sheets and Pabbly Connect, install the Pabbly Webhooks add-on. Go to the Extensions menu, select Add-ons, and then Get Add-ons. Search for “Pabbly Connect Webhooks” and install it.
After installation, refresh your spreadsheet and select the Pabbly Connect Webhooks option. In the initial setup dialog, paste the webhook URL you copied earlier and specify the trigger column, which should be the column containing customer phone numbers.
4. Sending WhatsApp Messages using Pabbly Chatflow
Now that the connection is established, the next step is to send WhatsApp messages using Pabbly Chatflow. Add an action step in Pabbly Connect and select Pabbly Chatflow as the action application. Choose the event as “Send Template Message”.
- Select Pabbly Chatflow as the action application.
- Choose “Send Template Message” as the event.
- Connect your Pabbly Chatflow account to Pabbly Connect.
Map the recipient phone number from the previous step and select the template you created in Pabbly Chatflow. This allows you to personalize messages sent to each customer.
5. Automating WhatsApp Messages for All Customers
Once the setup is complete, you can automate sending WhatsApp messages to all customers in your Google Sheets. To do this, click on the “Send All Data” option from the Pabbly Webhooks menu in Google Sheets. This action will trigger the workflow and send messages to all listed customers.
As new customer data is added to your spreadsheet, Pabbly Connect will automatically send WhatsApp messages to those customers as well. This makes sharing your product catalog efficient and hassle-free.
Conclusion
In this tutorial, we demonstrated how to use Pabbly Connect to automate sending product catalogs via WhatsApp. By integrating Google Sheets and Pabbly Chatflow, you can efficiently manage customer communication without manual effort.



