The Route Matrix Google Sheetsᵀᴹ add-on streamlines transportation planning. Simply input your origin and destination locations, and the add-on generates a comprehensive distance or time matrix.

The add-on includes conditional formatting that highlights optimal locations - making it easy to identify which facility, meeting spot, or hub minimizes total travel distance or time across all routes.

This tool saves hours of manual calculations, enabling you to efficiently optimize locations, schedules, and routes.  

Basic usage of the add-on is free. Searches of up to 10 simultaneous routes are free. Larger searches use a faster API and cost $7 per 1,000.

If Google Mapsᵀᴹ can interpret the locations, they will work in this add-on. Accepted location identifiers include:

Latitude / Longitude
Will snap to the nearest road
Street address
Plus Code
City / Country / Other political boundary
Point of interest
Airport
Park