In this second episode I show you how to bring in other details like delivery date, destination, weight, and shipment service level.
This new method allows you to track FedEx, UPS, USPS, and many more carriers in the same Google Sheets spreadsheet. You will be able to see the current status of a package—whether it has been delivered, delayed, or held up for some other reason. All you have to do is paste in a tracking number (and copy down the logic columns). Please note that this example is piggy-backing off a Heroku package called, Shipit. Please run your own deployment of Shipit so as to not overwhelm the demo deployment.
Shipit Heroku Package: https://www.npmjs.com/package/shipit
ImportJSON Function: https://www.chicagocomputerclasses.com/google-sheets-import-json-importjson-function/
Copy of Spreadsheet (must be signed in to Google): http://bit.ly/2xtJoX7
Questions? Leave a comment and I'll get back to you.