Ravi pfp
Ravi

@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.
1 reply
0 recast
0 reaction