App Icon
Lovely API
•  679
Overview
Package Tracker gives you status updates of your packages in Google Sheets.
Package Tracker from Lovely API lets you track shipments of your FedEx, UPS, USPS, DHL, Post Austria and Japan Post packages in Google Sheets. Simply enter =status("my-tracking-number") to get the full history or =status("my-tracking-number", false) to get only the latest status.
Reviews
Language:
Sort by:
Profile Picture
A User of Package Tracker
July 9, 2020
Seems pretty good and very responsive! Thinking of buying the full package. Would there be ways to add more carriers like post Austria? I am working with several carrier outside of the ones mentioned in the description however DHL is the main one. Also it would be great if this formula would work in array. Working with over 1k shipments a day and extending that formula manually would be a pain point. I tried it in the free plan but ran into formula errors. "Exception: Limit Exceeded: URLFetch URL Length. (line 188).". Would need this array to run indefinite if possible and self refresh on an update push on e.g. DHL tracking link. "=ArrayFormula(Left(Index(status(C114:C,False),,2),10))" was the formula I used.
Is this review helpful?
Yes
No
Profile Picture
A User of Package Tracker
June 30, 2020
That's a good add-on. Thanks author! You work great! But I have an idea about another function eg.: laststatus to show only lastest status of package.
Is this review helpful?
Yes
No
Profile Pciture
A user of Package Tracker
June 30, 2020
Thanks! You can already do this. For the latest update: =status(B19,false) For just the latest status (which is what I think you're asking) you can wrap that in an index function: =index(status(B19,false),1,1) I didn't want to get too carried away with multiple formulas and this makes it flexible to pull any of the columns...
Profile Picture
Joseph Zangrilli
June 18, 2020
I am unable to update my subscription. manage subscription window only shows me current subscription. I am the admin and have all rights
Is this review helpful?
Yes
No
Profile Picture
A User of Package Tracker
June 8, 2020
Works great for one at a time, but I'd like to track 5000-ish packages ....maybe I'm just missing it, but it seems like you might offer an paid version for that scale of work. I'm interested. Let me know if you are.
Is this review helpful?
Yes
No
Profile Pciture
A user of Package Tracker
June 8, 2020
Yes, we have a paid version. We try to keep the price reasonable. You can upgrade at anytime through Add-ons -> Package Tracker -> Manage Subscription.
Profile Picture
A User of Package Tracker
May 26, 2020
[blockedchain.thirdparty]
Is this review helpful?
Yes
No
Profile Picture
A User of Package Tracker
May 16, 2020
This is awesome, just really wish there was one more column showing the Estimated Time of Arrival in Date format. =(
Is this review helpful?
Yes
No
Profile Picture
A User of Package Tracker
May 15, 2020
Very helpful. A few suggestions: 1. A toggle between true and false 2. Instructions how to use it with multiple tracking numbers would make it easier.
Is this review helpful?
Yes
No
Profile Pciture
A user of Package Tracker
May 16, 2020
1. You can achieve this by passing in a cell reference...e.g. =status("my-number",$A$1). Then, you can change the value in A1 to true/false. If there's a better way then please let me know! 2. For the second one you need to call the formula for each number.
Profile Picture
A User of Package Tracker
April 24, 2020
Does this refresh status as well? If something is "In Transit" will it change to "Delivered" once delivered?
Is this review helpful?
Yes
No
Profile Picture
A User of Package Tracker
April 9, 2020
if I set it to false, it will only give me the status. Is there a way to just get the latest status with date and locations instead of the entire status history?
Is this review helpful?
Yes
No
Profile Pciture
A user of Package Tracker
April 9, 2020
UPDATE: The update you made actually works 100%, please disregard my previous comment. The issue was resolve once I started a new sheet. Thank you very much
Profile Pciture
A user of Package Tracker
April 9, 2020
Wow incredible speedy response. I did notice the update right away before I even read your response to the review. As far as the update is concerned, about 90% of the tracking numbers are showing correctly but some are not. seems random because I am using the same 10 numbers repeating for testing purposes and sometimes it will give the full info and other times it will only show the status. I will email you to better help
Profile Pciture
A user of Package Tracker
April 9, 2020
Great suggestion! I just made the update. Let me know if you experience any issues, etc.
1-9 of 9
Additional information
Lovely API
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu