{"author":{"username":"ai-art","displayName":"Ravi","fid":612066},"timestamp":"2026-06-13T20:06:43.000Z","text":"━━━━━━━━━━━\nwhat's actually under the hood (v8)\n━━━━━━━━━━━\n\nthe 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:\n\n→ batch JSON-RPC\nnative 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.\n\n→ ERC-20 via eth_call\ntoken balances use sequential balanceOf() calls with auto-fetched decimals cached in PropertiesService. wrong decimals? one menu click clears the cache.\n\n→ fallback RPC\nset 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.\n\n→ LockService\ntime-based triggers can fire concurrently. LockService makes later instances skip rather than write the same column twice and corrupt data.","farcaster":"https://farcaster.xyz/ai-art/0xce69915bc736a650bb8d80bec80e5d23ee4f70fc","firefly":"https://firefly.social/post/farcaster/0xce69915bc736a650bb8d80bec80e5d23ee4f70fc"}