Automated Gold Price Tracking System

Tracking gold prices by hand across multiple sources is tedious and easy to forget, so I built a fully automated pipeline to capture prices on a schedule, store them, visualize the trends, and alert me to meaningful moves. Using Google Apps Script, the system pulls gold prices via APIs on a timer, writes them into Google Sheets as the data store, surfaces trends in a Looker Studio dashboard, and pushes threshold alerts through a Telegram bot.

The whole pipeline is serverless, running entirely on Apps Script triggers with no infrastructure to maintain. Data is normalized on ingest, deduplicated, and appended to Sheets; Looker Studio reads directly from that sheet for always-fresh dashboards; and the Telegram bot fires only when prices cross configurable thresholds, so the alerts stay signal rather than noise. It runs fully automated today and remains an ongoing personal project I extend whenever a new data source becomes useful.

More than anything, it proved how much of a superpower serverless, schedule-driven automation is for personal data projects — the entire system costs nothing to run and needs almost no maintenance once the triggers are set, which is exactly what keeps it alive long after the initial build.