Flight Deal Tracker

A Python project that checks for cheap round-trip flights from a fixed origin city to a list of destinations stored in a Google Sheet (via the Sheety API). It automatically looks up missing IATA airport codes and searches for flights within a future date range using Kiwi Tequila’s flight search API.

This project demonstrates working with external APIs, structured data modeling, and basic automation for price monitoring.

---

What it Does

• Reads destination city + price data from a Google Sheet using the Sheety API
• If a destination is missing an IATA code, it:
  • queries the Kiwi Tequila Locations API
  • updates the Google Sheet with the correct IATA code
• Searches for round-trip flights:
  • from a fixed origin airport/city code (example: LON)
  • within a date range (tomorrow → ~6 months ahead)
  • for trips lasting 7 to 28 nights
  • with no stopovers (direct flights only)
• Prints the best price found per destination (if available)

---

Technologies Used

• Python
• Requests (HTTP requests)
• Sheety API (Google Sheet as a REST API)
• Kiwi Tequila API (flight search + IATA codes)
• Dataclasses / OOP style structuring (DataManager, FlightSearch, FlightData)

---

Project Structure (Suggested)

• main.py
  Runs the automation loop: reads sheet data, fills missing IATA codes, checks flights.

• data_manager.py
  Handles reading/updating destination data from the Sheety API.

• flight_search.py
  Handles Tequila API calls for destination codes and flight searching.

• flight_data.py
  Stores flight result data in a structured object.

---

Requirements

• Python 3.8+
• A Sheety project endpoint
• A Kiwi Tequila API key

pip install requests