Skip to content

Google Sheets and Apps Script

Current role

Google Sheets + bound Apps Script are the current practical source of truth for inventory, allocation, landed cost, finance, and consolidated orders.

Primary workbook: Exzen Pte. Ltd.

Operational tabs:

  • Imports
  • Inventory
  • Shopee
  • Lazada
  • Orders
  • ALL
  • ProductName
  • Variation
  • Transactions
  • PnL
  • Finance
  • Snkrdunk

Bound Apps Script state

After deletion of legacy spx.gs and SNEAKYDUNK_.gs, the project had 11 files and 39 functions at the audit snapshot.

Observed execution types:

  • onChange installed event trigger
  • onEdit simple trigger
  • onOpen simple trigger
  • refreshToken_ time-driven trigger
  • Shopee balance custom functions recalculated from Sheet formulas

Known stale UI

onOpen.gs still creates SPX and SNKRDUNK menu entries whose handlers no longer exist. Those menu items will fail until someone cleans the menu code.

Current limitation

This host did not verify the full installed-trigger inventory because ScriptApp.getProjectTriggers() requires user authorization inside Apps Script runtime.