Watch Step By Step Video Tutorial Below





1. Setting Up Pabbly Connect for Integration

To start using Pabbly Connect for integrating WooCommerce with Google Sheets, first access the platform by visiting the Pabbly Connect website. If you are a new user, click on “Sign Up Free” to create an account. This will allow you to explore the features of Pabbly Connect, including 100 free tasks every month.

Once you have signed up or logged in, navigate to the dashboard. Here, you can create a new workflow by clicking the “Create Workflow” button. This will initiate the process of setting up the automation that connects your WooCommerce orders directly to Google Sheets.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow that uses Pabbly Connect to automate the transfer of order details from WooCommerce to Google Sheets. Start by selecting the “Quick Builder” option, which simplifies the setup process. Enter the prompt: “Want to add my WooCommerce order details to the Google sheet.” This will guide the automation setup.

  • Select WooCommerce as the trigger application.
  • Choose the trigger event as “New Order Created.”
  • Set Google Sheets as the action application.
  • Choose “Add New Row” as the action event.

After setting up the trigger and action, click on “Approve” to finalize your workflow. This will connect your WooCommerce store to Pabbly Connect, enabling the automation of data transfer to Google Sheets.

3. Adding the Webhook URL in WooCommerce

Next, you need to add the webhook URL generated by Pabbly Connect into your WooCommerce settings. Copy the webhook URL provided in the workflow setup. Then, log in to your WordPress account where WooCommerce is installed.

Navigate to WooCommerce settings by selecting “WooCommerce” from the sidebar and then clicking on “Settings.” From the settings page, go to the “Advanced” tab and select “Webhooks.” Here, you can add a new webhook by clicking on the “Add Webhook” button.

  • Provide a name for the webhook, like “Orders Received.”
  • Set the status to “Active.”
  • Select the topic as “Order Created.”
  • Paste the copied webhook URL into the designated field.

After filling out these details, click on “Save Webhook” to establish the connection. This step is crucial as it allows Pabbly Connect to receive order data from WooCommerce whenever a new order is placed.

4. Testing the Integration with Pabbly Connect

To ensure that the integration between WooCommerce and Google Sheets via Pabbly Connect is working correctly, you need to test the setup. Start by placing a test order on your WooCommerce store. Fill in the checkout details and select your payment method.

Once the order is successfully placed, return to Pabbly Connect and check for the new response. You should see the order details captured in the response section. This verifies that the webhook is functioning and the data is being transmitted correctly.

  • Check for the response in Pabbly Connect showing the order details.
  • If the data is received, proceed to map the fields to Google Sheets.

This successful response indicates that your WooCommerce store is now effectively integrated with Pabbly Connect, ready to send order data to Google Sheets automatically.

5. Mapping Fields to Google Sheets

In this final step, you will map the order details from WooCommerce to the appropriate fields in Google Sheets using Pabbly Connect. Start by selecting the Google Sheets application in your workflow and connect it by clicking on the “Connect” button.

Choose your Google account and allow access to enable the connection. Then, select the spreadsheet where you want to store the WooCommerce order details. You will see options to map various fields such as customer name, email, phone number, and order amount.

  • Map the customer’s full name by combining first and last name fields.
  • Map the email address, phone number, and shipping address.
  • Map the product name and total amount fields.

After mapping all necessary fields, click on “Save and Send Test Request” to send a test entry to Google Sheets. Check your Google Sheet to confirm that the order details have been added successfully, completing the integration process with Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate WooCommerce orders to Google Sheets using Pabbly Connect. By following these steps, you can streamline your order management process and eliminate manual data entry. Start using Pabbly Connect today to enhance your business automation.