5

Is there a way to store/retrieve values to/from the google spreadsheet cells using javascript? What I want: To store data to spreadsheet instead of database.

  • Yes. Consider using Google Fusion Tables as your data source - the API is quite simple and well adapted to use in javascript. – sideroxylon Sep 29 '13 at 11:13

1 Answers1

2

The Google Apps Script Developer Guide has tutorial on how to access spreadsheet data rows as Javascript objects:

https://developers.google.com/apps-script/guides/sheets#reading

Andrew M.
  • 283
  • 2
  • 9
  • Also see the [Full Code section of this tutorial](https://developers.google.com/apps-script/articles/mail_merge#section-5-full-code), where the getRowsData() function will read the data into an array of objects using a header row as the index name. – Karl_S Nov 29 '16 at 20:20