How to build API for free using Google Sheets

Google Sheets as database, Apps Script as backend

Sometimes we have some data stored in a spreadsheet that we would like to make available to other applications, such as dashboards that visualise it. Of course, the growing number of applications and functionalities most often leads to a transition to the use of a real database. But sometimes, we have to deal with a one-shot to test an idea or a set-and-forget tool. Then dealing with the administrative side of things, servers, etc., can be extremely cumbersome. In these…