{"ok":true,"checkedAt":"2026-08-08T17:16:28.175Z","sourceStatus":"local_snapshot_fallback_n8n_read_not_configured","singleSourceOfTruth":"google_drive_google_sheets","syncRule":"OPS -> n8n -> Google Sheets -> n8n response -> OPS refresh","liveSource":false,"n8nRead":{"target":null,"error":"No n8n read webhook env is configured, so OPS cannot read live Google Sheets yet."},"source":{"connected":true,"public_csv_status":"unauthorized","spreadsheet_id":"1iX6ehpZ4wqpUNnOcW5P8cyU9Wk7AZR4RGiBRqXb2D7M","spreadsheet_url":"https://docs.google.com/spreadsheets/d/1iX6ehpZ4wqpUNnOcW5P8cyU9Wk7AZR4RGiBRqXb2D7M/edit","spreadsheet_title":"DON_Master_Database","last_connector_read_at":"2026-06-21T12:21:44+07:00","production_read_pattern":"private_sheet_to_n8n_to_website_or_local_snapshot","ops_menu_sheet_status":"split_workbooks_import_ready_pending_native_google_sheet_ids","ops_menu_registry_env":"GOOGLE_SHEETS_OPS_REGISTRY_ID","ops_menu_package_path":"C:/Users/Asus/Documents/Don!/don-pixelpotion-queen-tee-2026-06-21/DON_PPQ_OPS_MENU_CDE_2026-06-22/00_OPS_INDEX/don-ops-menu-cde-index.html","ops_menu_sync_contract":"OPS reads through n8n from Google Sheets and writes through n8n back to Google Sheets; local JSON is fallback only."},"orders":[{"id":"DON-1001","created_at":"2026-06-14T17:54:58+07:00","source":"website","customer_ref":"CUSTOMER-REF-001","product_id":"DON-PROD-0001","size":"XL","color":"White","quantity":1,"payment_status":"unpaid","production_status":"new_order","shipping_status":"not_started","assigned_agent":"Hermes","next_action":"Validate customer and payment status"},{"id":"DON-1002","created_at":"2026-06-14T17:54:58+07:00","source":"custom_studio","customer_ref":"CUSTOMER-REF-002","product_id":"CUSTOM","size":"M","color":"White","quantity":1,"payment_status":"brief_needed","production_status":"design_brief","shipping_status":"not_started","assigned_agent":"Design Agent","next_action":"Validate customer and payment status"},{"id":"DON-1003","created_at":"2026-06-14T17:51:45+07:00","source":"website","customer_ref":"CUSTOMER-REF-003","product_id":"DON-PROD-0001","size":"XL","color":"White","quantity":1,"payment_status":"unpaid","production_status":"new_order","shipping_status":"not_started","assigned_agent":"Hermes","next_action":"Hermes validate customer, address, and payment status"},{"id":"N8N-LOCAL-DEMO-ROSA-001","created_at":"2026-06-15T02:33:05.723Z","source":"website","customer_ref":"local_ref:demo-customer","product_id":"DON-PROD-0001","size":"XL","color":"White","quantity":1,"payment_status":"unpaid","production_status":"new_order","shipping_status":"not_started","assigned_agent":"Hermes","next_action":"Hermes validate customer, address, and payment status; OpenClaw waits for paid production status."},{"id":"N8N-LOCAL-DEMO-ROSA-003","created_at":"2026-06-15T02:37:59.458Z","source":"website","customer_ref":"local_ref:demo-customer-3","product_id":"DON-PROD-0001","size":"XL","color":"White","quantity":1,"payment_status":"unpaid","production_status":"new_order","shipping_status":"not_started","assigned_agent":"Hermes","next_action":"Hermes validate customer, address, and payment status; OpenClaw waits for paid production status."},{"id":"N8N-LOCAL-DEMO-ROSA-004","created_at":"2026-06-15T03:47:29.856Z","source":"website","customer_ref":"local_ref:demo-customer-4","product_id":"DON-PROD-0001","size":"XL","color":"White","quantity":1,"payment_status":"unpaid","production_status":"new_order","shipping_status":"not_started","assigned_agent":"Hermes","next_action":"Hermes validate customer, address, and payment status; OpenClaw waits for paid production status."},{"id":"N8N-LOCAL-DEMO-ROSA-005","created_at":"2026-06-15T03:48:30.480Z","source":"website","customer_ref":"local_ref:demo-customer-5","product_id":"DON-PROD-0001","size":"XL","color":"White","quantity":1,"payment_status":"unpaid","production_status":"new_order","shipping_status":"not_started","assigned_agent":"Hermes","next_action":"Hermes validate customer, address, and payment status; OpenClaw waits for paid production status."},{"id":"DON-CODEX-PUBLISH-TEST-001","created_at":"2026-06-16T13:03:21.227Z","source":"website","customer_ref":"test-ref-codex","product_id":"DON-AS-001-ROSA-WHITE","size":"M","color":"White","quantity":1,"payment_status":"unpaid","production_status":"new_order","shipping_status":"not_started","assigned_agent":"Hermes","next_action":"Hermes validate customer, address, and payment status; OpenClaw waits for paid production status."},{"id":"DON-MQGNXILL-01","created_at":"2026-06-16T13:13:25.407Z","source":"website","customer_ref":"test-ref-vercel","product_id":"DON-AS-001-ROSA-WHITE","size":"M","color":"White","quantity":1,"payment_status":"unpaid","production_status":"new_order","shipping_status":"not_started","assigned_agent":"Hermes","next_action":"Hermes validate customer, address, and payment status; OpenClaw waits for paid production status."}],"payments":[{"payment_id":"PAY-DON-1001","order_id":"DON-1001","method":"manual_follow_up","amount":199000,"status":"unpaid","source":"google_sheet_orders","notes":"Payment status imported from orders tab."},{"payment_id":"PAY-DON-1002","order_id":"DON-1002","method":"brief_required","amount":0,"status":"brief_needed","source":"google_sheet_orders","notes":"Custom studio order requires brief before invoice."},{"payment_id":"PAY-DON-1003","order_id":"DON-1003","method":"manual_follow_up","amount":199000,"status":"unpaid","source":"google_sheet_orders","notes":"Payment status imported from orders tab."},{"payment_id":"PAY-N8N-LOCAL-DEMO-ROSA-001","order_id":"N8N-LOCAL-DEMO-ROSA-001","method":"manual_follow_up","amount":199000,"status":"unpaid","source":"google_sheet_orders","notes":"Payment status imported from n8n demo order."},{"payment_id":"PAY-N8N-LOCAL-DEMO-ROSA-003","order_id":"N8N-LOCAL-DEMO-ROSA-003","method":"manual_follow_up","amount":199000,"status":"unpaid","source":"google_sheet_orders","notes":"Payment status imported from n8n demo order."},{"payment_id":"PAY-N8N-LOCAL-DEMO-ROSA-004","order_id":"N8N-LOCAL-DEMO-ROSA-004","method":"manual_follow_up","amount":199000,"status":"unpaid","source":"google_sheet_orders","notes":"Payment status imported from n8n demo order."},{"payment_id":"PAY-N8N-LOCAL-DEMO-ROSA-005","order_id":"N8N-LOCAL-DEMO-ROSA-005","method":"manual_follow_up","amount":199000,"status":"unpaid","source":"google_sheet_orders","notes":"Payment status imported from n8n demo order."},{"payment_id":"PAY-DON-CODEX-PUBLISH-TEST-001","order_id":"DON-CODEX-PUBLISH-TEST-001","method":"manual_follow_up","amount":199000,"status":"unpaid","source":"google_sheet_orders","notes":"Payment status imported from website checkout test."},{"payment_id":"PAY-DON-MQGNXILL-01","order_id":"DON-MQGNXILL-01","method":"manual_follow_up","amount":199000,"status":"unpaid","source":"google_sheet_orders","notes":"Payment status imported from website checkout test."}],"paymentEvents":[],"paymentReconciliations":[],"fulfillmentKanban":[],"customerOrderTimeline":[],"customerMessages":[],"shipments":[],"tasks":[{"task_id":"TASK-DON-1001-HERMES","agent_name":"Hermes","trigger":"new_order","priority":"high","status":"open","input_ref":"orders:DON-1001","output_ref":"","due_at":"2026-06-14T17:54:58+07:00","next_action":"Validate customer, address, and payment"},{"task_id":"TASK-DON-1002-DESIGN","agent_name":"Design Agent","trigger":"custom_studio_brief","priority":"medium","status":"open","input_ref":"orders:DON-1002","output_ref":"","due_at":"2026-06-14T17:54:58+07:00","next_action":"Prepare first mockup request checklist"},{"task_id":"TASK-DON-OPS-LOG","agent_name":"Codex","trigger":"phase_1_local_only","priority":"medium","status":"done","input_ref":"logs:agent-activity.jsonl","output_ref":"database:DON_Master_Database.xlsx","due_at":"2026-06-14T17:54:58+07:00","next_action":"Keep local source-of-truth current"},{"task_id":"TASK-DON-1003-HERMES","agent_name":"Hermes","trigger":"local_order_webhook","priority":"high","status":"open","input_ref":"orders:DON-1003","output_ref":"","due_at":"2026-06-14T17:51:45+07:00","next_action":"Validate customer contact reference, size, address, and payment."},{"task_id":"TASK-DON-1003-OPENCLAW","agent_name":"OpenClaw","trigger":"order_created","priority":"medium","status":"waiting_payment","input_ref":"orders:DON-1003","output_ref":"production:WO-DON-1003","due_at":"2026-06-14T17:51:45+07:00","next_action":"Prepare work order after payment is confirmed."},{"task_id":"TASK-N8N-LOCAL-DEMO-ROSA-005-PAYMENT","agent_name":"n8n","trigger":"payment_status_unpaid","priority":"high","status":"open","input_ref":"orders:N8N-LOCAL-DEMO-ROSA-005","output_ref":"","due_at":"2026-06-16T03:48:30.480Z","next_action":"Prepare payment follow-up draft; do not send customer message without owner approval."},{"task_id":"TASK-DON-CODEX-PUBLISH-TEST-001-PAYMENT","agent_name":"n8n","trigger":"payment_status_unpaid","priority":"high","status":"open","input_ref":"orders:DON-CODEX-PUBLISH-TEST-001","output_ref":"","due_at":"2026-06-17T13:03:21.227Z","next_action":"Prepare payment follow-up draft; do not send customer message without owner approval."},{"task_id":"TASK-DON-MQGNXILL-01-PAYMENT","agent_name":"n8n","trigger":"payment_status_unpaid","priority":"high","status":"open","input_ref":"orders:DON-MQGNXILL-01","output_ref":"","due_at":"2026-06-17T13:13:25.407Z","next_action":"Prepare payment follow-up draft; do not send customer message without owner approval."}]}