Automation
ESG Emissions Calculator — Google Apps Script
Automated distance calculation for 150+ employees to enable ESG reporting
The Problem
The company needed to create its first ESG report and calculate the ground distance between the addresses of over 150 employees and headquarters. Manually calculating considering actual routes (not straight line) would be extremely time-consuming, error-prone, and not scalable, especially with new hires.
The Solution
I created an automation in Google Sheets using Apps Script that automatically calculates the actual ground distance between employee address and company headquarters via Google Maps API. The spreadsheet has a custom button that, when clicked, automatically recalculates all distances, allowing updates whenever the base is modified.
Tech Stack
Impact Generated
- Elimination of an unfeasible manual process
- Significant reduction in operational time
- Standardization of distance calculations
- Enablement of the company's ESG report
- Solid foundation for future emissions and environmental impact analyses of commuting
Employees
150+
Precision
Actual ground route via Google Maps
Updates
Manual via custom button
Tech Stack
Overview
Automation
Technical Stack
Technical Challenges
- Integration with Google Maps API for ground route calculation
- Creation of custom button in Sheets interface
- Handling incomplete or invalid addresses