Hello Pabbly Support team! My pabbly account is [email protected]
I already have a workflow to capture data from Woocommerce to our Revenue sheet(Google sheets). In this workflow it is set up that Woocommerce brings numerous data from the order but I pick only order date,product name, client name, country, price of the product, tax, total, discount and payment method.
But along with this workflow I would like to build a new workflow connecting Woocommerce order data to Google sheets where all the data from the order is picked up in the Google Sheets.
The challenge is that if a client orders only one product, it is easy to pick up data. In case the client buys more than one product in one single order then how to get all the order data to Google Sheets? Will you please help me with this? If there is a discount or a client comes through affiliate link then the order details from Woocommerce looks different. The headers are not the same in the same order arrangement also.
I already have a workflow to capture data from Woocommerce to our Revenue sheet(Google sheets). In this workflow it is set up that Woocommerce brings numerous data from the order but I pick only order date,product name, client name, country, price of the product, tax, total, discount and payment method.
But along with this workflow I would like to build a new workflow connecting Woocommerce order data to Google sheets where all the data from the order is picked up in the Google Sheets.
The challenge is that if a client orders only one product, it is easy to pick up data. In case the client buys more than one product in one single order then how to get all the order data to Google Sheets? Will you please help me with this? If there is a discount or a client comes through affiliate link then the order details from Woocommerce looks different. The headers are not the same in the same order arrangement also.
