Write some Software

I need a web scraper to be built. The scraper will scrape a number of airline websites and extract (i) price information and (ii) points information for a list of flights on a variety of dates. The software should use web-based technology (e.g. php) so that this can be hosted on a web server and run daily at a pre-set time (e.g. via a cron job). The tool should: 1. Read a list of airlines from a Google sheet 2. Read a list of flights for each airline from another Google sheet 3. Read a list of dates for each flight from another Google sheet 4. For each airline/flight/date combination, scrape each airline's site and extract: - Search for flights for *each* of the 7 days prior to the date - Search for flights for *each* of the 7 days after the date - Extract the price for the flight in $$'s each class - Extract the price for the flight in airline miles/points for each class The extracted data should be stores in a mysql database one row per combination of elements in a table e.g.: Date Airline Flight Class Cost ($) Cost (Miles)