KML Live Update from Google Sheets to Google Earth Pro

This project automatically generates and publishes a KML file from a live-updating Google Sheet. The KML file is hosted on GitHub and can be loaded into Google Earth Pro via a Network Link for real-time geospatial visualization.

---

What It Does

• Reads rows from a Google Sheet containing location data (latitude, longitude, classification, etc.)
• Groups placemarks into color-coded folders by classification (e.g., Metropolitan, Regional, PO Box)
• Generates a valid .kml file using Google Apps Script
• Automatically uploads the KML to this GitHub repository
• Allows Google Earth Pro to refresh and reflect the latest updates from the spreadsheet

---

How It Works

1. Google Apps Script reads your Mapping sheet.
2. It dynamically generates a KML string from your data.
3. It uploads locations.kml to GitHub using the GitHub REST API.
4. Google Earth Pro pulls that file via Network Link.

---

GitHub Raw KML Link (for Google Earth Pro)

Paste this into Google Earth Pro as a Network Link: