Record water meter reading, control servo motor, email results in Excel spreadsheet

OPERATION: Use pulses from a contact head water meter to record the gallons per minute every 15 minutes for a duration of 240 minutes. IF the gallons per minute ever goes to '0' during the 240 time, THEN operate a servo motor to rotate clockwise 5 degrees every 20 seconds until water flow is detected by the water meter. Maximum number of 5 degree steps is 7. After flow is detected continue to record gallons per minute every 15 minutes for the initial 240 minute duration. REPORTING: After the 240 minutes has elapsed, an Excel spreadsheet report is to be sent by email (address hardcoded) using 4G cellular modem via a gateway and service provider based in the USA. All recorded data points are to be entered into individual cells in an Excel spreadsheet. Exact spreadsheet formatting to be determined. Message Subject: "GPM Test Complete: [modem'sEIN]". ALARMING: 1) IF water meter reads '0' gallons per minute, immediately: a) local alarm (beeper/led) to activate AND b) an email is to be sent to the hardcoded email address, Message Subject: "Zero GPM Alarm: [modem's EIN]". OTHER INFORMATION: Device to be operated by rechargable battery able to operate for 480 minutes. Motor torque specs to be determined. DELIVERABLES: 2 complete working and ready to field test devices in waterproof enclosures. Parts (motor, water meter), Arduino modules/shields, & source/machine code. BUDGET: $500 for all work and deliverables.