Find Jobs
Hire Freelancers

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

$40-70 USD

Closed
Posted over 1 year ago

$40-70 USD

Paid on delivery
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
Project ID: 34300222

About the project

10 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $66 USD for this job
User Avatar
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 in 1 day
5.0 (40 reviews)
4.8
4.8
User Avatar
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 in 1 day
5.0 (12 reviews)
4.0
4.0
User Avatar
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 in 7 days
4.9 (19 reviews)
4.2
4.2
User Avatar
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 in 1 day
4.9 (12 reviews)
3.6
3.6
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Victoria, Canada
4.9
426
Payment method verified
Member since Jan 19, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.