Using Google Spreadsheet as a Database for Applications

I want to use Google spreadsheets to store data on the Internet, so that several people can enter and maintain data, and then publish or export (csv, xls, ods) sheet for their application. What is the easiest way to process a sheet? If the data can be accessed by reference, updates can be immediately reflected in the client application.

+3
source share
3 answers

In this article , the Wikipedia Data Scraper with Google Spreadsheets is discussed using Google spreadsheets as an application platform.

, , , , , .

+3

5 , Google SQL- -:

http://gqlx.twyst.co.za

-, , , , , .

+1

, , Google, ? , ? , .

You can have a Google spreadsheet as a database, and the client application can directly access this data through the APIs — the spreadsheet APIs. If you need a simple link where people can go and upgrade, you can also use a web application that uses Google application scripts. very easy to use and would also solve your goal: why export your data to ods, xls, csv, create an application directly above Google Spreadsheet. Will also be supported.

0
source

Source: https://habr.com/ru/post/1698825/


All Articles