Javascript functions to work with Google Docs / Sheets
$30-250 USD
Abgeschlossen
Veröffentlicht vor etwa 9 Jahren
$30-250 USD
Bezahlt bei Lieferung
We need a library of functions in javascript that can read, write and append data to a google sheet. We need the functions:
1. Create a google sheet with a given name. In our case the google sheet will contain contact information. Columns include: First Name, Last Name, Title, Company, Website, Email, Phone, Phone 2, Street, City, State, Zip, Country, LinkedIn, Twitter, Facebook, Google Plus
2. Query sheet to get all data, include row ID returned with the data
3. Write function should override ("patch") the values that are filled in
Example: we will send array [ { "id": 1, "Email": "xxx@yyy" }, { "id": 3, "Email": "zzz@yyy etc" } ] and only column Email for rows 1 and 3 will be updated
4. Append to end of sheet
To show that your FULLY read this description, put the name of your favorite music type in the first line of your bid/message. Generic bids without details about why we should pick you will be ignored.
RAP
Hi,
I have gone through your requirements and I can create a javascript app that can read,modify and append to google spreadsheet. Pls clarify the following.
1. will the sheet with all the columns will exists or needs to be created programatically? If existing file means, will the user needs to provide url or needs to be picked from google drive?
Pls PM me to discuss further details.
I have 3+ years of front-end devlopment using HTML, CSS, JS, jQuery, Bootstrap and AngualarJS. I am proficient programmer in asp.net and php also. I can assure you that I will provide quality work in given time period without any issues. The final code will be delivered with comments and documentation.
Looking forward to work with you,
Kasi
$222 USD in 3 Tagen
5,0 (73 Bewertungen)
7,2
7,2
5 Freelancer bieten im Durchschnitt $212 USD für diesen Auftrag
Hello!
I listen to alternative rock, alternative metal, electronic rock, sometimes modern dance music. But it depends on the mood I'm in really. At certain periods of my life I even liked classical music :)
And now a little bit about why you should select me among others: I'm a big fan of JavaScript/Node.js/React.js with strong knowledges in OOP, Java, Python and JS of course.
In order to solve your task I would use existent JavaScript wrapper to the Google Sheets API version 3.0.
The biggest issue I see at the moment is creating a spreadsheet since it is not supported by Google Sheets API: so I will use Google Drive API to upload a template (otherwise I will create it manually using API) and later I will be able to modify it using Google Sheets API. The Sheets API does not currently provide a way to delete a spreadsheet, but this is also provided in the Google Drive API.
The task is not a hard one but some pitfalls are possible. I can accomplish the task in 3-4 business days. Since I'm new in Freelancer service (though I worked over 8 years as an in-house software engineer) and I need to rise my reputation on Freelancer, I will give you 70% off from my regular rate that is $30/h. Please give me a chance to resolve your issue and get a good feedback.
Thanks,
Alex Tunyk
Alternative Metal
Greetings,
I am software developer with expertise in javascript and .NET/C#. I can speak English fluently, so communication won't be a problem. I can start on this project as soon as it is awarded to me.
- What kind of format do you want the data retrieved with the Query at step 2?
For any details/questions feel free to contact me.
Pop rock
I've successfully completed a number of projects that involve creating google app script to automate tasks in Google Sheets. I've done projects ranging from URL shortener to website scraping and data manipulation. I've also create scripts that allows a user to input a data through a pop-up window which I think will be required by your project. I'd like to know more about the project so I'm hoping I'd have the chance to talk to you. Thanks!