How can I set up a daily auto email for unfulfilled orders excluding refunds?

Shopify Plus
1

I am trying to set up a daily auto email that will send me order numbers of unfulfilled Orders.

I also want to filter out Refunded Orders. I’d like to do this in the visual editor as I have no coding experience

Any Idea what to put in the query in GetOrderData to enable this?

This is my attempt:

created_at:<=‘{{ scheduledAt | date_minus: “6 days” }}’ AND fulfillment_status:unfulfilled AND NOT status:cancelled AND NOT paymentStatus:Refunded

This works, bar filtering out Refunded Orders. Could anyone help me out?