I think this will work:
1. Use one of these to connect to the Shopify API: https://gsuite.google.com/marketplace/search/api
2. Use this one to track my packages: https://gsuite.google.com/marketplace/app/package_tracker/896633196427. Apparently the creator of this is porting it to Excel soon so I'll use that when it's available.
I would recommend you use the Order Custom Tracker app. Order Custom Tracker by Buddy Apps is a Shopify app designed to help you create unlimited number of custom statuses for each of your customers’ order. You could manage the order status easily in a single click, as well as add an orders status tracker on any page you want. Plus, the app allows you to upload orders status in bulk with an Excel spreadsheet, so that you don’t waste your time doing the tiring manual work. The app also allows buyers to look up their order status without signing in.
You can get the app via this article: Best Shopify order tracking apps for merchants in 2020.
Hope it helps!