━━━━━━━━━━━
what's actually under the hood (v8)
━━━━━━━━━━━
the interesting engineering constraints came from Google Apps Script's 6-minute execution limit and the Sheets API quota. here's how i worked around them:
→ batch JSON-RPC
native coin fetches are bundled into batch eth_getBalance calls — 500 wallets go out in a handful of HTTP requests instead of 500 individual ones. this alone cut runtime by 2–3 minutes on large lists.
→ ERC-20 via eth_call
token balances use sequential balanceOf() calls with auto-fetched decimals cached in PropertiesService. wrong decimals? one menu click clears the cache.
→ fallback RPC
set a backup RPC URL per sheet. if more than 50% of a batch errors on the primary, failed wallets automatically retry against the fallback. no manual intervention.
→ LockService
time-based triggers can fire concurrently. LockService makes later instances skip rather than write the same column twice and corrupt data.
The post this replies to
Terminus needs JavaScript to show replies and pictures.