Python or Node.js developer for Blockchain Wallet Wealth Calculator
Summary
We need a simple script to calculate on-chain wealth for a list of Ethereum wallets. Input and output must be integrated with Google Sheets.
Phase 1 Scope:
- Read a list of Ethereum wallet addresses from Google Sheets
- For each wallet:
- Use API to get token balances
- Focus on ETH, stablecoins (USDC, USDT, DAI), and major tokens (AAVE, UNI, etc.)
- Skip wallets with no activity in the last 12 months
- Fetch token prices (e.g. via Coingecko, use caching)
- Calculate total USD value per wallet
- Write results (breakdown + total value) back to Google Sheets
Requirements:
- Use Python (preferred) or Node.js
- Handle large lists (1kโ30k+ wallets)
- Respect API limits (support basic caching or batching)
Deliverables:
- Script + Google Sheet integration
- README with setup instructions
If this goes well, we will expand to more advanced scoring (NFTs, social data, clustering).