Upgrade your Travel Formulas Google Sheets add-on with three paid formulas. These formulas provide several key benefits beyond the standard features.
Contents
Increased Usage & Advanced Features
The premium formulas offer unlimited daily usage, freeing you from the standard daily limits of 1,000 direction requests for Gmail users and 10,000 for Google Workspace users.
In addition, you’ll gain access to two powerful features:
- Tolls Calculation: Get accurate estimates of toll costs for your routes.
- Avoid Feature: Customize your routes by avoiding specific roads or modes of transport, including:
- Tolls
- Highways
- Ferries
- Indoor routes
Pricing
$7 for 1,000 basic routes (not traffic-aware) or 500 traffic-aware routes above Google’s daily limit. Purchase them here or through the add-on using the Extensions -> Travel Formulas menu and selecting Purchase more searches.
Three Premium Travel Formulas
TRAVELTIME_API – Returns the trip duration between two locations
TRAVELDISTANCE_API – Finds the trip distance between two locations
TRAVELTOLLS_API – Calculates the tolls between two locations
TRAVELTIME_API Formula
Returns the trip duration between two locations in HH:MM without impacting your daily usage limits
=TRAVELTIME_API(origin, destination, mode, avoid, departure_time)
origin – The starting address
destination – The ending address
mode – The mode of travel (“driving”, “walking”, “bicycling”, “transit”) [optional, defaults to driving]
avoid – Features to avoid: 0-None, 1–Tolls, 2–Highways, 3–Ferries, 4–Indoors [optional, defaults to 0]
departure_time – A datetime in the FUTURE for transit/driving in traffic. Best to use a cell reference formatted to datetime [optional]
TRAVELDISTANCE_API Formula
Finds the trip distance between two locations without impacting your daily usage limits
=TRAVELDISTANCE_API(origin, destination, mode, unit, avoid)
origin – The starting address
destination – The ending address
mode – The mode of travel (“driving”, “walking”, “bicycling”, “transit”) [optional, defaults to driving]
unit – The unit of distance (“mi”, “km”) [optional, defaults to miles]
avoid – Features to avoid: 0-None, 1–Tolls, 2–Highways, 3–Ferries, 4–Indoors [optional, defaults to 0]
TRAVELTOLLS_API Formula
Calculates the tolls between two locations
=TRAVELTOLLS_API(origin, destination)
origin – The starting address
destination – The ending address
