Find Jobs
Hire Freelancers

Simple Google Sheets Script

$10-30 AUD

Completed
Posted over 8 years ago

$10-30 AUD

Paid on delivery
Hello This is a simple project. We have a .csv spreadsheet sent daily to us in gmail (Filename with date). We currently use a script to save this to our Drive daily. There is a Google Sheet which holds some data which needs to be updated (with new data coming in through .csv). We need a script that goes into the latest downloaded .csv file in a folder (by date is best), extracts a range, and copies it into the Google Sheet we already have. We need to be able to set this script to run daily at a certain time. The end of the script has to sort by one of the columns. Something similar to this should work: [login to view URL] We would need the code with instructions on how to apply it to our filenames/foldernames and with annotations. Thanks Alex
Project ID: 8816925

About the project

5 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
Hi Alex, can help. You want update a whole row/rows from new file or some certain data in the row? Do you have a sample? Will provide you script with all need instructions. Regards, Viktor
$25 AUD in 1 day
4.7 (10 reviews)
4.1
4.1
5 freelancers are bidding on average $26 AUD for this job
User Avatar
Hi: Please note that I have 100% completion rate and 5-star feedback on projects. Please review my profile to confirm the same. Please message me to discuss this in detail.
$30 AUD in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a software developer with more than 3+ years experience in developing mobile and web applications in Samsung Electronics. I have read and understood your requirements and can do this job. I will make an auto trigger Google Apps Script which will take the csv file, parse it and adds the data to the specified Google Sheet. I am well versed with Google Apps Scripts and have done projects leveraging the use of Google Sheets, Forms and other Google services with GAS. I can debug existing GAS or implement new features as required. Please feel free to contact me so we may discuss more regarding your requirements and achieve an optimized solution. Regards, Suhail
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
9
Payment method verified
Member since Dec 15, 2013

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.