How to Send WhatsApp Notifications for WooCommerce Orders & Add to Google Sheets Using Pabbly Connect

Learn how to integrate WooCommerce with WhatsApp and Google Sheets using Pabbly Connect for automatic notifications and order tracking. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for WooCommerce Integration

To start sending WhatsApp notifications for new WooCommerce orders, you first need to access Pabbly Connect. This platform allows you to create automated workflows that connect WooCommerce with WhatsApp and Google Sheets.

Begin by visiting the Pabbly website and signing up for a free account. After creating your account, log in and navigate to the ‘Connect’ section. Here, you can create a new workflow to manage the integration. Follow these steps:

• Access Pabbly Connect and click on ‘Create Workflow’.
• Name your workflow, for example, ‘WooCommerce to WhatsApp’.
• Click on ‘Create’ to start building your automation.

Once you have created your workflow, you will see two main sections: the trigger and action windows. The trigger will be set to WooCommerce to capture new order data, while the action will be configured to send a WhatsApp message and log the order details to Google Sheets.

2. Configuring WooCommerce as the Trigger in Pabbly Connect

The next step involves setting up the WooCommerce trigger in Pabbly Connect. This step is crucial as it determines when the automation will be activated. For this integration, select ‘WooCommerce’ as your trigger app.

In the trigger event, choose ‘Order Updated’ instead of ‘New Order Created’. The reason for this choice is to ensure that you only receive notifications for orders that have been successfully processed. Here are the steps to configure it:

• Select ‘WooCommerce’ in the trigger section.
• Choose ‘Order Updated’ as the trigger event.
• Click ‘Save’ to finalize the trigger setup.

After saving, you will need to connect your WooCommerce account to Pabbly Connect. This involves creating a webhook in your WooCommerce settings that points to the URL provided by Pabbly Connect. This ensures that every time an order is updated, the data will be sent to Pabbly Connect for processing.

3. Creating a Webhook in WooCommerce

To enable Pabbly Connect to receive order updates, you must create a webhook in your WooCommerce settings. This step is essential for establishing a connection between WooCommerce and Pabbly Connect.

Access your WooCommerce dashboard and navigate to the settings. Under the ‘Advanced’ tab, find the ‘Webhooks’ section. Create a new webhook by following these steps:

Click on ‘Add Webhook’. Name your webhook (e.g., ‘Pabbly Connect Webhook’). Set the status to ‘Active’ and choose ‘Order Updated’ as the topic. Paste the delivery URL provided by Pabbly Connect.

After saving the webhook, you will confirm that it is active. This integration allows Pabbly Connect to receive real-time updates from WooCommerce every time an order is placed or updated.

4. Sending WhatsApp Notifications Using Pabbly Connect

With the WooCommerce trigger set up and the webhook created, the next step is to configure the action to send WhatsApp notifications through Pabbly Connect. For this, you will use a service like WATI to send the WhatsApp messages.

In the action section of Pabbly Connect, select WATI as the app and choose ‘Send Template Message’ as the action event. You will need to connect your WATI account by providing the API endpoint and access token. Here’s how to do it:

Select WATI as the action app. Choose ‘Send Template Message’ as the action event. Enter your API endpoint and access token from your WATI account.

After configuring the WATI action, you will need to map the customer’s WhatsApp number and customize the message template. The message will include the customer’s name, the shop name, and order details, ensuring that the customer receives a personalized notification every time they place an order.

5. Adding Order Details to Google Sheets

Finally, to keep track of all orders, you can use Pabbly Connect to add order details to Google Sheets automatically. This ensures that you have a backup of all order information for easy access and management.

In the action section, select Google Sheets and choose ‘Add New Row’ as the action event. Connect your Google Sheets account and map the necessary fields, such as order ID, product name, customer details, and contact information. Follow these steps:

Select Google Sheets as the action app. Choose ‘Add New Row’ as the action event. Connect your Google Sheets account and select the appropriate spreadsheet.

Once you have mapped all the fields correctly, every time a new order is placed, the details will be automatically added to your Google Sheets. This integration not only saves time but also helps in maintaining accurate records of all transactions.

Conclusion

Using Pabbly Connect, you can seamlessly integrate WooCommerce with WhatsApp and Google Sheets to automate notifications and order tracking. This setup ensures that every new order is communicated effectively and logged for future reference.