Cast by dare1.eth
Show the cast this replies to━━━━━━━━━━━ 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
→ self-terminating auto-fetch for lists over 500 wallets, one menu click installs a ScriptApp time trigger that batches every minute and deletes itself when all wallets are done. zero babysitting. → MD5 key suffix on RPC URLs PropertiesService keys are strings. two different Alchemy URLs for the same chain would collide on a naive key. MD5 hash suffix prevents that. → balance delta notes every fetch writes a cell note with the change since last run: ↑ +1.234500 (prev: 0.000000). hover any cell to see movement at a glance. → portfolio sheet auto-built SUMIF totals across all chain sheets and token columns. rebuilds in one click after you add or remove a chain.
━━━━━━━━━━━ how distribution works ━━━━━━━━━━━ shipped as an Apps Script library with a fixed Script ID. users either: A) copy a pre-wired Google Sheet (one click, everything already set up) B) add the library manually to their own sheet + paste 16 thin wrapper functions into Code.gs versioning is handled through Apps Script's deployment system. users can pin a version for stability or track HEAD for automatic updates. no npm, no installs, no CLI. ━━━━━━━━━━━ tech stack ━━━━━━━━━━━ Google Apps Script — all the tracking logic Vanilla HTML + CSS + Vite — docs site Vercel — hosting + analytics
━━━━━━━━━━━ get it ━━━━━━━━━━━ 🌐 docs + one-click Sheet copy: wallet-tracker-docs.vercel.app 🐙 source: github.com/buildbyravi/wallet-tracker-docs ━━━━━━━━━━━ if you're building something on Apps Script or have ideas for what to track next (NFT counts? gas spent? staking rewards?) — reply, i'm all ears. and if you've solved the Apps Script execution limit problem a smarter way, genuinely want to know.