Build An API in Google Sheets and Google Apps Script
How to build a whole API in Google Sheets, sourcing data from a Google sheet you write, and retrieving it via HTTP Get.
How to use Google Sheets as JSON Database for Web Apps
How to use Google Sheets as the back-end database for a web application, producing JSON.