Ravi

Profile

Open this feed in

Quilcast Terminus Farcaster Quorum Firefly Opencaster Vibeshift

🧱 Built an unofficial self-custody wallet for Thru Alphanet. Features: • 12-word recovery phrase • Import via seed phrase or private key • Multi-account support • Send THRU • Faucet claiming • Transaction history • Explorer integration Built with the official SDK + crypto libraries. ⚠️ Experimental • Unofficial • Alphanet only 🔗 https://github.com/buildbyravi/thru-wallet-ext /thru /build /wallet /web3

Built Wallet Balance Tracker v9 📊 A Google Apps Script library that brings multi-chain wallet tracking to Google Sheets. ✨ Features: • 500+ wallets • ERC-20 + native balances • Multicall3 batching • Dashboard • CSV export • Auto refresh • Cross-chain EVM support No backend required. 📚 Docs: https://wallet-tracker-docs.vercel.app 💻 GitHub: https://github.com/buildbyravi/wallet-tracker-docs /build /googleapps /web3 /base /eth /bnb /wallet /talent

━━━━━━━━━━━ get it ━━━━━━━━━━━ 🌐 docs + one-click Sheet copy: https://wallet-tracker-docs.vercel.app 🐙 source: https://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.

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

━━━━━━━━━━━ 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. → LockServicetime-based triggers can fire concurrently. LockService makes later instances skip rather than write the same column twice and corrupt data.