We buy many items, many shipment from [url removed, login to view], ebay.com. Each shipment is a tracking number. So, I want to track every shipment status is: Pre-ship, or In Transit or Delivered?
In my Google Spreadsheet, examples:
+ Column 1 is tracking number. Example: 9405509699937090699589
+ Column 2 is: Carrier. Example: USPS
+ Column 3: This is script you will code. This cell at column 3 will show: Shipment status: Pre-Ship or InTransit or Delivered ( Script will use tracking number, make a web query to Carrier's website and get information)
+ Column 4:
- Copy tracking number to gmail and search in gmail: If found, show value in cell is: "Delivered in dd/mm/yyyy". ( This is optional, not required )
- If cell in column 3 is delivered before Thursday. Value is Tuesday nextweek. If Thursday or after. Value is " Estimate Tuesday next 2 weeks ".
Thanks for reading and join.
10 freelancers are bidding on average $186 for this job
I have expirience working with google spreadsheets and writing custom sheets. I thrive on communication and can assure you my work will meet your demands.