Woo Commerce to Google Sheet Integration

[Nalin]

I am trying to create a Woocommerce to Google sheet integration. I have followed the instruction provided by Pabbly but when I try to get the Webhook response the screen shows me that it is spinning but it never completes. It has just got hung on spinning.

What is going on? Pls advise

 

[Pabbly13]

You can check the first part of the below video tutorial to know how to get the webhook response for WooCommerce when a new order is created.

 

[joseant]

Hi! Thanks for your response. Im trying to follow the video steps.

I created the webhook and tried to get response from webhook, but i can't find any label called line_items.

I tried to use iterator on next step, but when I choose array are showing empty.

Any help would be appreciated.

 

[Fagun Shah]

You need to turn off the Simple Response toggle and Re-Capture the Webhook Response, that will capture the line_items array nad that you can use in the iterator.

 

[joseant]

Hi Fagun, thank you so much for your help.

I followed your advice and managed to access to Line Items.

Now, in line items I can see some important data for me. But I still haven't got all the important data.

Seems there are another array inside line items with the additional data that I need called Meta Data.

Do you know how I can extract that?

 

[Fagun Shah]

Meta Data is also Array format, so you can pass that into Array into Iterator as well.

 

[joseant]

Hi Fagun, thanks for your help.

I can see 2 different metadata array.

1. Meta Data are showing the variation order data. I need that, but iterator only display the variation "tejido", and there are other variations called "aroma" and "tamaño". I need get the data for the 3 variations for every line item.

Any help would be appreciated. Thanks.

 

[Fagun Shah]

When you're setting up the workflow it will only show 1st item of array in iterator response, but when actual execution of the workflow happens it will go through each item of the array one by one.