Find Jobs
Hire Freelancers

From Google Drive to Google Sheets with some conditions

€30-250 EUR

Completed
Posted over 7 years ago

€30-250 EUR

Paid on delivery
Hi We have an excel file being uploaded every night to our Google Drive. This EXCEL file contains rows uniquely identified by an unique ID (first column of the EXCEL File). We have a Google Sheet which has the same data structure as the EXCEL file on Google Drive. We would like to have a script that runs every night and add rows to the Google Sheet with the information contained in the EXCEL but only for NEW ID's (I mean we dont want duplicates in the Google Sheets Upon completion, the script should send an email with status (OK, KO...)
Project ID: 12762668

About the project

11 proposals
Remote project
Active 7 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
Hello there! I can help you with that. The Google script will run using a time driven trigger. It will convert the Excel file into a temporary Google spreadsheet. Then compare the produced spreadsheet with the old spreadsheet you have. If new rows with new ids are added, it will add them to the original Google spreadsheet. After that the temporary spreadsheet will be removed. Then the email will be sent, it will contain the new rows added if there are any! I know that I have few reviews here, but all of them are related to Google script projects. I have started my freelancing career on Upwork. I am a top rated freelancer with a job success score of 99% :-) I am trying to build a good profile here by offering the most competitive price! All the best, Mohamed
€80 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
11 freelancers are bidding on average €158 EUR for this job
User Avatar
Hi, can help. Will develop that script. Regards, Viktor
€111 EUR in 2 days
4.8 (28 reviews)
5.5
5.5
User Avatar
Hello, I have good experience dealing with Google spreadsheets, what I have to do is converting the xls file to a temporary Google spreadsheet then add the new rows to the target Google sheet, at last I'll delete the temporary spreadsheet and send the email. Regards.
€60 EUR in 1 day
4.9 (23 reviews)
5.0
5.0
User Avatar
Hello! I've read your brief and it matches similar work I've done in the past. Please contact me so we can discuss further. Thanks
€244 EUR in 3 days
4.3 (14 reviews)
4.6
4.6
User Avatar
Hi, I am good at Excel and google scripts. I have gone through the details of the project. Plz provide me the files to get more information and see the possiblities. Looking forward to discuss in the chat.
€250 EUR in 3 days
5.0 (1 review)
2.4
2.4
User Avatar
Hello, i'm comfortable with both excel and google sheets and i can write script to run on your google drive. I can start tomorrow and finish it till monday evening. Thank you have a nice day. Oğuz
€98 EUR in 4 days
4.8 (1 review)
0.4
0.4
User Avatar
Hey, I am the most suitable candidate because of the knowledge I have. I know how to make such kind of scripts, and secondly I am working on a LIVE PROJECT that is ELASTICSEARCH and KIBANA which is used by all the tech Giants such as Facebook, Microsoft and many more, which has helped me make my basics concrete. Hope this was enough to give a brief into of mine. If you want to clarify anything just email me.
€222 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi my name is Raj . I have already worked on Google scripts. please check my profile and let me know if you are interested thanks
€111 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, i have 3 models of this google script. I can finish your code in 2 days maximum. Please let me know more details about your project. Best regards.
€55 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Project Provider, I have understood your requirement for updating a Google Spreadsheet from new records of an MS Excel file. I strongly believe I could support, deliver and deploy the required codes with a better efficiency. My codes are having a better adaptability for huge records. Hope, we could discuss further to achieve the same.
€111 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey there - I have scripts written in Google Apps which can complete the first half of the task you are looking to achieve, I can edit it to achieve the second part pretty quickly I believe. I'm looking to win my first freelancer project so I'm very keen to please! Thanks!
€98 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of FRANCE
Pertuis, France
4.9
15
Payment method verified
Member since Jan 4, 2012

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.