Re:How to use a Google Spreadsheet as a database
by jontro on Tuesday March 24, 2015 @05:56PM
(#9259781)
I was looking for the google spreadsheets api earlier today and I noticed it has not been migrated away from GData yet. I wonder why this is not getting any love
https://code.google.com/p/gdata-java-client/ <--- Spreadsheets api is one of the three apis still alive out of all gdata apis
We went from using Spreadsheets to using our own flat files on Drive, but the API service would throw random rejection errors for both.
Long story short, we learned that you should not try to use Drive or Google docs as a program database. It's designed first and foremost for users.