how to get all woocommerce order details in google sheets

[event]

I want to collect all order data from woocommerce to google sheet

 

[manthan]

Hey @event

To collect all Order Data from Woocommerce to Google Sheets you can check the following steps.

1) Add Schedule in Trigger and Trigger event as once.
2) Then in the action step select Woocommerce and in the Action event list all order.
3) Add Iterator and the Woocommerce response should be in array format in the final step, select Woocommerce.
4) Then add Google Sheets and action step as add a new row.

Below are a few attachments for reference.