I need a clean, reliable link between my existing GPS tracking platform and a Google Sheet. Using the platform’s REST API, the sheet must update in real-time with route information. Every new trip should automatically append a row containing start and end locations, distance travelled, and time taken. Please build or supply the code (Apps Script, webhook, or another lightweight solution) that: • Authenticates securely with the GPS API • Listens or polls for new route events in real-time • Parses the required fields and writes them to the designated columns in Google Sheets without duplication • Includes basic error handling and logs so I can trace any failed calls A short hand-off document or inline code comments explaining how to adjust tokens, sheet IDs, and refresh intervals will be enough for me to maintain it after delivery.