How to Add Multiple Rows in Google Sheets for Multiple Items of Single Order Using Pabbly Connect

Learn how to use Pabbly Connect to add multiple rows in Google Sheets for multiple items from a single WooCommerce order. Step-by-step tutorial included. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start adding multiple rows in Google Sheets for multiple items of a single order, you need to access Pabbly Connect. First, visit the Pabbly website and log in to your account. If you are a new user, click on the ‘Sign Up Free’ button to create an account.

Once logged in, navigate to the ‘All Apps’ section and select Pabbly Connect. This will take you to the dashboard where you can create a new workflow for integrating WooCommerce with Google Sheets.

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, click on the plus sign to create a new workflow. Name your workflow something relevant, like ‘WooCommerce to Google Sheets Integration’. This workflow will help you automate the process of adding order details to Google Sheets whenever a new order is placed.

Next, you will see a trigger window and an action window. For this integration, select WooCommerce as the trigger application and choose the ‘New Order’ event. This means that every time a new order is created in WooCommerce, it will trigger the workflow.

• Click on the plus sign to create a new workflow.
• Name your workflow (e.g., WooCommerce to Google Sheets Integration).
• Select WooCommerce as the trigger application.
• Choose ‘New Order’ as the trigger event.

After setting this up, Pabbly Connect will provide a webhook URL. You need to copy this URL to configure the webhook in your WooCommerce account.

3. Setting Up Webhook in WooCommerce

To connect WooCommerce with Pabbly Connect, log in to your WordPress account where WooCommerce is installed. Go to WooCommerce settings, and under the ‘Advanced’ tab, find the ‘Webhooks’ option. Click on ‘Add Webhook’ to create a new webhook.

Name the webhook (e.g., ‘Google Sheets Integration’), set the status to active, and select ‘Order Created’ as the topic. Paste the webhook URL you copied from Pabbly Connect into the delivery URL field. Finally, save the webhook settings.

• Navigate to WooCommerce settings in WordPress.
• Click on the ‘Advanced’ tab and select ‘Webhooks’.
• Add a new webhook with the name and delivery URL.
• Save the webhook settings.

After saving, Pabbly Connect will confirm that the webhook is set up successfully. You can now test this integration by placing a new order in WooCommerce.

4. Capturing Order Details in Pabbly Connect

To capture the order details, place a test order in your WooCommerce store. Once the order is placed, return to Pabbly Connect and click on ‘Recapture Webhook Response’. This will allow you to see the order details captured from WooCommerce.

Make sure to switch the response to ‘Advanced’ to capture all line items in an array format. After clicking ‘Recapture Webhook Response’, you should see all the details of the order, including product names, quantities, and prices.

Place a test order in your WooCommerce store. Return to Pabbly Connect and click on ‘Recapture Webhook Response’. Switch the response to ‘Advanced’ to capture all line items.

Once the response is captured, you will see all order details, and this data will be used to add multiple rows in Google Sheets.

5. Adding Data to Google Sheets Using Pabbly Connect

Now that you have captured the order details, it’s time to add them to Google Sheets. In Pabbly Connect, add a new action step and select Google Sheets as the application. Choose the action event ‘Add Multiple Rows’.

Connect your Google Sheets account by clicking on ‘Connect with Google Sheets’. After authorization, select the spreadsheet where you want to store the order details. Map the order data such as order ID, customer name, product names, and other relevant information from the captured response.

Select Google Sheets as the action application. Choose ‘Add Multiple Rows’ as the action event. Authorize your Google Sheets account. Map the order data to the corresponding fields in the spreadsheet.

After mapping the data, click on ‘Save and Send Test Request’. You should see the order details reflected in your Google Sheets, confirming that the integration is working perfectly.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to add multiple rows in Google Sheets for multiple items from a single WooCommerce order. By following these steps, you can automate your order management process efficiently.

Utilizing Pabbly Connect allows seamless integration between WooCommerce and Google Sheets, ensuring that all order details are captured accurately and promptly. This integration is a powerful way to streamline your business operations.