Track WooCommerce Orders in Google Sheets & Send Email Using Pabbly

Learn how to track WooCommerce orders in Google Sheets and send emails using Pabbly Connect with this detailed step-by-step tutorial. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Order Tracking

To track WooCommerce orders in Google Sheets and send emails using Pabbly Connect, start by visiting the official Pabbly Connect website. Pabbly Connect is an automation tool that allows seamless integration between various applications without coding.

Once on the Pabbly Connect page, you can either sign in if you are an existing user or sign up for a free account. This will give you access to 100 free tasks each month, allowing you to explore the features of Pabbly Connect.

2. Creating Your Workflow in Pabbly Connect

After signing in, navigate to the dashboard of Pabbly Connect. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. You will be prompted to enter a workflow name; for this tutorial, name it ‘Track WooCommerce Orders in Google Sheets and Send Emails Using Pabbly’.

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

This webhook URL will be used to connect WooCommerce to Pabbly Connect, allowing it to receive data whenever a new order is placed.

3. Connecting WooCommerce to Pabbly Connect

To establish a connection between WooCommerce and Pabbly Connect, go to your WordPress dashboard and navigate to the WooCommerce settings. Under the ‘Advanced’ tab, find the ‘Webhooks’ option and click on it.

• Click on ‘Add Webhook’.
• Enter the webhook name and set the status to active.
• Paste the webhook URL from Pabbly Connect in the delivery URL field.

Once the webhook is saved, you will confirm that your WooCommerce account is connected to Pabbly Connect by checking for a response in your workflow.

4. Adding Order Data to Google Sheets

After successfully connecting WooCommerce, the next step is to store order details in Google Sheets. In Pabbly Connect, select Google Sheets as your next application and choose the event ‘Add New Row’.

Connect your Google account by clicking on the connect button. Once connected, select the spreadsheet where you want to store the order data. Use the mapping feature to dynamically insert the order details into the appropriate columns in your Google Sheets.

Map fields like first name, last name, email, and order total. Ensure that all data is captured accurately for each new order.

Once you have set up the mapping, save the configuration and test it by placing a new order in WooCommerce. Check your Google Sheets to confirm that the new order details have been added successfully.

5. Sending Email Confirmations Using Pabbly Connect

The final step in this automation is to send an email confirmation to the user after an order is placed. In Pabbly Connect, add another action step and select Gmail as your application. Choose the event ‘Send Email’.

Connect your Gmail account and set up the email fields. You will map the recipient’s email address using the data received from WooCommerce. Customize the email content to include relevant order details, like the product purchased and the total amount.

Enter a sender name and subject for the email. Map user details such as their first and last names in the email body.

After setting up the email, save the configuration and send a test email. Check your Gmail account to confirm that the email was received successfully, which indicates that the integration is working perfectly with Pabbly Connect.

Conclusion

By following this tutorial, you can effectively track WooCommerce orders in Google Sheets and send email confirmations using Pabbly Connect. This automation saves time and ensures accurate record-keeping and communication with your customers.

Utilizing Pabbly Connect for these integrations allows you to streamline your workflow without any coding, making it accessible for everyone. Start automating your processes today!