How to build API for free using Google Sheets

Google Sheets as database, Apps Script as backend

Article income earned in February and March will be donated to charities helping Ukraine. Donate for Ukraine: https://bank.gov.ua/en/news/all/natsionalniy-bank-vidkriv-spetsrahunok-dlya-zboru-koshtiv-na-potrebi-armiyi

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…