Integrate WooCommerce Orders with Google Sheets Using Pabbly Connect

Learn how to automate the process of adding WooCommerce orders to Google Sheets using Pabbly Connect. Step-by-step tutorial with detailed instructions. 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 Automation

To begin the integration process, first access Pabbly Connect. This powerful tool allows you to automate workflows between different applications seamlessly. Start by signing up for a free account, which provides you with free automation tasks each month.

After signing up, log in to your Pabbly Connect account and navigate to the dashboard. Click on the ‘Create Workflow’ button. Here, you can name your workflow, such as ‘WooCommerce to Google Sheets Automation,’ and click on the create button to proceed.

2. Setting Up Trigger for New Orders in WooCommerce

In this step, you will set up the trigger in Pabbly Connect to detect new orders in WooCommerce. Search for the WooCommerce application and select the trigger event as ‘New Order Created.’ This event will initiate the workflow whenever a new order is placed.

• Open your WordPress dashboard.
• Navigate to WooCommerce settings.
• Click on the Advanced tab and select Webhooks.

Click on the ‘Add Webhook’ button to create a new webhook connection. Name your webhook, set its status to active, and select the topic as ‘Order Created.’ Paste the webhook URL from Pabbly Connect into the delivery URL field and save the webhook. This setup allows Pabbly Connect to receive order details automatically.

3. Capturing Order Details from WooCommerce

Once the webhook is set up, the next step is to capture the order details. Click on the ‘Recapture Webhook Response’ button in Pabbly Connect. This will allow you to test the connection by placing a new order in your WooCommerce store.

After placing a test order, ensure the response captures all necessary details. Remember to toggle the simple response button off before placing the order to receive the data in an array format. This format provides structured data, including product names, quantities, and total amounts.

• Place a test order with multiple products.
• Verify that the order details appear correctly in Pabbly Connect.

Once the order details are captured, you can see the product information and customer details displayed in Pabbly Connect. This step is crucial for ensuring that the integration works correctly before proceeding.

4. Calculating Product Numbers Using Code by Pabbly

In this section, you will calculate the number of products in the order using the ‘Code by Pabbly’ feature. Select the action event as ‘Run JavaScript’. This allows you to write a JavaScript code snippet that processes the order data received from WooCommerce. using Pabbly Connect

Map the line items label from the previous step into the JavaScript code. After entering the code, click on ‘Save and Send Test Request’. This action will execute the code and return the number of products in the order.

The output will confirm the exact number of products ordered, which should match the items in your WooCommerce order. This verification ensures that the data is accurately processed before it is sent to Google Sheets.

5. Sending Data to Google Sheets

Finally, you will send the captured data to Google Sheets. In Pabbly Connect, add another action step and select Google Sheets as the application. Choose the action event as ‘Add New Row’ to input the order details into your specified spreadsheet.

Map the necessary fields, such as the date of the order and the number of products ordered, to the corresponding columns in your Google Sheets. Click on ‘Save and Send Test Request’ to send the data and confirm that it appears correctly in your spreadsheet.

Ensure your Google Sheets file is prepared with the correct headers. Verify that the data appears in the correct format in your Google Sheets.

This integration will now automatically log new WooCommerce orders into Google Sheets, streamlining your order management process. Once set up, this workflow will run in the background, saving you time and effort in managing your eCommerce data.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of adding WooCommerce orders to Google Sheets. This integration saves time and enhances efficiency by automatically logging order details. With Pabbly Connect, you can easily manage your eCommerce data without manual intervention.