Cast by dare1.eth

Show the cast this replies to

━━━━━━━━━━━ what i shipped ━━━━━━━━━━━ Wallet Balance Tracker — a Google Sheets Apps Script library that fetches live on-chain balances directly into your spreadsheet. you get a ⚡ Balances menu inside Sheets. you configure your RPC URL, paste wallet addresses in column B, and hit fetch. balances fill in within seconds. that's it. native coins $ETH, $BNB, $POL, $AVAX…) and ERC-20 tokens ($USDC, $USDT, $WETH, $ARB, anything with a contract address). any EVM chain. any public RPC. free. no API key. no subscription. no backend. your wallet addresses never leave your own Google account.

0 likes0 recasts1 replies

1 reply

  • ━━━━━━━━━━━ 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.

    No likes or recasts yetRead 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.

    No likes or recasts yetRead 1 reply

    ━━━━━━━━━━━ 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

    No likes or recasts yetRead 1 reply