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
Features
- Save time for yourself or your business.
- Calculate distances in miles or kilometers.
- Use different transportation modes.
- Driving, biking, transit, etc.
- Provide a link to the directions in Google MapsTM.
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.
Setup Options
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.
Video Tutorial
Pricing
TripTally is free for seven days, then $67 for a lifetime license. No subscription is needed.
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. The limits are the same in the free and paid versions of TripTally.
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.
Do you have any tutorials for the multiple-column function?
I think this might be exactly the add-on I’m looking for, but I’m struggling with calculating multiple columns.
e.g. Column A = home address B = Monday job C=Tues D=Weds E=Thurs F=Fri
Start address A2: A30
End addresses B2:F30
I’d like a total mileage in Column G for the entire week. Does that make sense?
So Column G = (distance A-B) + (distance B-C) + (distance C-D) + (distance D-E) + (distance E-F)
If it can do that I’ll buy it today!
That makes sense. I whipped up two ways you could do this. The first example is more like you wrote; the second may be faster as one week could be done in a batch. Do a find-and-replace to pre-populate your home address.
https://docs.google.com/spreadsheets/d/1xhN0GpCs-aXRw8CLeWyTkaEa4i6l3SVJdnbljjipsjs/copy
Let me know if this works!
– Adam Steinfurth