WhatsApp Business Automation Suite — scheduler, FAQ bot & data pipeline (Python + Docker) - not tested

A production-ready automation suite that connects to the official WhatsApp Business Cloud API (Meta) and handles three common business pain points out of the box — with zero phone-online requirement.

What's included

Message scheduler — preload messages and send them to WhatsApp groups at exact cron-defined times (±1 second). Runs on a VPS with no phone required. Edit schedules via a plain YAML file and hot-reload without restarting.

FAQ auto-reply bot — keyword-based matcher reads a JSON knowledge base you can edit yourself. Built-in Redis deduplication prevents sending the same answer twice within a 10-minute window. Accuracy-tuned with configurable match thresholds.

Data entry pipeline — members send structured messages (e.g. #data name=John | amount=150 | date=2024-01-15) and rows are written automatically to Google Sheets and a local SQLite backup. CSV attachments via email are polled from Gmail every 5 minutes.

Automated reports — daily and weekly PDF + XLSX summaries are generated from your data and emailed to a recipient list via SendGrid — fully unattended.

Tech stack

Python 3.11 · FastAPI · APScheduler · Redis · gspread · ReportLab · openpyxl · SendGrid · Docker Compose. Runs on any €5/month VPS. All ongoing infrastructure costs are free-tier or near-zero.

Deliverables

29 source files · 2,300+ lines of commented code · editable YAML/JSON config files · full pytest test suite · one-command Docker deployment · Nginx + Let's Encrypt config · step-by-step setup guide from Meta console to live server.

Verified acceptance criteria

Scheduled messages within ±30s · FAQ dedup enforced per 10-min window · 100% field accuracy on 50-message batch (automated test included) · reports generate and send on schedule without manual intervention.