The Route Matrix Google Sheets add-on streamlines transportation planning. Simply input your origin and destination locations, and the add-on generates a comprehensive matrix of distance or time.
This powerful tool saves hours of manual calculations, enabling you to optimize routes and schedules efficiently.
Contents
Three Simple Steps
Route Matrix creates a matrix of distances or times between locations in Google Sheets in three easy steps.
- Enter the starting locations
- Enter the ending locations
- Click RUN
Route Matrix Output
You get the distance or time between all combinations of routes between the starting and ending locations.
Output Options
- Calculate distances in miles or kilometers.
- Choose between distance or time in minutes
- Use different transportation modes.
- Driving, biking, transit, etc.
- Specify a departure day and time.
Route Matrix fetches starting and ending locations from your Google Sheet, and you tell it what to return – distance or time. Our app sends the addresses confidentially to Google MapsTM and returns the calculated data to your spreadsheet. Use a custom departure date and time to predict travel time based on expected traffic loads.
Location Formats
If Google MapsTM 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
Run Fast – Premium Feature
The RUN FAST button calculates your routes more quickly and can handle matrices with up to 625 values instead of 20. It cleans addresses before returning them. Also, the run faster button is not subject to the other usage limitations of the RUN button.
Pricing
Basic usage of the add-on is free. Searches of up to 10 simultaneous routes are free. More extensive searches use a faster API and cost $7 per 1,000. You can purchase these faster searches here or through the add-on using the RUN FAST button. Be sure to enter the email that matches your Google account.
Other Travel Add-Ons
Use TripTally to find the time or distance between pairs of locations or Travel Formulas to access Google Maps with custom functions.
FAQ
How many routes can Route Matrix process?
Route Matrixes are created using the free RUN button function per the daily quotas Google imposes on all add-ons and apps. This limits the appās run time to 30 seconds per request, 1,000 or 10,000 free route requests per day (depending on the type of Google account), and an overall daily run time.
If you useĀ Travel FormulasĀ or TripTally, these add-ons share the same Google Maps free quota.
You can purchaseĀ more daily route requestsĀ to access the RUN FAST button, which ignores these limits.
Does TripTally work with Place Chips?
Yes, any locations that Google Maps recognizes will work in the TripTally. The chipās formatting does not impact the validity of a location.
How do I solve the Permission Denied error code?
The error message āWeāre sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED.ā occurs when a user is logged into multiple Google accounts. Log out of all other Google accounts, restart your browser, and start the add-on again.
How do I use the add-on with my iPad?
Open your Google Sheet in the Safari web browser instead of Chrome or the Sheets mobile app. If you still do not see the full version of Google Sheets, go to Settings, then Safari, and select Request desktop website. Toggle this setting to on.
Video Tutorials
Subscriber Portal | Terms of Service | Privacy Policy | Contact