Warranty Tracker Alert Saved $2,400 Laptop Claim With 14 Days Left (7 Nodes) 🔥

Duy Bui

10h • General Discussion 💬

Laptop acting up. Warranty? No idea. Checked tracker. 14 days remaining. Filed claim. Got replacement.

Built warranty tracker. Every warranty organized. Expiration alerts automatic. Zero claims missed.

THE WARRANTY FORGOTTEN PROBLEM:

Buy product. Get warranty. File receipt somewhere. Product breaks. Search everywhere. Warranty expired last month.

Average household has 15-20 active warranties. Average person tracks zero systematically.

THE DISCOVERY:

Document extraction pulls warranty terms. Code calculates expiration date. Conditional alert triggers when approaching deadline.

30-day advance warning. Every warranty. No surprises.

THE WORKFLOW:

Google Drive trigger watches warranty folder → Download document → Document extraction pulls product details, purchase date, warranty duration, coverage terms → Code calculates expiration date and days remaining → Sheets logs to warranty tracker → IF checks if expiring within 30 days → Alert Slack when expiring soon.

7 nodes. Warranty money protected.

THE EXPIRATION LOGIC:

Code calculates: Purchase date + Warranty months = Expiration date.

Status determined by days remaining:

- Negative: Expired

- Under 30: Expiring Soon (triggers alert)

- Under 90: Active - Expires Soon

- Over 90: Active

THE CONDITIONAL ALERT:

Only Expiring Soon status triggers Slack. No spam for healthy warranties. Alert when action needed.

Product name, days remaining, coverage details included. Decision-ready information.

THE TRANSFORMATION: