DON! OPS Wiring
OPS memakai pola private Google Drive/Sheets sebagai source of truth, n8n sebagai adapter automation, dan Next.js sebagai dashboard serta endpoint command.
Source Order
Read: n8n normalized JSON jika env webhook aktif, lalu local snapshot di data/database/tables. Google Sheet private tidak dibuka langsung dari browser.
Write: semua command dari OPS dikirim ke API Next.js, lalu diteruskan ke n8n webhook jika env tersedia. n8n menulis balik ke Google Sheet/Drive.
Required Google Sheet Tabs
| Area | Tabs |
|---|---|
| Overview | orders, payments, expenses, automation_runs, ops_health |
| Orders | orders, order_items, payments, payment_reconciliations, fulfillment_kanban, shipments, customer_messages |
| Products | products, variants, inventory, subcontractors, marketplace_listings, artist_series, series_products |
| Expenses | expenses |
| Automation | agent_tasks, automation_runs, ops_health, drive_folders |
Next.js OPS APIs
| Endpoint | Purpose | n8n env |
|---|---|---|
/api/ops/summary | Dashboard summary and health read | Read-only |
/api/ops/orders | Order kanban read/write command | N8N_OPS_ORDER_WEBHOOK_URL |
/api/ops/products | Product, stock, preorder, subkon command | N8N_OPS_PRODUCT_WEBHOOK_URL |
/api/ops/expenses | Expense ledger command | N8N_OPS_EXPENSE_WEBHOOK_URL |
/api/ops/autopilot | Agent/API automation command | N8N_OPS_AUTOMATION_WEBHOOK_URL |