Google Sheets API code example in Javascript ES5

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.

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.

Skills: Javascript

See more: requirements google map api programmer needed javascript, google weather api code india, google map api code delete map, google sheets api javascript example, google spreadsheet javascript get cell value, google sheets api example, google spreadsheet javascript tutorial, read data from google spreadsheet javascript, insert data into google spreadsheet using javascript, google sheets api key example, google sheets javascript functions, google map api tile example, google maps api php example, google map api tileoverlay example, google maps api gps tracking javascript, google analytics ecommerce code example, fetch kmz google earth api code, google alerts api code, google earth api aspnet example, google map api code generator

About the Employer:
( 158 reviews ) Edmonton, Canada

Project ID: #17167002

Awarded to:


" I have used Google Sheets API, have coded Javascript, know ES5 version, know how to use XMLHttpRequest exactly " Dear Employer, Hope you are doing well! I understand your job description very carefully th More

$200 USD in 3 days
(7 Reviews)

6 freelancers are bidding on average $215 for this job

$277 USD in 3 days
(13 Reviews)

hello,dear. It's my pleasure meeting you. I have read your requirements and I fully went through it. I am confident and I am sure that I am able to finish such project. Would you contact me for further discussing. Than More

$155 USD in 1 day
(3 Reviews)

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 8+ years in web designing & development with good experience in following skills More

$200 USD in 3 days
(3 Reviews)

Hello, I invite you on chat to discuss in detail If have one document as requirement plase post it Thanks

$300 USD in 7 days
(14 Reviews)

Hello, I am PHP Expert with 6+ years of strong working experience. I understood and can assist you with your posted job, as per your needs. My past work:Sites - [login to view URL] - https://procurenetwor More

$155 USD in 3 days
(0 Reviews)