Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To integrate WooCommerce with Google Sheets, first access Pabbly Connect. You can do this by visiting pabbly.com and navigating to the connect page by adding “/connect” to the URL.

Once there, sign in to your Pabbly account. If you’re a new user, click on “Sign up for free” to receive 100 free tasks monthly. Existing users should click “Sign in”. After logging in, select the Pabbly Connect application to proceed with the integration.

2. Creating a New Workflow in Pabbly Connect

Next, you need to create a new workflow in Pabbly Connect. Click on the “Create Workflow” button and name it “Automatically Add WooCommerce Orders to Google Sheets”. Select the appropriate folder for your workflow.

  • Click the “Create” button to finalize your workflow.
  • This sets up the initial trigger for your automation process.

Your workflow is now created, and you will see a prompt to select your trigger application. For this integration, choose WooCommerce as your trigger application.

3. Setting Up the Trigger in Pabbly Connect

In this step, you will set up the trigger event in Pabbly Connect. Select “New Order Created” as the trigger event. Click on “Connect” to establish a connection between Pabbly Connect and WooCommerce.

You will be provided with a webhook URL, which acts as a bridge to connect your WooCommerce store with Pabbly Connect. Copy this URL and head to your WordPress dashboard.

  • Navigate to WooCommerce settings and select the “Advanced” tab.
  • Add the copied webhook URL under the “Webhooks” section.
  • Name the webhook and set its status to active.

After saving the webhook, return to your Pabbly Connect workflow to check for a response. You should see a confirmation that the webhook has been successfully added.

4. Testing the Integration with a Sample Order

To ensure everything is set up correctly, you need to test the integration by placing a sample order in your WooCommerce store. Go to your store and select a product to purchase.

After adding the product to your cart, proceed to checkout. Fill in the required details such as name, email, and address. Select a payment method and place the order. Once the order is placed, return to your Pabbly Connect workflow to check if the order details have been captured.

  • You should see all the order details populated in the webhook response.
  • This confirms that the trigger is functioning properly.

With the successful capture of order details, you are ready to move on to the next step of adding these details to Google Sheets.

5. Adding Order Details to Google Sheets

In this final step, configure the action application to be Google Sheets in Pabbly Connect. Select “Add New Row” as the action event and click “Connect” to link your Google Sheets account.

Choose the spreadsheet you created for WooCommerce orders. Map the order details from WooCommerce to the respective fields in Google Sheets. Mapping ensures that every new order is accurately recorded in your spreadsheet.

  • Map fields such as name, email, product, and payment method.
  • After mapping, click “Save and Send Test Request” to confirm the integration.

Once you receive a positive response, check your Google Sheets to ensure the order details have been added successfully. This completes the integration process, allowing you to automate your WooCommerce order management using Pabbly Connect.

Conclusion

In this tutorial, you learned how to integrate WooCommerce with Google Sheets using Pabbly Connect. This automation allows you to manage your orders efficiently, ensuring all order details are captured seamlessly in your spreadsheet.