Use Pabbly to send Woocommerce order to Google Sheets with VARIABLE product

[robi93]

Hi I am trying to send woocommerce order data to Google Sheets. This works easily with simple products as shown in your tutorial here:

BUT I need to map the data in a variable product under "Line Items" to a Google Sheet column. This data is presented in key/value pairs with extra formatting.

Can I grab the line items of a variable product and send that to Sheets? How?

Here is a screencapture of how the variable product data looks in the webhook:

Screenshot

Captured with Lightshot

prnt.sc

 

[Supreme]

Can I grab the line items of a variable product and send that to Sheets?

You can simply use the "Line Itemizer" action step after the trigger event and can pass its comma-separated values in the "Google Sheets: Add Multiple Rows".

 

[robi93]

Thanks! I was able to do it easily with the JSON Extractor: