Woocommerce to Google Sheet

[Eugen]

Hello

Three questions here:

I have watched and applied the steps from this video

The Questions​

This is the most important one​

1) Its all working great except the fact that, sometimes we get failed orders or canceled orders and they mess up my sheet.
Can you please make it so that, instead of Order Created, we can have Finalised orders?
That way, we have clear numbers.

2) Is there a way to REMOVE a raw from the google sheet if someone cancels or is refunded? Even better, if I can put those orders on a second file/sheet of the same google sheet document?

3) Can we have different orders being registered to a "general finalised orders" sheet as well as segment them by the type of product / membership?
See the image attached

 

[ash]

i think you need trigger module order updated and to split it up the membership1, 2, etc, you need routers that filter the membership status.
And yes 1 trigger can all in one sheet..