App Icon
Lovely API
•  1,317
Overview
📦 Package Tracker tracks your packages in Google Sheets.
📦 Package Tracker from Lovely API lets you easily track thousands of shipments in Google Sheets. A great choice for ecommerce and other retail companies, eBay / Amazon / Shopify sellers, and others! Know the status of your customer's packages from when it left your inventory wareheouse to final delivery!

🚚 Supported carrierrs:
Austrian Post
Canada Post
China Post
DHL
FedEx (Federal Express)
GEL Express Logistik
GLS
Japan Post
TNT
UPS (United Parcel Service)
USPS (United States Postal Service)
Yanwen

If there is a carrier you need please reach out at support@lovelyapi.com and we can add it!

Our custom function lets you specify the columns you want (status message, delivery date, etc) as well as whether or not to include the full history:

=track("my-number", "status,provider,date,location,delivered,url,expected", false)

Once installed, you can access our F.A.Q., which is full of tips, including how to refresh the status. 

Reviews
Language:
Sort by:
Profile Picture
Tyler Irvin
November 14, 2020
This is exactly what I was looking for, We are able to keep up with parts easier, It makes my life and our staff's life easier. It's worth the price. Had some issues with the subscription, but was resolved immediately. I am impressed by the functionality, but even more impressed by the responsiveness of the creator. Great work!.
Is this review helpful?
Yes
No
Profile Pciture
Lovely API
November 15, 2020
I really appreciate the great feedback! We are addressing the subscription issues and will have them resolved soon!
Profile Picture
Fgcjr
October 8, 2020
Life saver, really is. Saves so much time.
Is this review helpful?
Yes
No
Profile Picture
Kevthulhu
September 16, 2020
I've seen a few other folks post about this, but don't see the fix. How do I change my subscription to a higher API call volume? I'm at a point now where I'm typically needing to track 200+ packs per day across USPS and UPS.
Is this review helpful?
Yes
No
Profile Pciture
Lovely API
September 16, 2020
Hi, We are working on automating the process but for right now it is manual. Please email us and we can get the process started.
Profile Picture
Sam Smith
September 8, 2020
=status(O1, false) This is just great, but, please, add auto refresh of the tracking status, like every hour. If you able to do so, I'll pay for lifetime subscription. (for many years, I mean) This script is really helpful, thank you!
Is this review helpful?
Yes
No
Profile Pciture
Bryan O
September 22, 2020
Hello I'm trying to get a fix on DHL tracking numbers that do not update. All I can see is just 'Shipping Label Created' no matter you use Index or Status formula. please help!! Thanks
Profile Pciture
Lovely API
September 9, 2020
Hi, Google Sheets doesn't allow you to auto refresh custom formulas. However, a workaround is to append a cell reference to the end: =status(O1, false, $A$1) When the value in $A$1 changes the cell will update. If you just want to get the delivery status you can wrap it in an index function: =index(status(O1, false, $A$1), 1, 1)
Profile Picture
Phil Orr
August 18, 2020
Hi, this is great but i'm having trouble updating my subscription. Same as Joseph Z below, I am unable to update my subscription. The manage subscription window only shows me current subscription. I am trying to upgrade but cannot.
Is this review helpful?
Yes
No
Profile Pciture
Randy Taylor
September 16, 2020
I have the same problem. Need to update from Startup.
Profile Picture
jelle gerritsma
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
Shan Usmani
August 16, 2020
How to use this? please let me know?
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
1-10 of 14
Additional information
Lovely API
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu