0

Can javascript retrieve username and password from google spreadsheet, where google spreadsheet store username and password like below,

row 1 user1,pass1 row 2 user2,pass2

Parag Jadhav
  • 1,853
  • 2
  • 24
  • 41

1 Answers1

1

You directly can not use JavaScript to access Google Spreadsheet. Instead you can use Google Apps Script having almost all functionalities of JavaScript. You can read about Google Apps Script here

Using Apps Script Spreadsheet API you can perform CRUD operations on spreadsheet. Hope this helps

Parag Jadhav
  • 1,853
  • 2
  • 24
  • 41
  • That's not accurate. You can file/publish the spreadsheet and access it as JSONP without any API. It wouldn't be a good thing to do when there are passwords stored there, but it's not impossible. – alotropico May 13 '21 at 23:43