I need a reliable way to feed real-time location updates from our AVL truck-tracking platform straight into a Google Sheet, refreshing automatically every 30 minutes. The AVL system exposes the data, but I don’t yet have the script or connector that will pull it, parse it, and drop it into the correct columns in Sheets. Here’s what success looks like to me: • A Google Apps Script, Python micro-service, or other lightweight solution that calls the AVL API/webhook on a 30-minute schedule. • Latitude, longitude, timestamp, truck ID, and any additional fields you can surface neatly appended (or updated) in the Sheet without manual intervention. • Clear instructions so I can deploy, adjust the interval later, and add trucks as our fleet grows. • A quick live test proving that new AVL location data appears in Sheets right on schedule. If you’ve linked GPS feeds such as Geotab, Samsara, or Fleet Complete to Google Workspace before, you’ll recognize the workflow—just bring that know-how to AVL. Let me know what language or tool stack you prefer and how long you’ll need to deliver a working prototype.