INK-AUT-001
SMS Poster Automation
SMS Poster Automation is an end-to-end system that automatically collects the latest gold and silver prices, updates poster templates, generates PNG and PDF files, and sends the finished posters through WhatsApp.
Overview
The solution automates the complete daily poster workflow—from fetching live price data to delivering the final creative. Selenium collects the latest gold and silver prices from the source website, stores them in MongoDB, updates the poster template, downloads the output, and distributes it through WhatsApp.
The Requirement
The requirement was to eliminate the repetitive manual process of checking daily prices, editing posters, exporting files, and sending them to customers or WhatsApp groups. The system needed to run at a fixed time, maintain accurate pricing data, generate consistent branded posters, and complete the entire process with minimal human involvement.
What We Built
A scheduled automation workflow featuring: Automatic gold and silver price extraction MongoDB price storage with timestamps Dynamic poster template updates PNG and PDF poster generation WhatsApp Desktop distribution Execution logs and failure alerts Daily scheduling using Windows Task Scheduler or Cron
Outcome
The final solution creates a fast and reliable daily publishing workflow. Updated gold and silver posters are generated and delivered automatically, reducing manual effort, preventing pricing errors, and ensuring that customers receive the latest information on time.
Core Features
Scheduled Execution
Runs automatically at a predefined time every day.
Automated Price Scraping
Uses Selenium to fetch the latest gold and silver rates.
WhatsApp Automation
Sends the generated poster to selected contacts or groups
MongoDB Integration
Stores prices with timestamps for tracking and reuse.