Contents
Three Simple Steps
TripTally finds the distance between addresses in Google Sheets in three easy steps.
- Enter the location of the beginning addresses
- Enter the location of the ending addresses
- 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 addresses 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 addresses confidentially to Google MapsTM and returns the calculated data to your spreadsheet. Use a custom departure date and time for travel time predictions based on expected traffic loads.
TripTally Setup
Use your spreadsheet with addresses, or have TripTally create a template. If Google MapsTM can interpret the addresses, they will work in this add-on.
Custom Formulas
Check out our Travel Formulas add-on if you prefer formulas instead of a sidebar.
Video Tutorial
Pricing
TripTally is free for seven days, then $67 for a lifetime license. No subscription is needed.
Multiple User Pricing
We offer the following discounts for multiple users in the same organization. Contact us before you checkout.
| Quantity | Unit Price |
|---|---|
| 2 – 10 | $47 |
| 11 – 50 | $31 |
| 51 – 200 | $17 |
| 201 + | $7 |
FAQ
How many addresses 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 30sec per request, 1,000 or 10,000 directions requests per day (depending on the type of Google account), and an overall daily run-time. Contact me for a discount on your first year of Google Workspace. I can provide discount codes if you are in the US or Canada.
The limits are the same in the free and paid versions of TripTally. If you use Travel Formulas, both add-ons share the same Google Maps qouta.
Does TripTally work with Place Chips?
Yes, any address that Google Maps recognizes will work in the TripTally. The chip’s formatting does not impact the validity of an address.
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.
