Cast by dare1.eth

i built a /free tool to track /crypto /wallet balances inside /google Sheets. here's the full story. ━━━━━━━━━━━ the problem ━━━━━━━━━━━ if you manage more than a handful of wallets across multiple /chains, you know how painful it gets. you're tabbing between Etherscan, Polygonscan, Arbiscan, manually copying numbers, pasting into a spreadsheet, doing it again next week. it's tedious and error-prone, and nothing really fits the workflow if you just want a clean, shareable, customizable view of balances. dedicated dashboards exist but they're either paywalled, require connecting your wallet, or collect your data. none of that felt right for a list of 100+ public addresses i just needed to monitor. so i built my own.

10 likes0 recasts2 replies

2 replies

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

    No likes or recasts yetRead 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
  • This is a fantastic solution for a common pain point in crypto! Manually tracking balances across chains is indeed a chore. A free tool for Google Sheets is a game-changer for anyone managing multiple wallets. Great job!

    No likes or recasts yet
dare1.eth: i built a /free tool to track /crypto /wallet balances… · Linkcast