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

Learn how to automate WhatsApp notifications for WooCommerce orders and add details to Google Sheets using Pabbly Connect. Follow this step-by-step guide! Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for WooCommerce Automation

To start sending WhatsApp notifications for WooCommerce orders, you first need to access Pabbly Connect. This platform allows seamless integration between WooCommerce, WhatsApp, and Google Sheets.

Begin by visiting the Pabbly Connect website. If you don’t have an account, sign up for free. Once logged in, you will be directed to the dashboard where you can create a new workflow.

2. Creating a New Workflow in Pabbly Connect

After accessing your Pabbly Connect dashboard, click on ‘Create Workflow’ to initiate the automation process. Name your workflow something descriptive, like ‘WooCommerce to WhatsApp to Google Sheets’. This helps in identifying the workflow later. using Pabbly Connect

Now, you will see a trigger window and an action window. The trigger window is where you specify what event will initiate the workflow. In this case, select WooCommerce as your app and choose ‘New Order Created’ as the trigger event. This means every time a new order is placed, the workflow will be activated.

• Select WooCommerce from the app list.
• Choose ‘New Order Created’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Once you have copied the webhook URL, you will need to set it up in your WooCommerce settings to establish the connection.

3. Setting Up Webhooks in WooCommerce

To connect WooCommerce with Pabbly Connect, navigate to your WordPress dashboard. Hover over the WooCommerce tab and click on ‘Settings’. From there, go to the ‘Advanced’ tab and select ‘Webhooks’. This is where you will add the webhook URL you copied earlier.

Click on ‘Add Webhook’. Here, you will fill in the details: name it ‘Pabbly Connect’, set the status to active, and select ‘Order Created’ as the topic. Paste the webhook URL from Pabbly Connect into the delivery URL field. This allows WooCommerce to send data to Pabbly Connect whenever a new order is created.

• Name your webhook as ‘Pabbly Connect’.
• Set the status to active.
• Select ‘Order Created’ as the topic.
• Paste the webhook URL into the delivery URL field.

After saving the webhook, go back to Pabbly Connect and click ‘Recapture Webhook Response’ to test the connection.

4. Sending WhatsApp Notifications via Pabbly Connect

In the next step, you will send a WhatsApp message to the customer who placed the order. In the action window of your Pabbly Connect workflow, choose ‘WhatsApp Cloud API’ as the app. Select ‘Send Template Message’ as the action event. using Pabbly Connect

Connect your WhatsApp Cloud API account to Pabbly Connect by entering the required details such as token, phone number ID, and WhatsApp Business Account ID. Make sure you have created a message template in your WhatsApp Cloud API account for sending order confirmations.

Select ‘WhatsApp Cloud API’ from the app list. Choose ‘Send Template Message’ as the action event. Map the customer’s phone number and order details into the template message fields.

After mapping the necessary fields, click ‘Save and Send Test Request’ to send a test message to the customer’s WhatsApp number. This confirms that the integration is working as intended.

5. Adding Order Details to Google Sheets via Pabbly Connect

Finally, to maintain a record of the orders, you will add the details to Google Sheets. In the action window, select ‘Google Sheets’ as the app and ‘Add New Row’ as the action event.

Connect your Google Sheets account to Pabbly Connect and select the spreadsheet where you want to store the order details. Map the order ID, customer name, email, phone number, and product name to the corresponding columns in your Google Sheet.

Choose ‘Google Sheets’ as the app. Select ‘Add New Row’ as the action event. Map the order details to the respective columns in the Google Sheet.

Once you have mapped all the necessary details, click ‘Save and Send Test Request’. This will add a new row with the order details to your Google Sheet, completing the automation process.

Conclusion

Using Pabbly Connect, you can effortlessly send WhatsApp notifications for WooCommerce orders and maintain records in Google Sheets. This automation saves time and enhances customer communication, making it a valuable tool for any eCommerce business.