I need a formula and/or script written in Google Sheets that will pull the most recent parcel tracking status from [login to view URL] for a list of tracking numbers in Google Sheets. Ideally, the tracking status would dynamically update in the Sheet but it would be fine if I could manually refresh the data in Google Sheets to pull the tracking status each time I look at the list of tracking numbers.
Please check the attachment of how the final data should look like and one more screenshot which represents what exact data needs to be fetched
here are some sample tracking number:
LY218434612CN
LX120454710CN
LY218434515CN
LY218434569CN
LX119814217CN
LY217141626CN
LX119814225CN
LY217141665CN
RS0016848366Y
The formula/script will need to work for a Sheet containing ~3,000 tracking numbers.
Hi! I'm script developer that can retrieve data & do tasks with AUTOMATION.100% ACCURATE!
**I will write in Python > will produce CSV/XLSX file :)
* If you're using windows, i can convert it into EXE.
Let's discuss more details :)
Thank you and i'm looking forward to working with you!
Best Regards,
VincentOng07
this job get done as per your requirement. And this done before deadline. Data will be extracted and will send the proper detail to you. Please me with this job.
hello.
I read your project requirement I understand your requirement .
I have good experience in webscraping .
Instead of any script i can give you google sheets having your 3000 tracking number'status and also tell the process of doing the same manually within 5 minutes.
thank you so much.