Find Jobs
Hire Freelancers

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

$40-70 USD

Cerrado
Publicado hace más de 1 año

$40-70 USD

Pagado a la entrega
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
ID del proyecto: 34300222

Información sobre el proyecto

10 propuestas
Proyecto remoto
Activo hace 2 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
10 freelancers están ofertando un promedio de $66 USD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (40 comentarios)
4,8
4,8
Avatar del usuario
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 en 1 día
5,0 (12 comentarios)
4,0
4,0
Avatar del usuario
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 en 7 días
4,9 (19 comentarios)
4,2
4,2
Avatar del usuario
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 en 1 día
4,9 (12 comentarios)
3,6
3,6
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Victoria, Canada
4,9
426
Forma de pago verificada
Miembro desde ene 19, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.