How to Add WooCommerce Orders to Google Sheets Using Pabbly Connect

Learn how to automatically add WooCommerce orders to Google Sheets using Pabbly Connect. This step-by-step guide covers the entire integration process for multiple products. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for WooCommerce Orders

To start integrating WooCommerce orders into Google Sheets, you need to access Pabbly Connect. First, create a free account on Pabbly Connect by signing up. Once logged in, you will reach the dashboard where you can create your automation workflow.

Click on the blue ‘Create Workflow’ button. Name your workflow something like ‘Add WooCommerce Orders in Google Sheets for Multiple Products’. Select the main workflow folder and click on ‘Create’. This initiates the process of setting up your integration.

2. Connecting WooCommerce to Pabbly Connect

In this step, you will connect WooCommerce to Pabbly Connect. To do this, you need to set the trigger event. Select WooCommerce as your first application and choose ‘New Order’ as the trigger event. This action means that whenever a new order is created in WooCommerce, it will automatically trigger the workflow.

• Select the trigger event as ‘New Order Created’.
• Copy the Webhook URL provided by Pabbly Connect.
• Disable the simple response option to enable advanced response.

Once you have copied the Webhook URL, navigate to your WooCommerce settings. Go to the ‘Advanced’ section and select ‘Webhooks’. Here, click on ‘Add New Webhook’, provide a name, set the status to active, and paste the Webhook URL. Finally, save the webhook to establish the connection.

3. Placing an Order to Test the Connection

Now that you have set up the connection between WooCommerce and Pabbly Connect, it’s time to place a test order. Go to your WooCommerce store and add multiple products to your cart. For example, select a t-shirt, a mobile phone, and a microphone. Adjust the quantities accordingly and proceed to checkout.

During checkout, fill in the customer details using dummy information for testing. Once the order is successfully placed, return to Pabbly Connect and click on ‘Recapture Webhook Response’. This will allow you to see if the order details are captured correctly.

4. Transforming Order Data for Google Sheets

With the order details captured, you now need to transform this data into a format suitable for Google Sheets using Pabbly Connect. Add a new step in your workflow and select ‘Data Transformer’. This feature helps convert the captured JSON data into a simpler format.

• Map the line items array to transform it into comma-separated values.
• Replace commas with new lines for better readability in Google Sheets.

After transforming the data, you can prepare it for sending to Google Sheets. Ensure that each piece of information, such as product name, quantity, and price, is mapped correctly so that the data flows seamlessly into your spreadsheet.

5. Adding Data to Google Sheets via Pabbly Connect

The final step is to connect Google Sheets to Pabbly Connect. Select Google Sheets as your action application and choose ‘Add a New Row’ as the action event. You will need to authorize your Google Sheets account if you haven’t done so already.

Once connected, select the appropriate spreadsheet and sheet where you want the order details to be added. Map the fields from your transformed data to the columns in your Google Sheet. For instance, map the customer’s first name, last name, email, product name, quantity, and price.

After mapping all necessary fields, test the workflow by deleting any previous entries and placing another order. You should see the new order details automatically populate in your Google Sheet, confirming that the integration works smoothly.

Conclusion

In this tutorial, we covered how to use Pabbly Connect to automatically add WooCommerce orders to Google Sheets for multiple products. By following these steps, you can streamline your order management process and save time on manual data entry.