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

Question

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!

Answer 1

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

Answer 2

You could CRUD Google Sheets using thier api
https://developers.google.com/sheets/api/reference/rest

https://youtu.be/OqDo2L-aSGw

Answer 3

Yes you can, by using google API's

Answer 4

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

Answer 5

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