Glasses in front of a computer screen

Google Sheets as a Back-end

Overview

 Have you ever needed a quick and easy way to get data but didn’t want to hassle with getting a full blown database setup?  Well I was pleased to recently discover that you can very quickly and easily get access to and display data stored in a google sheet on your website.  What makes this really easy and thus appealing is that you do not need to gain access to this data via the Google Sheets API, rather you can get a JSON representation with a simple URL.  Today we will look at this in detail and discuss the various considerations that should be made when using such a technique.