See llms.txt for all machine-readable content.

Back to Templates

Digest large ERC-20 transfers with Atria, CoinGecko, Gemini and Telegram

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

  1. Atria Trigger: creates and starts its own ERC-20 Atria feed when you activate the workflow, and delivers the largest transfer of each block.
  2. Deduplicates tokens and queries CoinGecko for contract metadata (decimals, symbol) and USD pricing, then converts raw token amounts into human amounts and USD value.
  3. 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.
  4. Fetches GoPlus token safety data, joins it back to each transfer, and adds risk flags such as honeypot and owner-changeable indicators.
  5. Loads known wallet labels from a Google Sheets “Wallets” tab, stamps each transfer with labels appends the enriched event to the “Whale transfers” sheet.
  6. 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.
  7. 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

  1. Install the n8n-nodes-atria community node and add Atria API credentials with feed/output manage and read scopes.
  2. 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).
  3. 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.
  4. 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