[
    {
        "version": 1,
        "label": "Export order to google sheet if fulfilled but not marked as delivered in 29 days",
        "trigger_type": [
            "order_fulfilled"
        ],
        "object_type": "order",
        "app_id": "triggers",
        "settings": {
            "priority": 0,
            "condition_groups": {
                "1": {
                    "conditions": {
                        "1": {
                            "field": "order.delay",
                            "settings": {
                                "wait": "custom",
                                "custom_wait": "29 days",
                                "check_date": {
                                    "submit": "Check Date"
                                },
                                "token_browser": "{{ Browse Tokens }}",
                                "token_object_type": "order",
                                "condition_type": "AND"
                            },
                            "weight": 999
                        },
                        "2": {
                            "field": "order.fulfillments.shipment_status",
                            "settings": {
                                "multiple": "all",
                                "operator": "none",
                                "value": {
                                    "delivered": "delivered",
                                    "failure": "failure",
                                    "confirmed": 0,
                                    "in_transit": 0,
                                    "out_for_delivery": 0
                                },
                                "condition_type": "AND"
                            },
                            "weight": 999
                        }
                    },
                    "actions": {
                        "1": {
                            "type": "google_sheets",
                            "settings": {
                                "wait": "0",
                                "custom_wait": "",
                                "url": "[CLICK TO EDIT]",
                                "title": null,
                                "tab": "",
                                "rows": "{{ order.order_number }}\r\n{{ order.email }}\r\n{{ order.number }}\r\n{{ order.customer.display_name }}\r\n{{ format_address(order.shipping_address, {format: 'sheets', country: true, company: false, phone: false}) }}\r\n{{ order.fulfillment_status }}",
                                "token_object_type": "order"
                            },
                            "weight": 999,
                            "target_key": "order"
                        }
                    }
                }
            }
        },
        "description": "This workflow will automatically monitor any orders fulfilled but not delivered within 29 days. If the order is not delivered within this period, add it to google sheet."
    }
]