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 situations, I usually turn to the Google ecosystem and their Apps Script.
In this article, I will show you how to make a simple Rest-ish API that will have Google Sheets as its base. The API after accessing its URL will return JSON with the data from the table. To understand this article, all you need is a basic knowledge of programming (preferably JavaScript) and Google Workspace.
Read more:
https://fischerbach.medium.com/how-to-build-api-for-free-using-google-sheets-6c2b2e951a70
Top comments (2)
great discussion though! for few days i have been looking for an API tool to integrate with my google sheets. after 2days of finding i discovered an API tool of Sheet Best, which is really helpful and time saving for me. it's seem like simple and easy to use, edit and read. do you have any idea about it? what do you think about Sheet Best API tool?
Great discussion.. thnk you!