Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To automate WooCommerce orders to Google Sheets, you first need to access Pabbly Connect. Open a new tab and type in the URL pabbly.com/connect. This is the main interface for creating your automation workflows.

Once on the homepage, you’ll see options to either sign in or sign up for free. New users can create an account, which gives them 100 free tasks each month to explore the capabilities of Pabbly Connect. Existing users can simply sign in to get started.

2. Setting Up the Trigger in Pabbly Connect

The next step involves setting up the trigger in Pabbly Connect. A trigger is an event that initiates your automation workflow. In this case, we will select WooCommerce as the trigger application.

To do this, follow these steps:

  • Select WooCommerce as your trigger application.
  • Choose the event as New Order Created.
  • Click on the Connect button to generate a webhook URL.

This webhook URL acts as a bridge between WooCommerce and Pabbly Connect. Copy this URL to use it in your WooCommerce settings.

3. Configuring Webhook in WooCommerce

Now, switch to your WordPress account where WooCommerce is installed. Go to the WooCommerce settings and navigate to the Advanced tab. Here, you will find the option for Webhooks.

To set up the webhook, follow these steps:

  • Select Add Webhook.
  • Name your webhook as “New Order Received”.
  • Set the status to Active and select Order Created as the topic.
  • Paste the copied webhook URL from Pabbly Connect.

After saving, your webhook will be active, and you can return to Pabbly Connect to verify the integration.

4. Capturing Order Data in Pabbly Connect

With the webhook set up, it’s time to test the integration. Go back to Pabbly Connect and click on the “Recapture Webhook Response” button. This will allow you to capture data from a new order placed in WooCommerce.

To test, make a purchase of any product, like the GG Glow Cream. Fill in the required customer details and complete the order. Once the order is placed, you should see the data reflected in Pabbly Connect.

Check the response section in Pabbly Connect to confirm that you have received all necessary order details, including:

  • Customer’s name
  • Email address
  • Product name
  • Order amount

This confirms that your WooCommerce orders are successfully being captured by Pabbly Connect.

5. Adding Order Data to Google Sheets

Now that you have captured the order data, the next step is to add this information to Google Sheets. In Pabbly Connect, click on the “Add New Action Step” button and select Google Sheets as your action application.

Choose the event as “Add New Row” and click Connect. If you already have a connection, select it; otherwise, you will need to sign in to your Google account.

Next, map the fields from WooCommerce to Google Sheets. For example, map the customer’s full name, email, phone number, and order details. This dynamic mapping ensures that each new order automatically populates the Google Sheet without manual entry. Finally, click on “Save and Send Test Request” to send a test entry to your Google Sheet.

Upon successful completion, you will see that the order details are now reflected in your Google Sheet, confirming that the integration works seamlessly through Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate the transfer of WooCommerce order details to Google Sheets using Pabbly Connect. This integration saves time by eliminating manual data entry and ensures accurate record-keeping for your business.