Flight Deal Finder
Automated Flight Price Tracker & Twilio WhatsApp Alert Bot
Conserves SerpApi search quotas with SQLite response caching while tracking Google Flights deals and alerting via WhatsApp.
An automated flight price tracking and notification system in Python. Queries target destination cities and price ceilings from Google Sheets via Sheety, searches live round-trip fares using SerpApi's Google Flights engine, persists new record lows, and dispatches WhatsApp alerts through Twilio.
Flight aggregator APIs carry strict monthly request limits, while repeatedly polling round-trip routes wastes quotas when routes haven't changed.
Real-world automation must respect rate limits and third-party API costs—combining local SQLite caching with deterministic alert thresholds turns a pricey API workflow into an economical daemon.
Engineering Objectives
System Architecture
Modular OOP pipeline orchestrating DataManager (Sheety API), FlightSearch (SerpApi + requests-cache), FlightData (lowest-fare extraction), and NotificationManager (Twilio WhatsApp).
SQLite Request Caching
Uses requests-cache backed by local SQLite storage to eliminate duplicate SerpApi round-trip lookups while keeping Sheety reads live.
End-to-End Alerting Workflow
Automatically updates lowest recorded prices in Sheets and formats route dates, airports, and savings for instant Twilio WhatsApp delivery.
Core & Backend Implementation
- DataManager wrapping authenticated Sheety REST reads and PUT price updates.
- FlightSearch integrating SerpApi Google Flights engine with requests-cache quota conservation.
- NotificationManager dispatching templated WhatsApp alerts through the Twilio Python SDK.
Client & Interface Layer
- Google Sheets operator dashboard managed remotely via Sheety API.
Data & Schema Design
Decouples human-editable route targets from cached third-party flight API payloads.
Authentication & Security Controls
- Zero committed credentials for SerpApi, Sheety Bearer tokens, or Twilio SIDs.
Engineering Challenges & Technical Decisions
Key Challenges Solved
Trade-Off Decisions
Testing & Verification Methodology
- Verified round-trip fare parsing across best_flights and other_flights arrays.
- Confirmed cache hits bypass redundant external SerpApi billing.