Find Jobs
Hire Freelancers

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

$40-70 USD

Stengt
Lagt ut nesten 2 år siden

$40-70 USD

Betalt ved levering
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
Prosjekt-ID: 34300222

Om prosjektet

10 forslag
Eksternt prosjekt
Aktiv 2 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
10 frilansere byr i gjennomsnitt $66 USD for denne jobben
Brukeravatar
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 each provider? Roman
$90 USD om 1 dag
5,0 (40 omtaler)
4,8
4,8
Brukeravatar
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 message me if this is something you can consider, I'll be standing by to help. -Ige
$40 USD om 1 dag
5,0 (12 omtaler)
4,0
4,0
Brukeravatar
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 scraped automatically or by API calls. With over 30 years of experience in the industry, I’ve not only learned how to develop, but how to work with clients, and I pride myself on bringing my clients high-end solutions and lifetime support. I’m incredibly well-versed in Google software, including: ● Google Sheets ● Google Apps Script ● Google Forms ● Google Data Studio Through this expertise, I’ve created some strong assets that I’m happy to share with you if you’re interested in perusing my professional portfolio. If you’re looking for an Engineer who can develop through Google software fast, efficiently, and with great results, I’m the person for you.
$90 USD om 7 dager
4,9 (19 omtaler)
4,2
4,2
Brukeravatar
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 anticipating from this platfrom give me a chance to show you the best i can do at your service.
$70 USD om 1 dag
4,9 (12 omtaler)
3,6
3,6
Brukeravatar
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 library, and then adding the button of macro to sheet. I have 2 certificates in VBA and I've already worked on two projects in VBA one was to create a full tracking sheet for a production line and the other one was to create a full data entry user form. I'll be very happy if contacted me to discuss it.
$40 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

CANADAs flagg
Victoria, Canada
4,9
426
Betalingsmetode bekreftet
Medlem siden jan. 19, 2008

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.