Quick overview
This workflow monitors ERC-20 transfers from an Atria feed, enriches large transfers with CoinGecko pricing, GoPlus token safety signals, and Google Sheets wallet labels, stores them in a Google Sheets ledger, and posts an hourly digest to Telegram while archiving older ledger rows weekly.
How it works
- Atria Trigger: creates and starts its own ERC-20 Atria feed when you activate the workflow, and delivers the largest transfer of each block.
- Deduplicates tokens and queries CoinGecko for contract metadata (decimals, symbol) and USD pricing, then converts raw token amounts into human amounts and USD value.
- Drops unpriced transfers, filters remaining events to only keep transfers worth at least $100,000, and batches unique token contracts per chain for GoPlus token_security checks.
- Fetches GoPlus token safety data, joins it back to each transfer, and adds risk flags such as honeypot and owner-changeable indicators.
- Loads known wallet labels from a Google Sheets “Wallets” tab, stamps each transfer with labels appends the enriched event to the “Whale transfers” sheet.
- Runs hourly to read the ledger, aggregates the last hour’s transfers into summary stats and top flows, uses Google Gemini to draft a 3–5 bullet JSON digest, renders it into Telegram-safe HTML, and posts it to Telegram.
- Runs weekly to read the ledger, append rows older than 7 days to a “Whale transfers archive” sheet, and then delete the archived rows from the main ledger.
Setup
- Install the
n8n-nodes-atria community node and add Atria API credentials with feed/output manage and read scopes.
- Add Atria credentials - In the Atria dashboard (Account → API Keys) create an API key with the scopes feeds.read, feeds.manage, outputs.read, outputs.manage, and store it in n8n as an Atria API credential (base URL https://atria.pulsy.app/api).
- Add Google Sheets OAuth credentials, set your spreadsheet ID in all
REPLACE_WITH_SPREADSHEET_ID fields, and create sheets named “Whale transfers”, “Wallets” (with address and label columns), and “Whale transfers archive” (same headers as the ledger).
Add a Google Gemini (PaLM) API credential for the Gemini chat model used by the digest writer.
- Add a Telegram bot credential and replace
REPLACE_WITH_TELEGRAM_CHAT_ID with your target chat ID.
Requirements
- An Atria account and an API key.
A Google account for the ledger.
A Telegram bot and the chat id to post to.
A Gemini API key for the digest agent.
Customization
- Whale floor: WHALE_MIN_USD in Whale Gate.
Ledger retention: RETAIN_DAYS in Partition Ledger Rows