←SELECTED WORKS•CASE 02•ai

AI-Driven Statistics Hub

Automated daily data collection pipeline consolidating Hermes Playwright cron jobs, Tavily API, a scheduled Telegram bot, and Google Analytics into ONE central spreadsheet and exportable stats hub

AUTOMATED STATISTICS HUBDAILY SYNC ➔ ONE SPREADSHEET ➔ PDF
hub.internal/statistics
Automated Multi-Source Statistics & Reporting Hub
All data arrives automatically in ONE spreadsheet daily, powering the stats hub webpage and easy PDF export.● LIVE
✦ Pipeline: Hermes (Cron/Playwright) + Tavily API + Telegram Bot + GA ➔ 1 SpreadsheetHEALTHY
SYSTEM // CAMPAIGN_ANALYTICS

Autonomous Multi-Source Analytics Hub

Hermes Playwright cron agents, Tavily, Telegram bots, and GA piped into a real-time intelligence sheet.

Automated Multi-Source Statistics & Reporting Hub

All data arrives automatically in ONE spreadsheet daily, powering the stats hub webpage and easy PDF export.

01 // PROVEN IMPACTVERIFIED
0% Automated

Hermes Playwright cron, Tavily API, Telegram bot, and Google Analytics automatically consolidate into ONE central spreadsheet daily with zero manual entry.

DATABASE: 1 SPREADSHEET● DAILY PIPELINE
02 // THE CONTEXTPROBLEM ➔ FIX
THE CHALLENGE

Tracking statistics across WeChat, SigStick, Giphy, WhatSticker, Telegram, and websites required checking incompatible interfaces with no centralized database.

THE SOLUTION

Built an automated daily pipeline where a Hermes agent (cron + Playwright), Tavily API, a scheduled Telegram bot, and Google Analytics consolidate data into ONE central spreadsheet, powering a live stats hub and PDF exports.

ZERO LONG PARAGRAPHS
WORKFLOW // END-TO-END STATISTICS WORKFLOW
HERMES CRON · PLAYWRIGHTTG BOT SCRIPT (CRON)TAVILY API INGESTDIRECT GA4 FEEDWECHATSIGSTICKLINETELEGRAM (TG)WHATSTICKERGA (TRAFFIC)1 SPREADSHEETCENTRAL DATABASE1,420+ ROWS● 100% AUTOMATEDSTREAMSTATS HUB // WEBLIVEBARS · CHANNELSPIE · SHARE100%LINE CHART · 30-DAY IMPRESSIONSPEAK +28%DATA TABLE · MULTI-CHANNEL LOGSRCVIEWSCONVWECHAT48.2k9.4%SIGSTICK32.1k8.1%TELEGRAM24.3k7.2%WHATSTK28.5k7.6%GA TRAFFIC52.1k11.2%EXPORTPDFSTATS REPORTEXECUTIVESUMMARY CHARTVERIFIED ✓P.1 / 1GENERATE PDF ↓1-CLICK EXPORT
HERMES PLAYWRIGHT CRON · 4 FEEDS1 SPREADSHEET · DAILY SYNC ✓
02 // XAVIER'S ROLE & HOW HE BUILT ITSYSTEM DESIGN & AUTOMATION PIPELINE

CASE STUDY ROLE: SYSTEM DESIGN & AUTOMATION PIPELINE

The system automates daily data collection across multiple channels with zero manual data entry.

Each day, an autonomous Hermes agent executes a scheduled cron job using Playwright headless scripts to scrape metrics from WeChat, SigStick, and Giphy. Concurrently, an automated Tavily API call queries WhatSticker stats, a Telegram bot runs on a schedule executing a script to gather Telegram statistics, and Google Analytics provides website traffic data.

All of this incoming data lands automatically into ONE single spreadsheet that serves as the centralized database. Once the spreadsheet updates daily, the stats hub webpage immediately reflects the latest data with interactive filtering and selectable time ranges, and a clean PDF report can be exported with one click.

WHAT XAVIER DIRECTLY DELIVERED & SHIPPED
Configured a Hermes agent running daily cron jobs with Playwright scripts to collect WeChat, SigStick, and Giphy stats
Integrated a Tavily API call to query and capture WhatSticker statistics automatically
Implemented a scheduled Telegram bot that executes scripts to collect Telegram statistics
Connected Google Analytics to automatically supply daily website traffic and visitor metrics
Consolidated all collection streams into ONE central spreadsheet acting as the single database for the hub
Connected the centralized spreadsheet to the stats hub webpage for live data display and one-click PDF export
HANDS-ON OWNERSHIPDIRECT ARCHITECT & BUILDER
03 // LANGUAGES & TOOLS USED
LANGUAGES & CORE RUNTIME
TypeScriptJavaScript (ES6+)PythonBash
FRAMEWORKS & ENGINES
PlaywrightChart.jsExpress.jshtml2pdf.js
TOOLS, AI MODELS & APIS
Hermes AI AgentPlaywright ScriptsTavily APITelegram Bot APIGoogle AnalyticsGoogle Sheets API
STORAGE & INFRASTRUCTURE
Single Central Spreadsheet (Database)Cron Job SchedulerStatistics Hub WebpagePDF Export Engine
CASE STUDY TECH ECOSYSTEM
Hermes AI AgentPlaywrightTavily APITelegram Bot APIGoogle AnalyticsGoogle Sheets APISingle Spreadsheet DBhtml2pdf.js
TECH ARCHITECTURE● FULLY FUNCTIONAL
04 // AUTOMATED MULTI-SOURCE INGESTION WORKFLOW

Multi-Platform Data Collection & Centralized Database

● AUTOMATED END-TO-END WORKFLOW
HERMES + PLAYWRIGHT

WeChat, SigStick & Giphy

Method: Hermes Agent + Playwright

A Hermes agent runs a daily cron job with Playwright scripts to automatically collect WeChat, SigStick, and Giphy stats.

SourceMulti-Platform Channels
TAVILY API

WhatSticker Metrics

Method: Tavily API Call

An automated Tavily API call queries and extracts WhatSticker statistics directly without manual lookup.

SourceWhatSticker Platform
TELEGRAM BOT

Telegram Statistics

Method: Scheduled Telegram Bot

A Telegram bot runs automatically on a schedule and runs a dedicated script to collect Telegram stats.

SourceTelegram Channels
GOOGLE ANALYTICS

Website Traffic Data

Method: Google Analytics

Google Analytics automatically provides website traffic data and visitor telemetry on a daily schedule.

SourceWebsite Analytics
ONE SPREADSHEET

Single Central Spreadsheet

Method: One Google Spreadsheet

All collection channels land daily in that ONE spreadsheet, acting as the centralized database for the hub.

SourceCentralized Database
STATS HUB & PDF

Stats Hub Webpage & PDF

Method: Web Dashboard & PDF Export

Once the spreadsheet updates, the stats hub webpage reflects new data, allowing instant PDF report export.

SourcePresentation & Export
05 // USER-FACING RESULT: STATISTICS HUB CAPABILITIES

Centralized Intelligence, Sticker Drill-Downs & PDF Export

REPORTING & DISCOVERY
UNIFIED HUB

Cross-Source Statistics in One Hub

Consolidates all metrics from external channels and web traffic into a single unified view powered by the central spreadsheet.

CapabilityReady
SMART FILTERS

Centralized Filtering

Multi-dimensional filters let users slice data across channels, platforms, and sticker packs simultaneously.

CapabilityReady
TIME RANGES

Selectable Time Ranges

Dynamic time pickers enable quick comparison across campaign launch windows, weeks, or custom date spans.

CapabilityReady
STICKER DRILL-DOWN

Individual Sticker Statistics

Granular drill-downs provide detailed performance analytics for each individual sticker and pack.

CapabilityReady
PDF REPORTS

Report-Format PDF Generation

Generates clean, report-formatted PDF documents directly from the stats hub webpage with one click.

CapabilityReady
06 // HOW THE SYSTEM WORKS

HOW THE AUTOMATED PIPELINE WORKS

4-STEP PIPELINE
STEP 01
01/04

Automated Daily Collection

Hermes agent runs Playwright cron jobs (WeChat, SigStick, Giphy), Tavily API collects WhatSticker, and scheduled Telegram bot runs scripts.

StatusActive
STEP 02
02/04

Google Analytics Ingestion

Google Analytics provides website traffic data to join the automated daily ingestion stream.

StatusActive
STEP 03
03/04

One Central Spreadsheet

All data streams land automatically into ONE central spreadsheet serving as the centralized database.

StatusActive
STEP 04
04/04

Stats Hub & PDF Export

The stats hub webpage instantly reflects the updated spreadsheet data, ready for browsing and one-click PDF export.

StatusActive