OpenSprinkler & AROYA Data Automation

Project: Automate OpenSprinkler + AROYA Data into Google Sheets
I need a developer to build a simple automation that pulls irrigation and sensor data from OpenSprinkler and AROYA using their APIs (I have the API keys). The data should automatically update into a Google Sheet on a schedule.
Scope of Work:
Connect to both APIs (OpenSprinkler + AROYA) using provided keys.
Fetch irrigation events (timestamp, zone, duration, volume, feed EC/pH).
Fetch AROYA sensor logs (timestamp, sensor_id, VWC %, EC substrate, temp °C, RH %, irrigation event).
Write the data into two Google Sheet tabs:
OpenSprinkler_Log
Aroya_Log
Normalize columns (use ISO-8601 timestamps).
Set up a scheduled refresh (every 15–60 minutes) using Google Apps Script trigger or another reliable method.
Add a Status tab to log last run and any errors.
Provide a short README inside the sheet explaining how to change API keys, endpoints, and schedule.
Deliverables:
Fully working, scheduled automation with my sample Google Sheet.
Clean code (Google Apps Script preferred, Python acceptable if it writes to Google Sheets).
Quick Loom/video walkthrough (2–5 minutes) showing how it works.
Milestones:
M1 (25%): OpenSprinkler data flowing to Sheet on schedule.
M2 (25%): AROYA data flowing to Sheet on schedule.
M3 (50%): Dedupe, Status tab, README, and handover.
Budget: $120–$180 fixed price.
Timeline: 3–5 days.
Preferred Skills: Google Apps Script, Google Sheets API, REST API, JSON, data automation.
Please include in your bid:
An example of a Google Apps Script (or similar) you’ve written that fetches JSON from an API and writes to a Sheet.
Which approach you’d use (Apps Script, Zapier/Make, or Python).
Confirmation that you can start immediately and deliver in under a week.