Convert Google Sheet to SQLite

May be you are interested in convert a Google Sheet to SQL compatible database. In order to do that, different approaches can be used. The one I have selected is to convert the GSheet to a SQLite file. If you can achieve this file, there are a lot of converters out there to have the […]

Read More

Select a Google Drive file with picker

The use of Google picker to select a file is very easy, documentation is here. One problem I have encountered is related with authorization. For asking for permisson to select a file (with picker) you need the access_token provided in the client side. But then, you may need to process the file in server side, […]

Read More

Access Google sheets with user authorization

Google user authorizing When accessing Google spreadsheets, we have two scenarios. The first one, is when your web app needs to access a spreadsheet of your own. In this case, your app needs an OAuth2 service account credential to act on your behalf, cause you are the propietary of the file. See my previous article […]

Read More

Google sheets as SQL backend database

Google Spreadsheet as a private and secure backend SQL database for a web page (with screenshots) with PHP Introduction Almost every application needs a database to grab data from. One of the most popular is SQL based databases as MySQL, PosgreSQL o MariaDB. The use of these servers requires the installation somewhere and enough resources. […]

Read More