How to Automatically Add Deleted WooCommerce Orders to Google Sheets Using Pabbly Connect

Learn how to use Pabbly Connect to automate the process of adding deleted WooCommerce orders to Google Sheets. Follow this detailed tutorial for step-by-step guidance.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for WooCommerce and Google Sheets

To begin, we will set up Pabbly Connect as our integration platform. This tool enables us to automate the process of adding deleted WooCommerce orders to Google Sheets. Start by visiting the Pabbly Connect homepage and signing in or creating a new account. Once logged in, navigate to the dashboard to create a new workflow.

Click on the ‘Create Workflow’ option. A dialog will prompt you to name your workflow. Enter a name like ‘Add Deleted WooCommerce Order Details in Google Sheets’ and select a folder for organization. After creating the workflow, you will see two sections: Trigger and Action. The trigger will be WooCommerce, and the action will be Google Sheets.

2. Configuring WooCommerce Trigger in Pabbly Connect

In this step, we will set up WooCommerce as the trigger application in Pabbly Connect. Select WooCommerce and then choose the trigger event as ‘Order Deleted’. This event will initiate the workflow whenever an order is deleted from your WooCommerce store.

• Select WooCommerce from the trigger application.
• Choose ‘Order Deleted’ as the trigger event.
• Copy the generated webhook URL for later use.

After selecting the trigger event, Pabbly Connect will provide a webhook URL. This URL needs to be integrated into your WooCommerce settings. Next, go to your WordPress dashboard, navigate to WooCommerce settings, and find the Webhooks section under the Advanced tab. Add a new webhook using the copied URL.

3. Adding the Webhook in WooCommerce Settings

To connect WooCommerce with Pabbly Connect, we need to add the webhook created in the previous step. In the WooCommerce settings, click on the ‘Webhooks’ option and then click on ‘Add Webhook’. Enter a name like ‘Pabbly Connect Webhook’ and set the status to Active.

• Name the webhook appropriately.
• Set the status of the webhook to Active.
• Paste the webhook URL from Pabbly Connect.

For the topic, select ‘Order Deleted’ to ensure that the webhook triggers correctly. Once you save the webhook, return to Pabbly Connect to test the connection. Click on ‘Recapture Webhook’ to ensure that the setup is working properly.

4. Retrieving Deleted Order Details from WooCommerce

Now that we have set up the trigger, we can retrieve the deleted order details. In Pabbly Connect, add another action step and select WooCommerce again. This time, choose the action event ‘Retrieve Order by ID’. This action will help us get all necessary details of the deleted order using the order ID provided in the trigger.

To connect, you will need to enter your WooCommerce store URL and the API keys (consumer key and secret). After entering these details, map the order ID from the previous step to retrieve specific order details. Click on ‘Save and Send Test Request’ to fetch the order details.

5. Adding Order Details to Google Sheets

With the order details retrieved successfully, we can now add this data to Google Sheets using Pabbly Connect. Select Google Sheets as the action application and choose ‘Add New Row’ as the action event. Connect your Google Sheets account if you haven’t done so already.

In the configuration settings, select the spreadsheet where you want to add the order details. You will need to map the customer name, email, order ID, product name, quantity, and total amount to the corresponding columns in your Google Sheet. After mapping all the necessary fields, click on ‘Save and Send Test Request’ to add the data to your Google Sheets.

Conclusion

In this tutorial, we learned how to use Pabbly Connect to automatically add deleted WooCommerce order details to Google Sheets. By setting up triggers and actions, we can efficiently manage our order data without manual input. This automation streamlines the process, ensuring that you always have accurate records of deleted orders.