0

Is it possible to read and use data from google spreadsheet using JavaScript?

I am trying to read data from a google spreadsheet by reading data I can able to perform a validation of username and password for my login form of HTML thanks in advance for your answer!

23rd Dec 2019, 2:47 AM
HARSHA ASHMIN
HARSHA ASHMIN - avatar
5 Answers
+ 3
HARSHA Create a Google Sheets from your account, setup the data. Then go to this page https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet On the "Try this API" section, set spreadsheet id and ranges (eg. A1), add more ranges if you need. Press Execute button, you would get the testing api data with the data in the ranges. From the coding section, select Browser, copy the code to code playground. And set your client ID and Api key accordingly. Run it from pc browser. https://code.sololearn.com/Whc3LmvAqZ15/?ref=app
23rd Dec 2019, 2:50 PM
Calviղ
Calviղ - avatar
23rd Dec 2019, 5:01 AM
Calviղ
Calviղ - avatar
0
Yes you can, by using google API's
23rd Dec 2019, 5:06 AM
Abdol Hashimi
Abdol Hashimi - avatar
0
Calviղ I cannot understand can you explain how this is related to my question I like to check the value like username field with password fielt
23rd Dec 2019, 12:26 PM
HARSHA ASHMIN
HARSHA ASHMIN - avatar
0
Calviղ Thanks a lot bro really thanks for your great help if possible please connect with me on sololearn bro let's share our knowledge
24th Dec 2019, 1:35 AM
HARSHA ASHMIN
HARSHA ASHMIN - avatar