Sync WooCommerce Orders to Google Sheets Using Pabbly Connect

Learn how to sync new customer orders from WooCommerce to Google Sheets using Pabbly Connect in this detailed tutorial. 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. Accessing Pabbly Connect for Integration

To sync new customer orders from WooCommerce to Google Sheets, we will utilize Pabbly Connect. First, open your web browser and go to the Pabbly Connect landing page by searching for Pabbly.com/connect. Once on the site, you can either sign in or sign up for free if you are a new user.

After signing in, you will be directed to the Pabbly Connect dashboard. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. This is the starting point for setting up your integration between WooCommerce and Google Sheets.

2. Creating the Workflow in Pabbly Connect

Once you click on ‘Create Workflow,’ you will be prompted to choose between the new workflow builder and the classic one. For this integration, select the new workflow builder for a modern interface. Name your workflow appropriately, such as ‘Sync WooCommerce Orders to Google Sheets.’ Then click on ‘Create’ to proceed. using Pabbly Connect

• Select the trigger application as WooCommerce.
• Choose the trigger event as ‘New Order Created.’
• Click on ‘Connect’ to set up the connection.

After selecting the trigger, Pabbly Connect will provide a webhook URL. Copy this URL, as it will be used to connect your WooCommerce account with Pabbly Connect.

3. Setting Up WooCommerce for Integration

Now, navigate to your WooCommerce account. Go to the settings section and find the ‘Advanced’ tab. Under this tab, you will see an option for ‘Webhooks.’ Click on it and then select ‘Add Webhook’ to create a new webhook for the integration.

• Name the webhook as ‘New Order’.
• Set the status to ‘Active’.
• For the topic, select ‘Order Created’.
• Paste the webhook URL copied from Pabbly Connect into the Delivery URL field.

After filling out these details, save the webhook. This action establishes a connection between WooCommerce and Pabbly Connect, allowing order data to be sent to your workflow.

4. Capturing Order Details in Pabbly Connect

With the webhook set up, it’s time to capture the order details. Go back to your Pabbly Connect workflow and click on ‘Recapture Web Response.’ This action will allow Pabbly Connect to receive the data from WooCommerce when a new order is created. using Pabbly Connect

To test this, place a new order in your WooCommerce store. After completing the order, return to Pabbly Connect. You should see the details of the order captured successfully, including customer information and product details. This confirms that the integration is working correctly.

5. Adding Order Data to Google Sheets

Next, we will set up the action to add the captured order details to Google Sheets. In your Pabbly Connect workflow, click on ‘Add Action Step’ and select Google Sheets as the action application. Choose the action event as ‘Add New Row’ and click on ‘Connect’ to link your Google Sheets account. using Pabbly Connect

Sign in to your Google account and grant the necessary permissions. Once connected, select the spreadsheet you want to use for storing order details. Map the fields from the WooCommerce order response to the respective columns in your Google Sheets. This includes mapping the order ID, customer name, email, product details, and total amount.

After mapping the fields, click on ‘Save and Send Test Request’ to ensure the data is correctly added to Google Sheets. You should see the new order details reflected in your selected spreadsheet, confirming that the integration is successful.

Conclusion

In this tutorial, we demonstrated how to sync new customer orders from WooCommerce to Google Sheets using Pabbly Connect. This integration streamlines your order management process, allowing you to track sales and maintain records effortlessly. By following the steps outlined, you can automate this workflow and enhance your e-commerce operations.