@dare1.eth
━━━━━━━━━━━
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.