How to Add Deleted WooCommerce Order Details in Google Sheets Using Pabbly Connect

Learn how to automatically add deleted WooCommerce order details to Google Sheets using Pabbly Connect. Step-by-step tutorial with clear instructions. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for WooCommerce and Google Sheets Integration

To start adding deleted WooCommerce order details into Google Sheets, you need to access Pabbly Connect. First, visit the Pabbly Connect homepage by typing the URL Pabbly.com/connect. This platform allows you to automate tasks between different applications without any coding skills.

Once on the homepage, you will see options to sign in or sign up for free. If you are a new user, click on the ‘Sign Up for Free’ button. After creating your account, you will receive 100 free tasks every month to explore the capabilities of Pabbly Connect.

Creating the Workflow in Pabbly Connect

After logging into Pabbly Connect, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ option. A dialog box will appear asking for a name for your workflow; enter ‘Add Deleted WooCommerce Order Details in Google Sheets’ and select a folder for organization.

Next, you will see two windows: one for the trigger and one for the action. Select WooCommerce as the trigger application and choose the trigger event as ‘Order Deleted’. This sets up the workflow to react whenever an order is deleted in your WooCommerce store.

Setting Up Webhook in WooCommerce with Pabbly Connect

To connect WooCommerce to Pabbly Connect, you need to configure a webhook. Copy the webhook URL provided by Pabbly Connect and go to your WordPress site’s WooCommerce settings. Under the Advanced tab, click on Webhooks, and then click on ‘Add Webhook’.

• Enter a name for the webhook, such as ‘Test Webhook’.
• Set the status to Active.
• Select the topic as ‘Order Deleted’.
• Paste the webhook URL into the Delivery URL field.

After saving the webhook, return to Pabbly Connect to check if you have received a test response. This indicates that your WooCommerce store is successfully connected to Pabbly Connect.

Retrieving Deleted Order Details from WooCommerce

Once the webhook is set up, you need to retrieve the order details. In Pabbly Connect, add another action step and select WooCommerce again, this time choosing ‘Retrieve Order by ID’ as the action event. This action will allow you to get the details of the deleted order using its order ID.

You will need to connect to your WooCommerce account by entering your consumer key, consumer secret, and website URL. These details can be generated from the WooCommerce settings under the REST API section. Once connected, map the order ID received from the previous step to retrieve the necessary order details.

Adding Deleted Order Details to Google Sheets

Now that you have the order details, the next step is to add them to Google Sheets using Pabbly Connect. Add another action step and select Google Sheets as the application, then choose ‘Add New Row’ as the action event. This will ensure that every time an order is deleted, its details are automatically added to your Google Sheets.

• Select the spreadsheet and sheet name where you want the data to be added.
• Map the customer name, email, order ID, product names, quantities, and total amount from the previous steps.

After mapping all the necessary fields, click on ‘Save and Send Test Request’. Check your Google Sheets to confirm that a new row has been added with all the relevant information. This completes the integration process using Pabbly Connect.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automatically add deleted WooCommerce order details into Google Sheets. By following the steps outlined, you can efficiently manage deleted order records without manual input. This integration streamlines your workflow and enhances your data management capabilities.