geekyroshan
Back to Projects
WhatsApp Market Monitor
Data Engineering

WhatsApp Market Monitor

Real-time message capture system for premium watch marketplace. Webhooks + Google Sheets pipeline.

About the Project

WhatsApp Market Monitor is a real-time message capture system built for a premium watch trading marketplace. It monitors WhatsApp group messages via webhooks from a WAHA container, processes them through a FastAPI backend with 10 concurrent workers, and stores structured data in Google Sheets. Includes SQLite deduplication, LID resolution for phone numbers, and graceful error handling.

Key Features

  • WAHA headless WhatsApp client with NOWEB engine
  • 10 concurrent workers for high-throughput processing
  • Rate-limited batch writes respecting Google Sheets API quotas
  • Automatic contact discovery and group member tracking
  • Dead letter queue for robust error recovery

Impact

Enables market intelligence gathering from WhatsApp communities with production-grade reliability and data integrity.

Tech Stack

FastAPIWAHAGoogle Sheets APISQLiteDocker

Metrics

10 concurrent workers
Rate-limited batch writes
Contact discovery

Links

No public links available for this project.

Interested in this project?

Let's discuss how I can build something similar for you.