DEV Community

Cover image for How to build API for free using Google Sheets

How to build API for free using Google Sheets

Originally published at fischerbach.Medium ・1 min read

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:

Discussion (1)

bluecommunitysustainability profile image

Great discussion.. thnk you!