Google sheets expert to fetch and automate delivery date from ups, fedex and ups
Budget: $40 – $70 USD
We need a google sheet expert who can create a simple automation script that will take tracking numbers
I am attaching a sample google sheet (as excel file to this email) but you need to do this in Google sheet
This is what I need:-
1) Take tracking number in column C, and update column J (is package delivered)
2) If package is delivered, then column K should have the delivery date
3) Column L is simply column K delivery date + 5 extra days
4) Very important: the actual google sheet will have more than 10,000 tracking numbers. So the script should only fetch the tracking numbers for those Rows where Column J is either empty (no value), or Column J is No (for package not delivered)
We need a button in google sheet, to run this script whenver we want.
The actual google sheet will have more 10,000 tracking numbers. So the script should only fetch the new updated tracking numbe
This is urgent if you can do this by monday
I am attaching a sample google sheet (as excel file to this email) but you need to do this in Google sheet
This is what I need:-
1) Take tracking number in column C, and update column J (is package delivered)
2) If package is delivered, then column K should have the delivery date
3) Column L is simply column K delivery date + 5 extra days
4) Very important: the actual google sheet will have more than 10,000 tracking numbers. So the script should only fetch the tracking numbers for those Rows where Column J is either empty (no value), or Column J is No (for package not delivered)
We need a button in google sheet, to run this script whenver we want.
The actual google sheet will have more 10,000 tracking numbers. So the script should only fetch the new updated tracking numbe
This is urgent if you can do this by monday