OPERCEL
Tiếng ViệtWorkflow audit

Lark Base / Allocation

Creator asset allocation by store and week

A creator ops team needed creators to claim assets by store and week, constrained by remaining quantities. OPERCEL built an n8n workflow that reads fresh Lark Base data when the form opens, filters creators by authorized store, and shows the weekly plan before submission.

4source tables
6plan days
1claim form

Challenge

Challenge

If creators self-select from spreadsheets, they can exceed remaining quantities, pick the wrong store, or miss what has already been reserved that week.

Approach

Approach

  1. Use real HTTP Request nodes to read Store, Creator, Store Asset, and Allocation data from Lark Base.
  2. Filter creators by Authorized Stores after the store is selected.
  3. Show a Monday-Saturday plan so operators see the week before submitting.

Expected result

Expected result

  • The form reduces over-claiming risk.
  • Users select with context instead of checking several tables manually.
  • The workflow is easier to debug because API calls and HTML generation are separate nodes.

Next case

Accounting and cashflow system for e-commerce operations

The operations team needed clear views of revenue, payment status, refunds, and cashflow from real order data. OPERCEL worked directly on the internal accounting app, checked the data, refined reports, and kept the local environment safe from production queue side effects.

View layout