Find Jobs
Hire Freelancers

Only Apply if experience on Es5 & Google Sheets API

$50-102 USD

Completed
Posted almost 6 years ago

$50-102 USD

Paid on delivery
I'm having difficulty understanding how to use the Google Sheets API, so for this project, I want to hire someone who has successfully used Google Sheets API before, and provide examples of code and data-structures for me, in Javascript ES5. Note, my Javascript interpreter is ES5, not the ES6 version in current web browsers. Also note: must use XMLHttpRequest for POST'ing to the URL. DO NOT USE AJAX, it is not available in my project. I have an API authorization key you can use, if needed, but it's probably easier for you to create your own Google API credentials and thereby be in control of everything while you are working on it. I need to be able to create 1 spreadsheet. Then I need to be able to add rows, one at a time to the bottom of a collection of values, each row will have about 4 values to put into columns. Lets say the data is 2 integer numbers and 2 dates. I need a SUM() of each column of integers, an AVERAGE() of each column of integers, a COUNT() of each column of integers. I need to be able to open a web browser, navigate myself to Google Sheets, open up this spreadsheet, and look at it. I don't even know how to do that, from having a spreadsheet ID, I dont' know how to open that kind of spreadsheet and look at it. My budget for this is in between $50- $100 only . Lowest bids win. To be awarded this project, tell me in your response, that you have used Google Sheets API, have coded Javascript, know ES5 version, know how to use XMLHttpRequest. If you don't mention these things, you won't get the project awarded.
Project ID: 17175043

About the project

2 proposals
Remote project
Active 6 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 Priyanka, I read your project description. I can write the ES5 compatible JavaScript code for you which uses Google Sheets API v4 to create the spreadsheet programmatically and enter the data you want in the order you described but my question is where do I get the data? You also mentioned that a freelancer must use XMLHttpRequest object for making POST call to a URL but should not use AJAX. Madam, I would like to tell you that using XMLHttpRequest object to send data to the URL is actually an AJAX call itself, no matter whether that call is a GET or POST. I would like to assure you that I'm familiar and have experience in writing code for Google Sheets. I'll use my own API key for doing this project and will hand over the code to you after testing and making sure that everything is working correctly. You have to enter your own API key in that code at the top of the file to a variable which I'll define for you. If you would like to discuss your project with me then send me a message even while I'm offline. I'll try my best to give you a reply as soon as possible.
$50 USD in 1 day
4.8 (20 reviews)
4.7
4.7
2 freelancers are bidding on average $53 USD for this job
User Avatar
I used Google Sheets API, have coded Javascript, know ES5 version, know how to use XMLHttpRequest. I am Senior Website Developer, with 3 years experience.I am familiar with JavaScript ES5 and http requests. I am new on freelancer, so will working for less budget, just because some good reviews. Thanks, Jitendra
$55 USD in 3 days
5.0 (2 reviews)
1.4
1.4

About the client

Flag of INDIA
mohali, India
1.0
1
Member since Jun 15, 2018

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.