Contents [hide]
Three Simple Steps
TripTally finds the distance, travel time, or route between locations in Google Sheets in three easy steps.
- Enter the beginning locations
- Enter the ending locations
- Click run
Custom Travel Route Options
- Calculate distances in miles or kilometers.
- Use different transportation modes.
- Driving, biking, transit, etc.
- Provide a link to the directions in Google MapsTM.
- Specify a departure day and time.
TripTally fetches starting and ending locations from your Google Sheet, and you tell it what to return – distance, time, or a link to the directions on Google MapsTM. Our app sends the locations 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
Custom Formulas
Check out our Travel Formulas add-on if you prefer formulas instead of a sidebar.
Video Tutorials
Pricing
TripTally is free for seven days, then $4.75 monthly or $67 for a lifetime license. Be sure to use your Google account’s email address.
Multiple User Pricing
We offer the following discounts for multiple users in the same organization. Contact us before you checkout.
| Quantity | Monthly Price | Lifetime License |
|---|---|---|
| 2 – 10 | $3.75 | $47 |
| 11 – 50 | $2.75 | $31 |
| 51 – 200 | $1.00 | $17 |
| 201 + | $.75 | $7 |
FAQ
How many routes can TripTally process?
TripTally functions 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.
You can purchase more daily route requests to increase the daily limit.
The limits are the same in the free and paid versions of TripTally. If you use Travel Formulas or Route Matrix, these add-ons share the same Google Maps quota.
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.
Subscriber Portal | Terms of Service | Privacy Policy | Contact