Encerrado

Google sheets expert to fetch and automate delivery date from ups, fedex and ups

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

Habilidades: Google Sheets, Excel Macros, Instalação de Script

Sobre o Cliente:
( 426 comentários ) Victoria, Canada

ID do Projeto: #34300222

10 freelancers estão ofertando em média $66 nesse trabalho

(70 Comentários)
6.2
(23 Comentários)
5.1
(19 Comentários)
4.6
gangabass

I can provide you Google Apps script (that will work with your Google Sheet) for just $90 total (UPS, USPS and FedEx). It will check tracking numbers where Column J is empty or "No" like you want. Do you have API for e Mais

$90 USD em 1 dia
(40 Comentários)
4.8
IgeS

Hi there, Google Sheet built-in formulas suffice for your requirements. I can put a formula that expands automatically in Column L that adds 5 days to the date in Colum K if Column J is not empty nor No. Please messag Mais

$40 USD em 1 dia
(12 Comentários)
4.0
aruls1962

I’m a professional Engineer who has spent the past 7 years building, developing, and perfecting systems (from the ground up) through Google Sheets. I can fetch from the web sites mentioned if they allow data to be scra Mais

$90 USD in 7 dias
(19 Comentários)
4.2
merinsinha

Google sheets expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipa Mais

$70 USD em 1 dia
(12 Comentários)
3.6
(2 Comentários)
3.2
(2 Comentários)
2.6
NaderShehata

Hi, it seems like you are trying to create a script that tracks the delivered and undelivered orders. We can do that easily by creating the macro in VBA then connecting it to the google sheet by the google ApisVBA libr Mais

$40 USD in 3 dias
(0 Comentários)
0.0