[ { "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" } } } }, "shared_workflow_id": 33846 }, "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." } ]