Can I make Google Drive Spreadsheets act like a MySQL database?

Jacob picture Jacob · Apr 13, 2013 · Viewed 32.6k times · Source

Can I use a Google Drive spreadsheet as if it were (similar to) a MySQL database?

I'm thinking of using it as a player database for an HTML/JavaScript web game. The player's username, password, and score among other things would be saved in the database. It would be really interesting if it could actually work, however it of course has to be secure and private so that no player (or anyone on the internet for that matter) can access it except the owner of the spreadsheet which would be me for example.

I know that Google Apps Script allows a user to access their own spreadsheet and read/write to it, but is there a way that I could allow other users to "save their score" to MY spreadsheet WITHOUT giving them permission to view/edit the spreadsheet directly?

Also, i'm assuming PHP/Python/some other server-side language would have to be used in order to hide my account info which I also assume would be needed to open and close the connection with my spreadsheet.

Anyways, I'm just wondering if this is feasible.. literally turning a Google Drive spreadsheet into a database that players can update their score to but not have direct access to it.

This may be a stupid idea, so your opinions are welcome!

Thanks in advance!

Answer

Jus12 picture Jus12 · Dec 14, 2013

This is the right way to do it. Another post explaining the same idea. Essentially, we publish the spreadsheet and query it using a "select"-like syntax. For instance: this query which reads something like:

https://spreadsheets.google.com/tq?tqx=out:html&tq=select+B,C,I&key=phNtm3LmDZEObQ2itmSqHIA

This is for querying data (reading). For inserting, you can use google forms (create a form, see its html and submit using a http post request). I have not explored update yet.

And yes, this has to be done server side.