Decided to share an n8n case here. This workflow automatically generates and publishes a monthly ranking of the Top-5 crypto exchangers based on real user activity from Google Analytics 4 (GA4). It combines analytics, scanbit API, and internal payload data to create a visual banner and post it directly to the @scanbit_ua Telegram channel.

Data Flow:

GA4 → Payload API → Parser APIs → Merge + Sort → HTML → Image → Telegram If you have any questions, happy to answer them!