Use Pabbly to send Woocommerce order to Google Sheets with VARIABLE product
Status: Closed · Asked by robi93 on · 0 views
Hi I am trying to send woocommerce order data to Google Sheets. This works easily with simple products as shown in your tutorial here:
youtube.com/watch?v=7ZkjOvByiyM
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:
https://prnt.sc/QjsUgcGY7obz
Attachments
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".
youtube.com/watch?v=GqaiQO_ekUQ
Thanks! I was able to do it easily with the JSON Extractor:
