Track Singapore COE Prices with AI Forecasting & Smart Buy Recommendations via Telegram
Go to Workflow
Cheng Siong Chin
Description
Introduction
Automates Singapore COE price tracking with AI forecasts and buy/wait recommendations. Weekly scraping collects LTA data, enriches with economic indicators, predicts 6-month trends, and alerts users via Telegram/email—helping car buyers and fleet managers make data-driven purchase decisions while avoiding manual tracking.
How it Works
Weekly trigger scrapes LTA COE → validates → stores in Google Sheets → calculates indicators → AI forecasts trends → multi-scenario analysis → generates buy/wait signals → sends actionable alerts.
Setup Steps
Add OpenAI/NVIDIA API credentials in n8n
Authenticate Google Sheets and create spreadsheet
Configure Telegram bot or Gmail SMTP
Set weekly trigger (Thursday 9AM SGT post-bidding)
Adjust alert thresholds in conditional nodes
Workflow
Schedule Trigger → Scrape COE → Validate → Store Sheets → Fetch Historical → Calculate Indicators → AI Prediction → Merge Economics → Multi-Scenario Analysis → Compare Conditions → Generate Dashboard → Send Alerts
Workflow Steps
Scraping: Fetch LTA COE results with retry logic
Validation: Check completeness, flag anomalies
Storage: Append timestamped records to Sheets
Enrichment: Calculate moving averages, volatility, seasonality
AI Analysis: Forecast next 6 months with confidence intervals
Decision Engine: Output buy/wait/monitor recommendation
Reporting: Create dashboard and send alerts via Telegram/email
Prerequisites
OpenAI/NVIDIA API key, Google Sheets access, Telegram bot token or Gmail, basic COE category understanding
Use Cases
First-time buyers timing purchases, fleet operators coordinating bulk acquisitions
Customization
Add SMS alerts via Twilio, integrate loan calculators for total cost analysis
Benefits
Saves 5+ hours monthly, captures 10–18% price dips, provides predictive insights (potential $10K–$25K savings)