Google Sheets is a well-known service and online spreadsheet. Google Sheets can be more than just a spreadsheet, it can be used as a back-end or a database for applications. For example, Glide uses Google Sheets as a database for its mobile applications. Glide allows to build a mobile application without any code connected to Google Sheets. It’s incredible how fast you can build a real app, .
I was building an app in Glide that displays the latest news using News API. I connected the app to a Google Sheets spreadsheet where I entered a number of news stories manually. The app looks like this:
This is how the Google Sheets spreadsheets looks:
If I need to update any news I can manually edit the Google Sheets spreadsheets and the Glide app will be updated.
This manual update is not ideal of course.Continue reading “How to update Google Sheets with JSON API”