So, I was creating an app for the Windows Phone platform the other day, and wanted to store some data. But I did not want to shell out money for a full fledged database server. So a question struck my mind. Google sheets allows me to create spreadsheets for FREE! So can I use them to store my tabular data? Since my requirements were much simpler, I did not require to perform any of the database operations such as 'Join' or 'Group By'. I simply needed all the data stored in the table at a particular instant of time.
Note that although Google provides several APIs for Google Sheets but none of them work for the Windows RT platform(at least, this is what I concluded after a couple of days of frantically searching their documentation).
So I finally figured out a way to accomplish what I wanted. I'm demonstrating it from scratch, by creating a spreadsheet. Follow along.
STEP 1: Create a new Google Sheet