Automatically Update WooCommerce Order Status in Google Sheets Using Pabbly Connect

Learn how to automatically update WooCommerce order status in Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for WooCommerce and Google Sheets Integration

To automatically update WooCommerce order status in Google Sheets, you first need to access Pabbly Connect. Start by visiting the Pabbly Connect website and signing in to your account. If you’re a new user, you can sign up for free and get 100 tasks every month.

Once logged in, you will see a dashboard with various applications. Click on the option to access Pabbly Connect. This platform will enable you to create an automation workflow between WooCommerce and Google Sheets, allowing seamless updates of order statuses.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a workflow. Click on the ‘Create Workflow’ button located in the top right corner of the dashboard. A dialog box will prompt you to name your workflow. Enter a name like ‘Automatically Update WooCommerce Order Status in Google Sheets’.

• Select a folder from the drop-down menu where you want to save this workflow.
• Choose the folder named ‘WooCommerce Automations’.
• Click ‘Create’ to finalize your workflow setup.

Upon creating the workflow, you will see two sections labeled ‘Trigger’ and ‘Action’. This structure is essential for setting up your automation process using Pabbly Connect.

3. Setting Up the Trigger with WooCommerce

The next step in using Pabbly Connect is to set up the trigger. Click on the arrow next to the trigger application and select ‘WooCommerce’ as your trigger app. Choose the trigger event as ‘Order Updated’. This means that whenever an order status is updated in WooCommerce, Pabbly Connect will capture this event.

After selecting the trigger, a unique webhook URL will be generated. You need to copy this URL to connect WooCommerce with Pabbly Connect. Open your WooCommerce account, navigate to the settings, and select ‘Advanced’. From there, go to the ‘Webhooks’ section and click on ‘Add Webhook’.

• Name the webhook, for example, ‘Order Status Update’.
• Set the status to ‘Active’.
• Paste the copied webhook URL into the ‘Delivery URL’ field.

After saving the webhook, your WooCommerce account will be connected to Pabbly Connect, allowing it to capture order updates automatically.

4. Capturing Response from WooCommerce in Pabbly Connect

Now that the webhook is set up, it’s time to capture the response from WooCommerce in Pabbly Connect. Go back to your Pabbly Connect dashboard and click on ‘Recapture Webhook Response’. Ensure that you are ready to test this by updating an order status in your WooCommerce account.

In WooCommerce, navigate to the orders section and select an order to update. Change the order status to ‘Completed’ and save the changes. After updating, return to Pabbly Connect to see if the response has been captured successfully. You should see the updated order details reflected in the captured response.

Check the order ID and status in the captured response. Verify that the order status matches what you updated in WooCommerce.

If everything is set up correctly, you will see the updated order status in Pabbly Connect, confirming that the integration is working as intended.

5. Updating Google Sheets with Pabbly Connect

The final step is to update Google Sheets with the order status captured by Pabbly Connect. For this, you will add an action step. Select ‘Google Sheets’ as the action application and choose the action event as ‘Lookup Spreadsheet Rows V2’. This allows you to find the corresponding order in your Google Sheets using the order ID.

Connect your Google Sheets account to Pabbly Connect by clicking on ‘Sign in with Google’ and allowing access. Once connected, select the spreadsheet where your order details are stored. Map the order ID from the previous step into the lookup value field to find the correct row.

Ensure you select the correct spreadsheet and sheet name. Map the order ID to the lookup value to fetch the correct order. Set the end column to where the status is located.

After setting up the lookup, add another action to update the row in Google Sheets. Select ‘Update Row’ as the action event and map the data accordingly. Once done, click on ‘Save and Send Test Request’. Your Google Sheets should now reflect the updated order status automatically whenever changes are made in WooCommerce.

Conclusion

In this tutorial, we explored how to automatically update WooCommerce order status in Google Sheets using Pabbly Connect. By following the steps outlined, you can ensure your Google Sheets are always in sync with your WooCommerce orders, enhancing your workflow efficiency.