Package Tracker - Google Workspace Marketplace

Lovely API

• 1,020

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:

Fgcjr

October 8, 2020

Life saver, really is. Saves so much time.

Is this review helpful?

Yes

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

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.

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

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

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)

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

Randy Taylor

September 16, 2020

I have the same problem. Need to update from Startup.

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

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

Shan Usmani

August 16, 2020

How to use this? please let me know?

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...

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

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

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.