I'm looking at using a Google Spreadsheet to store data + allow easy updating. I can get the data form the spreadsheet in JSON but it seems like it needs a lot of formatting before I can get the data into a table. Any ideas how to do this? Thx
I'm looking at using a Google Spreadsheet to store data + allow easy updating. I can get the data form the spreadsheet in JSON but it seems like it needs a lot of formatting before I can get the data into a table. Any ideas how to do this? Thx
Hi @alanstones is there a REST API available for Google Spreadsheet? (I checked and it seems to be supported: https://developers.google.com/sheets/api/reference/rest/ ).
So you do not need to implement anything on your side, just connect the API and bind data to a table.
The procedure should be similar to the one used in the Spotify tutorial.
Thanks - that's a great help. Have it up and running now.
@alanstones cool!