Web3 Wallet Tracker: Sync Balances to GA4, BigQuery, and Discord Whale Alerts
This workflow bridges the gap between anonymous website traffic and on-chain wallet activity. It captures wallet connections via a webhook, enriches the data with real-time USD balances from the Zerion API, and syncs ...
Template notes
This workflow bridges the gap between anonymous website traffic and on-chain wallet activity. It captures wallet connections via a webhook, enriches the data with real-time USD balances from the Zerion API, and syncs the results to Google Analytics 4, BigQuery, and Discord for immediate action.
This directly helps Web3 marketing and growth teams identify high-value "whales" the moment they connect to your dApp, allowing for real-time monitoring and advanced attribution analysis.
How it works
Video tutorial: https://youtu.be/2wuTRzRpkg
How it works Webhook Trigger: Receives the wallet address, GA Client ID, and Session ID from your website via GTM.
Zerion API Integration: Queries the real-time USD balance and individual chain distributions for the connected wallet.
Whale Filtering (Switch): A logic that filters wallets based on a USD threshold (e.g., >$50) to trigger high-priority alerts.
Dynamic Discord Alerts: Sends a formatted message to Discord with a 2-decimal rounded total balance and a dynamic breakdown of assets across all active chains (Base, Ethereum, etc.).